Home » Server Options » Data Guard » Switch protection mode (Oracle 11.1.0.6, OEL 5)
Switch protection mode [message #427448] Thu, 22 October 2009 12:23 Go to next message
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.
Re: Switch protection mode [message #428179 is a reply to message #427448] Tue, 27 October 2009 07:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Switch protection mode [message #429636 is a reply to message #429607] Wed, 04 November 2009 16:30 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello stonevishcool,

Is there any wrong post in my previous post??

- Babu
Re: Switch protection mode [message #429637 is a reply to message #429636] Wed, 04 November 2009 19:06 Go to previous messageGo to next message
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
Re: Switch protection mode [message #437201 is a reply to message #429607] Fri, 01 January 2010 01:17 Go to previous messageGo to next message
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
Re: Switch protection mode [message #437202 is a reply to message #437201] Fri, 01 January 2010 01:53 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: ORA-01157 error on STANDBY after adding a datafile on primary
Next Topic: Testing Data Guard Implementation
Goto Forum:
  


Current Time: Thu Mar 28 13:10:00 CDT 2024