Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Resolving Archive Gaps in Standby Database


I found that archive logs is not appling to the drsite i.e physical standby database, but luckily I had all the archive logs.

SQL> Select Low_Sequence#,High_Sequence# From V$Archive_Gap;

LOW_SEQUENCE# HIGH_SEQUENCE#
————- ————–
         1641           1646

If you are not having the archive logs at your standby database, the just copy or ftp the logs from primary to standby database.

SQL> alter database register logfile ‘/arch/icai/icai_1_1641.dbf’;

Database altered.

SQL> alter database register logfile ‘/arch/icai/icai_1_1642.dbf’;

Database altered.

SQL> alter database register logfile ‘/arch/icai/icai_1_1643.dbf’;

Database altered.

SQL> alter database register logfile ‘/arch/icai/icai_1_1644.dbf’;

Database altered.

SQL> alter database register logfile ‘/arch/icai/icai_1_1645.dbf’;

Database altered.

SQL> alter database register logfile ‘/arch/icai/icai_1_1646.dbf’;

Database altered.

After the redo logs have been registered on the physical standby database, the DBA can restart the managed recovery operations. For example, to put the physical standby database into automatic recovery managed mode:

SQL> alter database recover managed standby database disconnect from session;
 

SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_S
TANDBY;
PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
——— ———— ———- ———- ———- ———-
ARCH      CONNECTED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
MRP0      APPLYING_LOG          1       1641     307197     307198
RFS       RECEIVING             0          0          0          0

Advertisements

May 3, 2011 - Posted by | Data Guard

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: