OraFAQ Forum: Data Guard » Data Guard server or not

Home » Server Options » Data Guard » Data Guard server or not (Oracle 11.2.0.4.1 , SunOS 5.10)

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

Data Guard server or not [message #619754]

Thu, 24 July 2014 17:53

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

How to ensure a server i am connected to is configured with Data Guard ( primary database or standby database ) ?

Regards,
Srini

Report message to a moderator

Re: Data Guard server or not [message #619763 is a reply to message #619754]

Thu, 24 July 2014 20:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to ensure a server i am connected to is configured with Data Guard ( primary database or standby database ) ?

by issuing simple SELECT statement

Report message to a moderator

Re: Data Guard server or not [message #619772 is a reply to message #619754]

Fri, 25 July 2014 00:29

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

Senior Member
Account Moderator

Database Reference

Report message to a moderator

Re: Data Guard server or not [message #619874 is a reply to message #619763]

Fri, 25 July 2014 11:36

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Blackswan,

<by issuing simple SELECT statement >
Could you share that simple statement to me or give a hint like which data dictionary view is used ?

Regards,
Srini

Report message to a moderator

Re: Data Guard server or not [message #619876 is a reply to message #619874]

Fri, 25 July 2014 11:51

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

Senior Member
Account Moderator

It is in the link I gave you but as you specifically ask BlackSwan this is the only thing I'll tell you.

Report message to a moderator

Re: Data Guard server or not [message #619885 is a reply to message #619876]

Fri, 25 July 2014 13:28

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Report message to a moderator

Re: Data Guard server or not [message #619904 is a reply to message #619885]

Fri, 25 July 2014 16:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Your question is very important to us.
Please continue to hold for the first available volunteer.
While you are waiting perhaps you should consider using GOOGLE to find the answer to your question.

Report message to a moderator

Re: Data Guard server or not [message #619906 is a reply to message #619904]

Fri, 25 July 2014 17:26

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Blackswan,

I tried in google but couldnot get the answer i want.If you know the answer help me.

Regards,
Srini

Report message to a moderator

Re: Data Guard server or not [message #619908 is a reply to message #619906]

Fri, 25 July 2014 17:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Database admin wrote on Fri, 25 July 2014 15:26

Blackswan,

I tried in google but couldnot get the answer i want.If you know the answer help me.

Regards,
Srini

Since you have demonstrated that you are incapable to use GOOGLE, I won't waste more of my time showing you answers for Oracle.

Report message to a moderator

Re: Data Guard server or not [message #619944 is a reply to message #619908]

Sat, 26 July 2014 08:23

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

 database_role.v$database

Is this the correct one to identify data guard or not ?Can you confirm now ?

Regards,
Srini

[Updated on: Sat, 26 July 2014 08:25]

Report message to a moderator

Re: Data Guard server or not [message #619954 is a reply to message #619944]

Sat, 26 July 2014 09:27

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

Senior Member
Account Moderator

What does this give?
What can be its value?

Report message to a moderator

Re: Data Guard server or not [message #619978 is a reply to message #619954]

Sun, 27 July 2014 00:32

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Michel,
It says the database you are logged in is primary role or standby role ?

Regards,
Srini

Report message to a moderator

Re: Data Guard server or not [message #619979 is a reply to message #619978]

Sun, 27 July 2014 00:42

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

Senior Member
Account Moderator

Do you ask or do you state it?

Report message to a moderator

Re: Data Guard server or not [message #620006 is a reply to message #619979]

Sun, 27 July 2014 11:24

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

i state it.

Report message to a moderator

Re: Data Guard server or not [message #620008 is a reply to message #620006]

Sun, 27 July 2014 11:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Database admin wrote on Sun, 27 July 2014 09:24

i state it.

Your mother should be so proud of you for this.

Report message to a moderator

Re: Data Guard server or not [message #620010 is a reply to message #620006]

Sun, 27 July 2014 12:15

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

Senior Member
Account Moderator

Database admin wrote on Sun, 27 July 2014 18:24

i state it.

And you're right, documentation says it is: "Current role of the database" and value can be:
SNAPSHOT STANDBY
LOGICAL STANDBY
PHYSICAL STANDBY
PRIMARY
which answer your question.

Report message to a moderator

Re: Data Guard server or not [message #620022 is a reply to message #620010]

Sun, 27 July 2014 23:21

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thanks Michel for your confirmation.

Blackswan,
Let's not involve our parents or family in this forum.If you want to say something about me be frank to tell here .

This forum is to discuss on topics related to oracle and not external to oracle.I believe it applies to you as well.

[Updated on: Sun, 27 July 2014 23:22]

Report message to a moderator

Re: Data Guard server or not [message #639416 is a reply to message #620022]

Mon, 06 July 2015 23:57

ashokkhdba
Messages: 4
Registered: June 2015
Location: Bangalore

Junior Member

select PROTECTION_MODE, DATABASE_ROLE from gv$database; for RAC

select PROTECTION_MODE, DATABASE_ROLE from v$database; for Standalone

Check this srini!

Report message to a moderator

Re: Data Guard server or not [message #639421 is a reply to message #639416]

Tue, 07 July 2015 00:10

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

Senior Member
Account Moderator

I doubt he is waiting for your answer since one year, more he already knows it, if you can read his answer above.

Report message to a moderator

Previous Topic:	Production server hanging issue
Next Topic:	Standby Database (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 14:58:26 CST 2025