RE: Two Interesting Scenario in 11g RAC
- From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
- To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Dec 2009 12:12:40 +0000
We use DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE and our
DBID's are the same. I've checked both RAC and non-RAC standbys (both 11g).
Not experienced the second issue. Are you still transporting and applying
logs. Check the alert log and broker log. Maybe you could post the spfile
info and output from the following commands:
show configuration verbose;
show database 'primary' verbose;
show database 'standby' verbose;
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sanjay Mishra
Sent: 02 December 2009 18:16
To: oracle-l@xxxxxxxxxxxxx
Subject: Two Interesting Scenario in 11g RAC
We are working on Oracle 11g R1 RAC setup and has seen two new issue and so
want to check if this is correct or we missed something. This is 11.1.0.7. The
issue is linked to RAC1 (2-Node) and RAC2 (2-Node) Datagaurd environment.
Standby was created as per Oracle Best Practices using the following Command
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
What was found is the DBID is different on both Primary and Standby Server. The
issue is not to our setup with the different DBID as we are able to switchover
as well as failover and several test been done successfully and recovered. We
are using Dataguard broker in the setup. There are some software which are not
recognizing the Standby correctly like BMC Sqlbacktrack newer version has
special Setup for Standby Monitoring but it is not able to recognize it as it
use to Compare DBID as well as 2-3 more columns value. IS IT something always
happened as I personally never use the above command and had created Standby
database using rman backup copy and Creating standby controlfile and found the
same DBID with RAC and non-RAC database but all 10g environment
______________________________________________________________________
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:
