Archive gap resolution

Archive Gap Resolution using RMAN:
---------------------------------------------------------


1. On the standby database, stop the managed recovery process (MRP):


SQL> SELECT NAME,OPEN_MODE FROM V$DATABASE;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2. On the standby database, find the SCN which will be used for the incremental
backup at the primary database:

SQL> COL CURRENT_SCN FOR 9999999999999999
SQL> SELECT CURRENT_SCN FROM V$DATABASE;


SQL> COL CHECKPOINT_CHANGE# FOR 9999999999999999
SQL> SELECT DISTINCT CHECKPOINT_CHANGE# FROM V$DATAFILE_HEADER;

NOTE: CURRENT_SCN AND CHECKPOINT_CAHANGE# SHOULD BE SAME IF NOT KINDLY PROVIDE THE CHECKPOINT_CAHANGE# IN STEP NO:3




ON PRIMARY DATABASE:
====================
STEP 3
======
In RMAN, connect to the primary database and create an incremental backup
from the SCN derived in the previous step:

CONNECT TO RMAN ON PRIMARY DATABASE:
===================================

RMAN> run
{
allocate channel c1 device type disk maxpiecesize = 5G;
allocate channel c2 device type disk maxpiecesize = 5G;
allocate channel c3 device type disk maxpiecesize = 5G;
BACKUP INCREMENTAL FROM SCN <CHECKPOINT_CAHANGE#> DATABASE FORMAT 'LOCATION\FILE_NAME_%t_%s_%p.bkp' tag 'FORSTANDBY';
}


TO CHECK THE BACKEDUP FILES:
============================
RMAN>LIST BACKUP;


COPY THE BACKUP SETS CREATED ON PRIMARY TO STANDY USING OS COMMAND (NOTE:LOCATION MUST BE SAME FOR BOTH PRIMARY AND STANDBY)

FOR EX:IN PRIMARY IF THE LOCATION IS M:\RMANBKP\ THE SAME SHOULD BE CREATED ON STANDBY THEN COPY THE BACKEDUP FILES FROM PRIMARY TO STANDBY(M:\RMANBKP)

ON STANDBY DATABASE:
=====================

CONNECT TO RMAN:


RMAN>CATALOG START WITH 'LOCATION OF THE BACKEDUP FILES';

(FOR EX:CATALOG START WITH 'M:\RMANBKP')

RMAN>RECOVER DATABASE NOREDO;

(AFTER SUCCESSFUL COMPLETION PROCEED TO NEXT STEP IF ANY ERRORS KINDLY CHECK FOR THE SAME)

ON PRIMARY DATABASE:
====================

RMAN>run
{
allocate channel c1 device type disk;
BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT 'LOCATION\ForStandbyCTRL.bck'tag 'FORSTANDBY';
}

COPY THE CONTROLFILE BACKUP TO STANDBY USING OS COMMAND.


ON STANDBY DATABASE:
====================


RMAN>SHUTDOWN IMMEDIATE;
RMAN>STARTUP NOMOUNT;
RMAN>RESTORE STANDBY CONTROLFILE FROM 'LOCATION\ForStandbyCTRL.bck';
RMAN>SHUTDOWN IMMEDIATE;
RMAN>STARTUP MOUNT;


ON STANDBY DATABASE:
====================
PUT THE STANDBY DATABASE IN RECOVERY MODE:
===========================================
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;