We are using 2 Node Oracle 11g R2 RAC Cluster on windows 2008 as a primary site and the similar cluster congirations on the secondary site. we are relocating our Secondary Standby Database server to a different site. There will be a atleast 10 hours down time on seondary site while we are moving the physical servers. At the moment we have 200GB space available on Production server for FRA and our daily archive log file generation is 70GB maximum. Could you please let me know what is the best way for me to down the secondary standby server and Up it again on the new site without any issues.
1- Shell I Shutdown the standby server straight away and plug in on new site and it can start recovering from the primary site ? (I know this is not a safe way)
2- Shell I turn the transport OFF on the primary site and then turn it ON on later on new site ?
Any feedback would be appreciated !
Assuming your network and disks are fast enough I would consider setting the Primary to "defer" and then let Data Guard catch up when the new site is ready. If your 70GB is steady over the day then you have about 3GB per hour. So I would figure how long it would take to catch up. I might defer for 30 minutes as a sample size before I try this. But Data Guard should catch up fairly fast once you enable again.
Is the backup on the Standby now?
Is an RMAN roll forward another option?
In Primary location:
Alter system set LOG_ARCHIVE_DEST_STATE_2=defer sid='*'; ---will stop sending archives to Secondary location (Standby)
Secondary location (Standby ) is UP:
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
In Primary location:
Alter system set LOG_ARCHIVE_DEST_STATE_2=enable sid='*';
And check in Secondary location : select name, value from v$dataguard_Stats;
For example result:
transport lag +00 00:00:00
apply lag +00 00:00:00
apply finish time +00 00:00:00.000
estimated startup time 21
Thanks very much for this really useful information. Just a question (dont mind if this is a stupid question) what will be the impacts if I Down the Standby server without changing any parameter on the Primary server. What happened if the Standby server is Up again do the standby server start receiving files from the Primary server automatically. Just want to know the Pros and Cons.
It may or may not work. I cannot see any Pro to do this. I would use this:
alter system set log_archive_dest_state_2=defer;
DGMGRL> edit database 'stby_dbname' set property 'LogShipping'='OFF';
The con would be spending a lot of time fixing the Standby because you did not run a command that takes 5 seconds.