OraFAQ Forum: Data Guard » change protection mode

Home » Server Options » Data Guard » change protection mode

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change protection mode [message #213874]

Fri, 12 January 2007 10:36

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i have setup data guard using oracle 10g on windowx xp,
when i change the protection mode to maximum availability it works fine but when i change to maximum protection the database shuts down ..
i tried again also it shuts down i reverted to maximum availability it works ...plz help
another question, can the primary database and the standby database have the same names ?
many thanks

Report message to a moderator

Re: change protection mode [message #213928 is a reply to message #213874]

Fri, 12 January 2007 16:12

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

primary and standby can have same name.

I am not sure why database is shutting down. Are you seeing any errors in alert.log which can give us some clue? Are you following all the documentation and made sure that you have everything you need for max protection?

Sandeep

Report message to a moderator

Re: change protection mode [message #214262 is a reply to message #213874]

Mon, 15 January 2007 10:25

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i did everything by the documentation , created standby redo log files, same size as the primary +1, change the log_archive_dest_n parameter to use lgwr ....
i get an error when i change protection mode to maximum protection and try to open the database in my alert file:
ora-16072 saying that one standby database is required or other errors about standby log files eben that both exists
plz advise

Report message to a moderator

Re: change protection mode [message #214275 is a reply to message #214262]

Mon, 15 January 2007 11:19

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you certain the the standby logs are EXACTLY the same size? Have you checked the alert log on the standby database?

Report message to a moderator

Re: change protection mode [message #214429 is a reply to message #213874]

Tue, 16 January 2007 07:36

maoro
Messages: 312
Registered: May 2005

Senior Member

HELLO
I CHECKED THE STANDBY ALERT FILE AND I FOUND THIS ERROR
"RFS[8] NO STANDBY REDO LOG FILES SELECTED"
EVEN THAT STANDBY LOG FILES EXIST ON STANDBY SITE

HELP

THANK U

Report message to a moderator