Hi friends,
Today we see how to delete archive forcefully using RMAN.
When some of archives are being deleted from disk and RMAN still consider those archives due to retention period. Then we can delete those archives from rman metadata using following command.
RMAN>delete unavailable;
If we are getting some specific archive related error or want to delete some specific archives from RMAN metadata then we can use following command for deleting it from rman metadata.
RMAN>delete force archivelog SEQUENCE 18314 THREAD 1;
RMAN>delete force archivelog SEQUENCE 18786 THREAD 2;
Otherwise general option for deleting archives from RMAN metadata for those archives which are already obsolete.
RMAN>crosscheck archivelog all;
RMAN>DELETE OBSOLETE;
Dbametrix is one of the leading remote Oracle DBA support service provider and we offer remote Oracle DBA support service with a very low cost. The client of Dbametrix can able to put trust in the company because Dbametrix delivers cost-effective remote dba plan using Service Level Agreement SLA and response time matrix. Due to this reason every client gets maximum satisfaction from our deliverable.
Thanks and regards,
Dbametrix Remote DBA team
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.
Hi,
This is impressive… I never tried the delete unavailable command yet..
But try it and see, what is the effect…
Thanks for a great article..
Regards,
Sheldon.