Home » Server Options » Data Guard » Data Guard server or not (Oracle 11.2.0.4.1 , SunOS 5.10)
Data Guard server or not [message #619754] Thu, 24 July 2014 17:53 Go to next message
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
Re: Data Guard server or not [message #619763 is a reply to message #619754] Thu, 24 July 2014 20:17 Go to previous messageGo to next message
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
Re: Data Guard server or not [message #619772 is a reply to message #619754] Fri, 25 July 2014 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Reference

Re: Data Guard server or not [message #619874 is a reply to message #619763] Fri, 25 July 2014 11:36 Go to previous messageGo to next message
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
Re: Data Guard server or not [message #619876 is a reply to message #619874] Fri, 25 July 2014 11:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Data Guard server or not [message #619885 is a reply to message #619876] Fri, 25 July 2014 13:28 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Crying or Very Sad
Re: Data Guard server or not [message #619904 is a reply to message #619885] Fri, 25 July 2014 16:55 Go to previous messageGo to next message
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.
Re: Data Guard server or not [message #619906 is a reply to message #619904] Fri, 25 July 2014 17:26 Go to previous messageGo to next message
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
Re: Data Guard server or not [message #619908 is a reply to message #619906] Fri, 25 July 2014 17:35 Go to previous messageGo to next message
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.
Re: Data Guard server or not [message #619944 is a reply to message #619908] Sat, 26 July 2014 08:23 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What does this give?
What can be its value?

Re: Data Guard server or not [message #619978 is a reply to message #619954] Sun, 27 July 2014 00:32 Go to previous messageGo to next message
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
Re: Data Guard server or not [message #619979 is a reply to message #619978] Sun, 27 July 2014 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you ask or do you state it?

Re: Data Guard server or not [message #620006 is a reply to message #619979] Sun, 27 July 2014 11:24 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

i state it.
Re: Data Guard server or not [message #620008 is a reply to message #620006] Sun, 27 July 2014 11:46 Go to previous messageGo to next message
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.
Re: Data Guard server or not [message #620010 is a reply to message #620006] Sun, 27 July 2014 12:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Data Guard server or not [message #620022 is a reply to message #620010] Sun, 27 July 2014 23:21 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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!
Re: Data Guard server or not [message #639421 is a reply to message #639416] Tue, 07 July 2015 00:10 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.



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


Current Time: Thu Mar 28 14:52:14 CDT 2024