Mir Sayeed Hassan – Oracle Blog

Perform the Incremental backup from the primary database

Take the current control file backup for the standby database from the primary db

• As shown below:

$rman target /
RMAN> backup current controlfile for standby format '/tmp/stby.ctl';

Than give the full permisstion for the stby.ctl file

$cd /tmp

$chmod –R 777 stby.ctl

Take the incremental backup primary database with scn of standby database

To view the current scn as shown below

Sql> select current_scn from v$database;

On primary database:

$rman target /

RMAN> backup device type disk incremental from scn 18897455 database format '/tmp/incr_backup_scn_18897455/bkup_%U';

(Copy this files to the standby database location and perform the operation)

On primary db –

$scp /tmp/stby.ctl root@10.20.0.105:/tmp

$scp /tmp/incr_backup_scn_18897455/* root@10.20.0.105:/tmp/incr_backup_scn_18897455

(The same directory name has to be created on primary and standby db – it will not be confuse)

On Standby Database:

SQL> shu immediate

SQL> startup nomount;

(Restore the control file of the database)

$rman target /

Rman> restore controlfile from ‘/tmp/stby.ctl’; 

or you can manually copy the primary controlfile created into the existing location by using the CP Copy

Example: $ cp /tmp/stby.ctl < Existing location of standby database "show parameter control_files">

Rman> alter database mount;

Rman> catalog start with ‘/tmp/ incr_backup_scn_18897455/’;

Rman> recover database noredo;

Rman > alter database open;

If its not –  Shu immediate  and startup database

==================Hence Tested & Verified in our env==============