Alex Matzinger
asked on
Rman won't delete archivelogs
Hello,
I have an oracle 11.2.0 database which i backup nightly using rman. This database used to have a standby database, which recently was removed from the system. I have deferred log shipping to this destination.
When i run an rman backup though i get the following message:
I was wondering how i can get RMAN to delete archive logs, and stop saving them for my non-existent standby database.
Thank You
I have an oracle 11.2.0 database which i backup nightly using rman. This database used to have a standby database, which recently was removed from the system. I have deferred log shipping to this destination.
When i run an rman backup though i get the following message:
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
I was wondering how i can get RMAN to delete archive logs, and stop saving them for my non-existent standby database.
Thank You
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i've checked the show all command, and it shows this:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
The command i use to delete the logs is this:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
The command i use to delete the logs is this:
backup
as compressed backupset
skip inaccessible
archivelog until time 'sysdate-2'
format '/u07/oraflash/ORATEST/ORATEST.arc_%U.rman'
delete input;
Have you manually deleted any archivelogs? If so, you'll need to run crossckeck archivelog all;
Subsequently, try the backup command again and see if it deletes the appropriate copies.
R.
Subsequently, try the backup command again and see if it deletes the appropriate copies.
R.
ASKER
Yes, i have deleted the archive logs by hand. I also have been running a crossckeck archivelog all; whenever i do this. Even after crosschecking the logs, they still not being deleted by rman.
Have you tried running things on the command line rather than in a run block?
Try the following:
Now that you've run the crosscheck command then try this:
delete noprompt expired archivelog all;
BTW, did you get any messages when you ran the crosscheck command?
R.
Try the following:
Now that you've run the crosscheck command then try this:
delete noprompt expired archivelog all;
BTW, did you get any messages when you ran the crosscheck command?
R.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've run the cross check, and got the standard, these logs failed, and then the i found these logs that it gives when you crosscheck.
I'm going to try and add in delete force input into my backup script tonight, and hope this solves the issue. I was able to delete them using delete force from the command line.
I've also opened up an SR with oracle to try and find a true solution for getting rman to forget about a standby database.
I'm going to try and add in delete force input into my backup script tonight, and hope this solves the issue. I was able to delete them using delete force from the command line.
I've also opened up an SR with oracle to try and find a true solution for getting rman to forget about a standby database.
Notice I posted:
CHANGE ARCHIVELOG ALL CROSSCHECK;And not:
CROSSCHECK ARCHIVELOG ALL;Which are different.
ASKER
This problem worked itself out (a mysterious "oh it just started working again issue"). We tried several parameter changes as suggested by oracle, but they didn't seem to work, and we were directed to change them back to default, then it started working, not sure how, thanks to everyone for your suggestions
what command do you give rman to delete archivelogs ?