-
Failure of backup
Hello,
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?
Code:
RMAN-03090: Starting backup at 11-MAR-14
RMAN-03033: current log archived
RMAN-08031: released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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
If you need more Information please be so kind ans tell me the commands which i should type in.
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;
Code:
CHANGE ARCHIVELOG ALL CROSSCHECK;
CHANGE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3' UNAVAILABLE;
SHOW ALL;
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;