delete expired archive logs

If archive logs are deleted by OS level, these archive logs information will be still in controlfile. So to remove these information from controlfile, you need to crosscheck archive logs and then execute delete expired archive logs.

Note: this command will not delete any archive logs. it will only check archive logs are not available those will be marked as expired in controlfile. So you only can remove the information from controlfile.

rman target /
run
{
allocate channel d1 type disk;
crosscheck archivelogs;
delete noprompt expired archivelog all;
}
exit;
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s