Oracle Data Guard Switchover
Posted on 2011-09-12
I have a multiple point question looking for confirmation of the research I've done. I am about to do a switchover from a primary db to a standby db because of updates that need to be applied to the server. It seems that I have redo apply running on the standby. I have also found the commands to switch the primary to standby and standby to primary. My main concern is at this point is that once the reboot occurs and we bring up the current primary it will be the standby and this will have to be changed soon thereafter. How do i know if the current primary will be in sync and have all current data applied before make the second switchover and if it is not how do you go about ensuring that this will happen in timely manner? Also do I need to make sure the services currently running on the standby are running on the current primary, i.e. redo apply so that when it comes up in standby it will work correctly?
Please excuse my ignorance but I have only worked with standalone before and I'm having to learn this on the job and cannot afford to have down time due to the importance of the data being needed.