patternMinor
Right way to delete the archive - Oracle
Viewed 0 times
thedeleterightwayoraclearchive
Problem
So I have an Oracle database (standalone) running in RHEL and I have scheduled RMAN for backups on daily and weekly basis. Sometimes my file system (archive mount-point) becomes full because of high archive generation. Now what is the right way to delete the archives from the file system?
My RMAN script has this
but the above command isnt deleteing the archives properly as I see, some of the very old archives are still there..
How to delete them properly?
Should I run crosscheck archivelog all? and then run the above command once again? What is the right way?
Thanks!
My RMAN script has this
delete archivelog all completed before 'SYSDATE-5'but the above command isnt deleteing the archives properly as I see, some of the very old archives are still there..
How to delete them properly?
Should I run crosscheck archivelog all? and then run the above command once again? What is the right way?
Thanks!
Solution
In order to delete them you can do:
RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all; , you can also include the delete input clause when you back them up, and they will be deleted after they have been backed up (it is up to you). You can try and run the command you have shown manually to see what will happen in RMAN (in other words, does it work or does it give an error).Context
StackExchange Database Administrators Q#118686, answer score: 9
Revisions (0)
No revisions yet.