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; }
0 comments on “Restore Archivelog from particular sequence to another location using tape backup”
п»їlegitimate online pharmacies india india pharmacy mail order Online medicine order