Monday, September 14, 2015

Resolve Archivelog gaps in Data Guard.

In my case one of archive log file are not transfer from primary database to standby database for that standby database fall into archivelog gap.

Solution : I have found missed archivelog file in my primary database (If file are not find then need to take rman backup using the current scn number of standby and applied into standby database) and I have transferred it to standby database, but standby database are not able to resolve this gap for that I have registered this archivelog file using the alter database register logfile 'location of missed archivedlog file'. 


Error from alert log file of standby :

CORRUPTION DETECTED: In redo blocks starting at block 444418count 2048 for thread 1 sequence 1497
RFS[1687]: Possible network disconnect with primary database
Sun Sep 13 21:25:19 2015
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 1497-1497
 DBID 2276360779 branch 885908186
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.


DRHOST1$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 13 21:40:37 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> alter database register logfile '/fra/archivelog/2015_09_13/o1_mf_1_1497_bzbddsjf_.arc';
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

No comments:

Post a Comment