Failure of backup
i have a question regarding the ARCHIVE LOGS.
After starting the backup with HP Data Protector we get this Message.
The File ARC19788.001 is not present in the system anymore, i think somebody has deleted the file.
The oldest ARCHIVE Log is "ARC22170.001"
Is ist possible to reset the counter?
If you need more Information please be so kind ans tell me the commands which i should type in.
RMAN-03090: Starting backup at 11-MAR-14
RMAN-03033: current log archived
RMAN-08031: released channel: dev_0
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of backup command at 03/11/2014 20:16:36
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file F:\DBMS_LOG\IASP\ARCHIVE\ARC19788.001
Thanks a lot
You can use the following commands to remove the archive log from the control file.
If you are using 11g you can set the archive log deletion policy to control how long
archive logs are needed on disk. You may also want to change the archive log format.
You will need to restart the database for it to take effect. I use the following:
alter system set log_archive_format='mydb_%t_%s_%r.arc' scope=spfile;
CHANGE ARCHIVELOG ALL CROSSCHECK;
CHANGE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3' UNAVAILABLE;
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
Last edited by gandolf989; 03-12-2014 at 01:14 PM.
this space intentionally left blank
Click Here to Expand Forum to Full Width