Restore standby database using incremental backup

   1)      Find the current scn of Standby database

select  current_scn from v$database;

CURRENT_SCN

-----------

    750098

    2)      Take incremental backup  on primary database  start from the scn  shown in step 1

BACKUP DEVICE TYPE DISK INCREMENTAL FROM SCN 750098 DATABASE

     FORMAT '/tmp/incr_standby/backup_%U';

   3)      Create control file backup  for standby

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/standby_control.ctl';

   4)      Copy the incremental backup and control file backup from primary to secondary database

   5)      Check the status of standby and controlfile location

select open_mode , database_role ,name from v$database;

OPEN_MODE  DATABASE_ROLE    NAME

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

MOUNTED    PHYSICAL STANDBY ORCL

Select name , value from  v$parameter where name=’control_file’;

NAME            VALUE

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

control_files   /u01/app/oracle/oradata/orcl/control01.ctl, /u01/a

pp/oracle/flash_recovery_area/orcl/control02.ctl

    6)      Cancel recovery on standby  stop  standby database

 Alter database recover managed standby database cancel;

Database altered.

SQL>  shu immediate ;

    

     7)      Recover control file

rman target /

Restore  controlfile from ‘/tmp/incr_standby/stby.ctl';

startup mount

    8)      Catalog the backup  on standby database

catalog start with  '/tmp/incr_standby/';

    9)      Restore database

RMAN>  recover database noredo;

     10)   Start recover y on standby database

alter database recover managed standby database disconnect from session ;