Home » Server Options » Data Guard » which to startup first
which to startup first [message #205484] Sat, 25 November 2006 02:41 Go to next message
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 #205540 is a reply to message #205484] Sat, 25 November 2006 09:37 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
shutdown standby and then primary

startup primary and then standby

If you have data guard broker setup make sure its good after both databases are up.

Sandeep
Re: which to startup first [message #205820 is a reply to message #205540] Mon, 27 November 2006 15:52 Go to previous messageGo to next message
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 #205844 is a reply to message #205484] Mon, 27 November 2006 21:29 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Method i suggested, works fine for at my site with data guard setup.

Sandeep
Re: which to startup first [message #207743 is a reply to message #205844] Wed, 06 December 2006 18:26 Go to previous messageGo to next message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member


Please visit the following link for seeing what ORACLE documentation says on this:


http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm#1007684


They have mentioned the following:

If both the primary and standby databases are offline, then always (if possible) start the standby database before starting the primary database

Re: which to startup first [message #207965 is a reply to message #205484] Thu, 07 December 2006 09:20 Go to previous message
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
Previous Topic: DGMGRL setting
Next Topic: Can we use DBMS_SCHEDULER Package in Data Guard ??
Goto Forum:
  


Current Time: Thu Mar 28 21:03:57 CDT 2024