which to startup first [message #205484] |
Sat, 25 November 2006 02:41  |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hi
i have an oracle 9i master database and a standby server,there is a requirement to shutdown both server daily at 4:00 pm
shall i shutdown the master then the standby after ?
and the next morning shall i stratup the standby before the master ?
os windows 2003
|
|
|
|
Re: which to startup first [message #205820 is a reply to message #205540] |
Mon, 27 November 2006 15:52   |
ualual
Messages: 22 Registered: May 2005
|
Junior Member |
|
|
sandeep.
wouldn't you want to shutdown the PRIMARY 1st, that way all redo,archive files will be transfer over to STANDBY.
some others steps to look at (maybe)
if you're doing a cold backup and using dgmgrl and fast_start failover.
dgmgrl > disable fast_start failover;
dgmgrl > disable configuration
dgmgrl > stop observer
dgmgrl > exit
do the backup stuff
startup the standby
startup the primary
start dgmgrl station
dgmgrl > enable configuration
dgmgrl > enable fast_start failover;
dgmgrl > start observer
--
watch out if you are applying patches too.
[Updated on: Mon, 27 November 2006 16:53] Report message to a moderator
|
|
|
|
|
Re: which to startup first [message #207965 is a reply to message #205484] |
Thu, 07 December 2006 09:20  |
email.sandeepnaik
Messages: 121 Registered: August 2006
|
Senior Member |
|
|
Thanks Anurag.
As you can see, oracle says "if possible" which does not imply "must".
Like I said, I have not seen any issues so far in method I have described before.
So it will be personal/business decision(unless oracle has better explanation on "if possible" )
Sandeep
|
|
|