RE: can I find from standby db which db is the primary
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <Amihay.Gonen@xxxxxxxxxxx>, "John Hallas" <John.Hallas@xxxxxxxxxxxxxxxxxx>, "jason arneil" <jason.arneil@xxxxxxxxx>
- Date: Mon, 17 Nov 2008 15:09:01 -0500
show parameter fal_server
Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Amihay Gonen
Sent: Monday, November 17, 2008 10:18 AM
To: John Hallas; jason arneil
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: can I find from standby db which db is the primary
I mean , if I connected to standby as sys. Can I query the standby db
only to "know" who is it primary .
From: John Hallas [mailto:John.Hallas@xxxxxxxxxxxxxxxxxx]
Sent: Monday, November 17, 2008 5:01 PM
To: Amihay Gonen; oracle-l@xxxxxxxxxxxxx
Subject: RE: can I find from standby db which db is the primary
select open_mode, database_role, switchover_status, dataguard_broker,
guard_status from v$database;
Primary
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DATAGUAR GUARD_S
---------- ---------------- -------------------- -------- -------
READ WRITE PRIMARY SESSIONS ACTIVE DISABLED NONE
Standby
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DATAGUAR GUARD_S
---------- ---------------- -------------------- -------- -------
MOUNTED PHYSICAL STANDBY SESSIONS ACTIVE DISABLED NONE
Blog www.jhdba.wordpress.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Amihay Gonen
Sent: 17 November 2008 14:49
To: oracle-l@xxxxxxxxxxxxx
Subject: Q: can I find from standby db which db is the primary
Hi ,
Is anyone know if there any query which can give me who is the primary
db ( or tnsnames) . our version is 10.2 .
Thanks
Amihay Gonen,
DBA
______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number
358949. The registered office of the company is situated at Gain Lane,
Bradford, West Yorkshire BD3 7DL. This email and any attachments are
intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by
replying to the email that you have received in error and then destroy
the email.
If you are not the intended recipient, you must not use, disclose, copy
or rely on the email or its attachments in any way.
Wm Morrison Supermarkets PLC accepts no liability or responsibility for
anything said in the email or its attachments and gives no warranty as
to accuracy. It is the policy of Wm Morrison Supermarkets PLC not to
enter into any contractual or other obligations by email.
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility,
and it is the responsibility of recipients to carry out their own virus
checks.
______________________________________________________________________
Other related posts:
