OraFAQ Forum: Data Guard » Switch protection mode

Members

Help

Home

Home » Server Options » Data Guard » Switch protection mode (Oracle 11.1.0.6, OEL 5)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Switch protection mode [message #427448]

Thu, 22 October 2009 12:23

dasuwal@gmail.com
Messages: 17
Registered: June 2009

Junior Member

Hi Forum

I have a 11.0.1.6 dataguard in maximum performance mode.
I want to change the protection mode to maximum availability. I have changed the log_archive_dest_2 parameter as follow & created standby redo logs on both primary and standby. stdby is standby database unique name.

log_archive_dest_2=
'SERVICE=stdby lgwr SYNC AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=stdby'

After bouncing the database, when I check my protection_mode from v$database, it still shows maximum performance.
Is there any step I have missed. Please guide.

Thanks in advance.

Report message to a moderator

Re: Switch protection mode [message #428179 is a reply to message #427448]

Tue, 27 October 2009 07:38

gentlebabu
Messages: 1398
Registered: December 2005
Location: India, Hyderabad

Senior Member

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE}

-Babu

[Updated on: Tue, 27 October 2009 07:38]

Report message to a moderator

Re: Switch protection mode [message #429607 is a reply to message #427448]

Wed, 04 November 2009 13:44

stonevishcool
Messages: 16
Registered: June 2008
Location: Mumbai

Junior Member

Hi,

You need to fire below command on primary server. Make sure primary database must be on MOUNT stage.

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY

Then OPEN the db and execute the below query to check db mode.

SELECT PROTECTION_MODE FROM V$DATABASE

Regards,
Vish

Report message to a moderator