RMAN backup error
I have a 2 node RAC database which is using ASM. I am using RMAN to backup the database. For the RMAN backups we do not have a recovery catalog, we are using the controlfile. My 'control_file_record_keep_time' parameter is setup at 7 days. One of the DBAs went and cleaned out the ARCHIVELOG directory using 'asmcmd' He basically deleted the files using the 'rm' command to delete all archive logs that were older than 5 days. now my backups are filing with the follwoing errors:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========
RMAN-03002: failure of backup command at 10/28/2007 21:04:14
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +ASMDG/prod/1_118839_624905386.dbf
ORA-17503: ksfdopn:2 Failed to open file +ASMDG/prod/1_118839_624905386.dbf
ORA-15173: entry '1_118839_624905386.dbf' does not exist in directory 'prod'
WHat do I do to get my backups to start working again?
Take a full backup then put your DBA in 30 days provation.
At this point you cannot recover from the backup you have.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
You will have to perform the following before you can do a full backup:
then do as PAVB indicated, do a full backup and put the DBA on probation.
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
Click Here to Expand Forum to Full Width