OraFAQ Forum: Data Guard » Switch protection mode

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

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

Switch protection mode [message #427448]

Thu, 22 October 2009 12:23

dasuwal@gmail.com
Messages: 20
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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

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: 29
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

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

Wed, 04 November 2009 16:30

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello stonevishcool,

Is there any wrong post in my previous post??

- Babu

Report message to a moderator

Re: Switch protection mode [message #429637 is a reply to message #429636]

Wed, 04 November 2009 19:06

stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai

Junior Member

Hello Babu,

There is nothing wrong in your post but i just added additional steps. Smile

Regards,
Vish

Report message to a moderator

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

Fri, 01 January 2010 01:17

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Hi,

I have a doubt in dataguard.

what should be the status (nomount, mounted or open) of the standby database when we give the following cmd

ALTER DATABASE SET STANDBY TO MAXIMIZE AVAILABILITY;

And I tried with standby shutdown and keeping the standby in managed recovery mode. I have observed that archives are trasferring and getting applied but the protection level on the primary is MAXIMUM AVAILABILITY and on the standby MAXIMUM PROTECTION. Please clarify!!!

Thanks,
Suresh

Report message to a moderator

Re: Switch protection mode [message #437202 is a reply to message #437201]

Fri, 01 January 2010 01:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL Reference
ALTER DATABASE page
Section maximize_standby_db_clause

Quote:

Use this clause to specify the level of protection for the data in your database environment. You specify this clause from the primary database, which must be mounted but not open.

The state of standby database does not matter.
I don't think the value in standby v$database is meaningful.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01157 error on STANDBY after adding a datafile on primary
Next Topic:	Testing Data Guard Implementation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 02:50:21 CST 2025