This forum is currently locked. You can't register or post questions at this time. (read more)

Archivelog backups-Crosscheck

All posts relating to Oracle database administration.

Moderator: Tim...

Monto
Senior Member
Posts: 195
Joined: Sat Jan 16, 2010 1:55 pm

Archivelog backups-Crosscheck

Postby Monto » Tue Sep 11, 2012 8:28 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Archivelog backups-Crosscheck

Postby Tim... » Wed Sep 12, 2012 8:24 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Monto
Senior Member
Posts: 195
Joined: Sat Jan 16, 2010 1:55 pm

Re: Archivelog backups-Crosscheck

Postby Monto » Thu Sep 13, 2012 3:43 pm

Thanks Tim!!

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Archivelog backups-Crosscheck

Postby Tim... » Thu Sep 13, 2012 6:04 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 8 guests