An incremental backup is used to restore an archive deleted by DG.

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;

}

1 2 Next Page