If this error occurs, the master database loses archive, and the slave database cannot synchronize logs.
Media RecoveryWaiting for thread 1 sequence 70
Fetching gapsequence in thread 1, gap sequence 70-72
Completed: ALTERDATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Wed Mar 07 312012
FAL [client]: Failedto request gap sequence
GAP-thread 1 sequence 70-72
DBID 3857759336 branch768793323
FAL [client]: Alldefined FAL servers have been attempted.
-------------------------------------------------------------
Check that theCONTROL_FILE_RECORD_KEEP_TIME initialization
Parameter is definedto a value that is sufficiently large
Enough to maintainadequate log switch information to resolve
Archivelog gaps.
-------------------------------------------------------------
1. view the Lost Archive on the slave Database
Idle> SELECTTHREAD #, LOW_SEQUENCE #, HIGH_SEQUENCE # from v $ ARCHIVE_GAP;
THREAD # LOW_SEQUENCE # HIGH_SEQUENCE #
-------------------------------------
1 70 72
2. Check whether the archive exists in the master database
First, check the location of the file in the system.
Sys @ DEX> select name from v $ ARCHIVED_LOG where thread # = 1 AND DEST_ID = 1 and sequence # BETWEEN 70 AND 72;
NAME
------------------------------
/U01/arch1/10970_768793323.arc
/U01/arch1/41571_768793323.arc
/U01/arch1/g072_768793323.arc
Run the system command to check whether the file is found. If the file is not found, go to the following stage.
File/u01/arch1/10970_768793323.arc
/U01/arch1/10970_768793323.arc: cannot open '/u01/arch1/10970_768793323.arc' (No such file or directory)
3. view the scn Number of the Lost Archive in the standby Database
Idle> select current_scn from v $ database;
CURRENT_SCN
-----------
1102063
4. Create an incremental backup for the master database based on the missing archive scn number (make sure that the target directory of the master database and the slave database has enough space. Use the/tmp folder here)
RMAN> run {
Backup device typedisk incremental from scn 1102063 DATABASE
FORMAT '/tmp/stb_bk/% U_for_stb.bk'
Include current controlfile for standby;
}