Easiest method to reinstantiate physical standby databases?
644720Feb 16 2009 — edited Feb 16 2009Helllo Everyone,
I'm managing a development Dataguard configuration consisting of a Primary database and 3 physical standby databases. Currently the DG Broker configuration has been disabled and all 4 databases (and associated instances) have been shutdown whilst some power and cooling work is done to the machine room which host the servers on which the 4 databases reside.This work is likely to take 2-3 weeks, and the 3 standby databases have already been shutdown for 2 weeks - so there is a lot of redo log needing to be applied to the standby sites.
When I am in a position to power up the 4 databases I would like to 'reinstantiate' the 3 physical standby databases from the primary DB before I (re)enable the DG Broker configuration and get redo log apply process started on the standby sites again. My question is therefore, whats the easiest way of doing this ? When the standby databases were initally created the following RMAN command was used :-
RMAN> duplicate target database for standby
Could I use this command again ?
Any advice would be greatly appreciated.
Thanks,
Shaun.