Archivelog backups-Crosscheck

[Monto]

Hi Tim,

Does RMAN backs up the archivelogs first instead of backup of database/datafiles even when i have backup incremental level 1 and backup archivelog all as two different commands in run block?

I'm getting the error as shown below even though i have crosscheck statement before the archivelog backups are being done.Should i have crosscheck archivelog all as first command in my backup script?

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file /ora01/mamxv1/2_805_756290445.arc.

My backup script.

Code: Select all

run
{
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
      send 'NB_ORA_POLICY=xxxx.mamxv1';
      backup incremental level 1
      format 'df_incr1_%d_%s_%p'
     (database include current controlfile);
sql "alter system archive log current";
change archivelog all crosscheck ;
      backup
      format 'al_%d_%s_%p'
      (archivelog all);
release channel t1;
release channel t2;
}




Regards

[Tim...]

Hi.

No. That backup will not touch the archived redo logs for a database backup.

I suggest you remove the crosscheck and arhcived redo log backups from the script and convince yourself of this before adding them back to identify the offending action.

Cheers

Tim...

[Monto]

Thanks Tim!!

[Tim...]