Applying an incremental backup to a physical standby

https://jarneil.wordpress.com/2008/06/03/applying-an-incremental-backup-to-a-physical-standby/

So here is my guide to applying an rman incremental backup to a physical standby.

Find out where your standby thinks you have applied up to:

standby> alter database recover managed standby database cancel;

standby> select current_scn from v$database;

 

Make an rman incremental backup on the primary from the above scn:

primary_rman> backup incremental from scn #### database format '/backup/standby_%U';

Once this backup file is copied to the standby, catalog it with the standby controlfile:

standby_rman> catalog start with '/backup/standby';

Now actually apply the changes from the backup to the standby:

standby_rman> recover database noredo;

At this point your datafiles will be up-to-date, but your controlfile is still out of date, create new standby controlfile from the primary:

primary> alter database create standby controlfile as '/tmp/standby.ctl';

 

Copy this to the standby and replace your current standby controlfiles with this new one. Once this is done you should be able to restart managed recovery and it will take off from your backup scn.