OraFAQ Forum: Data Guard » Query regarding upgrading protection mode in a data guard

Home » Server Options » Data Guard » Query regarding upgrading protection mode in a data guard

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

Query regarding upgrading protection mode in a data guard [message #316364]

Thu, 24 April 2008 16:17

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

I am using Oracle 10g in Linux platform

Consider that I have a logical standby and a physical standby and now I want to upgrade the protection mode of physical standby but want the logical standby to retain the protection mode .

According to the Oracle documentation they have specified that the following statement has to be issued from primary to upgrade protection mode of a standby

Code: [Select all] [Show/ hide]

SQL > Alter database set standby database to maximum availability;

So to which standby this statement will refer to, whether logical standby or physical standby?

Report message to a moderator

Re: Query regarding upgrading protection mode in a data guard [message #317903 is a reply to message #316364]

Sun, 04 May 2008 15:44

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

My thinking would be,

protection modes(max avail, max performance, max protection) are applied against physical standby.

Logical standby is open anyway and available for use anytime.

During one of my testing, I had logical created and then created physical...later changed protection mode to max availability on primary... it retained same mode on logical but changed mode to max avail on physical.

Sandeep

Report message to a moderator

Previous Topic:	ORA-01665: control file is not a standby control file
Next Topic:	Doubt regarding switchover from logical standby to primary

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:52:51 CDT 2025