Hi Gurus,
11.2.0.1 RAC on AIX 5L
I got the error whiile trying to do incremenat 1 level backup today at 08-MAR-12.The archivelog that it was looking for was generated on 05-MAR-12:20:19:49 .The level 1 backup went fine on 06-MAR-12 and 07-MAR-12. Why is it trying to look for this archivelog when it should be backing up only the changed blocks(BCT disabled currently) after 07-MAR-12 - the archivelogs generated during and after INCR 1 backup,is my understanding correct?My backup script doesn't contain the archivelogs backup.
I know i can just do a crosscheck against the archivelogs and the backup should go fine.
Backup script:
backup incremental level 1
format 'df_incr1_%d_%s_%p'
(database include current controlfile); sql "alter system archive log current";
RMAN-03002: failure of backup command at 03/07/2012 20:20:53
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /oramig/mvmxu21/archivelog/1_483_729336774.arc
ORA-27037: unable to obtain file status
Archivelog :
select to_char(first_time,'DD-MON-YY:HH24:MI:SS') "First time",thread#,sequence#,archived,status,deleted,name from gv$archived_log where deleted='YES';
05-MAR-12:20:19:49 1 483 YES D YES
List backup summary:
57 B A A SBT_TAPE 06-MAR-12 1 1 NO TAG20120306T201952
58 B F A SBT_TAPE 06-MAR-12 1 1 NO TAG20120306T202116
59 B 1 A SBT_TAPE 07-MAR-12 1 1 NO TAG20120307T201515
60 B 1 A SBT_TAPE 07-MAR-12 1 1 NO TAG20120307T201515
61 B 1 A SBT_TAPE 07-MAR-12 1 1 NO TAG20120307T201515
62 B F A SBT_TAPE 07-MAR-12 1 1 NO TAG20120307T202011
Can anyone please help me understand this.
Thanks
Edited by: Monto on Mar 8, 2012 10:30 AM
Edited by: Monto on Mar 8, 2012 5:23 PM