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 ;

Post Views: 498

Related Posts