getting rid of Foreign Archive Logs

select file_type, space_used*percent_space_used/100/1024/1024 used,
space_reclaimable*percent_space_reclaimable/100/1024/1024 reclaimable,frau.number_of_files
from v$recovery_file_dest rfd, v$flash_recovery_area_usage frau;
These foreign archive logs were from a previous incarnation of the database so how do we delete them as they were no longer needed 
using RMAN

RMAN> crosscheck foreign archivelog all;

RMAN> delete expired foreign archivelog all;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: