Restore Archivelog from particular sequence to another location using tape backup

Error in DR alert log:-

FAL[client]: Failed to request gap sequence
GAP – thread 2 sequence 9432-9473
DBID 2085418592 branch 924361120
FAL[client]: All defined FAL servers have been attempted.
————————————————————
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that’s sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
————————————————————

Now in Primary,do the following steps to restore missing archive log

export ORACLE_SID=INSTANCE_NAME

rman target / catalog rcat/***@RCAT

run {
 allocate channel 'dev_00' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)';
 allocate channel 'dev_01' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)';
 allocate channel 'dev_02' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)';
 set archivelog destination to '/NFSPREPROD/NEW';
 RESTORE ARCHIVELOG FROM sequence 20453 thread 1;

RESTORE ARCHIVELOG FROM sequence 9432 thread 2;
 }

About the Author

debasis maity

12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA

0 thoughts on “Restore Archivelog from particular sequence to another location using tape backup

    • Author gravatar

      Hello there, just was alert to your blog through Google, and located that it is really informative. I am gonna be careful for brussels. I抣l be grateful in case you proceed this in future. Numerous other folks can be benefited out of your writing. Cheers!

      Your comment is awaiting moderation.

Leave a Reply

Your email address will not be published. Required fields are marked *