Data Guard Gap Recovery

Through select * from V$archive_gap, or alarm log check to see if there are any cracks in the archive log

For example:

Media Recovery waiting for thread 1 sequence 1638

Fetching gap sequence in thread 1, Gap sequence 1638-1737

Completed:alter database RECOVER MANAGED STANDBY database USING current LOGFILE disconnect from session

Wed Jul 13 17:36:44 2016

Fal[client]: Failed to request gap sequence

Gap-thread 1 Sequence 1638-1737

DBID 1415359633 Branch 887578899

Fal[client]: All defined FAL servers has been attempted.

------------------------------------------------------------

Check that the Control_file_record_keep_time initialization

parameter is defined to a value of that ' s sufficiently large

Enough to maintain adequate log switch information to resolve

Archivelog gaps.

------------------------------------------------------------

Wait 1638 of the archive log when recovering;

If the archive log exists, you can pass:

ALTER DATABASE register logfile '/db/archivelog/1_1868_887578899.dbf ';

method to register and will automatically recover after registration

Several commands:

The current main library is in the normal OPEN state, and the standby is in log shipping state.

Stop log shipping in the standby library

sql> Recover managed standby database cancel;

ALTER database RECOVER managed standby database Cancel

Standby Library read-only Mode Open

Sql> ALTER DATABASE open read only;

Standby library back to log shipping mode

sql> Recover managed Standby database disconnect from session;

ALTER database RECOVER managed standby database disconnect from session;

Manual Repository Application Archive log

sql> ALTER database RECOVER MANAGED STANDBY database USING current LOGFILE DISCONNECT from SESSION;

The repository ALTER DATABASE open read only; there are two ways of

Recover managed standby database disconnect from session;

This method can not be used to prepare the current log file, and then the main library log switching will apply the log;

Another type of:

ALTER database RECOVER MANAGED STANDBY database USING current LOGFILE DISCONNECT from SESSION;

Real-time application of log files, both sides of the data to ensure synchronization;

Data Guard Gap Recovery