Home » Server Options » Data Guard » change protection mode
change protection mode [message #213874] Fri, 12 January 2007 10:36 Go to next message
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
Re: change protection mode [message #213928 is a reply to message #213874] Fri, 12 January 2007 16:12 Go to previous messageGo to next message
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
Re: change protection mode [message #214262 is a reply to message #213874] Mon, 15 January 2007 10:25 Go to previous messageGo to next message
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
Re: change protection mode [message #214275 is a reply to message #214262] Mon, 15 January 2007 11:19 Go to previous messageGo to next message
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?
Re: change protection mode [message #214429 is a reply to message #213874] Tue, 16 January 2007 07:36 Go to previous messageGo to next message
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
Re: change protection mode [message #214432 is a reply to message #214429] Tue, 16 January 2007 07:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is the output of:

SQL> SELECT * FROM V$LOGFILE WHERE TYPE = ’STANDBY’;
Re: change protection mode [message #214434 is a reply to message #213874] Tue, 16 January 2007 07:57 Go to previous message
maoro
Messages: 312
Registered: May 2005
Senior Member
i got a listing of 3 logfiles;
with group# 9-10-11

thanks
Previous Topic: dataguard parameter
Next Topic: Oracle 9i Data Guard Questions
Goto Forum:
  


Current Time: Thu Mar 28 06:51:54 CDT 2024