Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding Standby DB name from Primary

KirkPatrickFeb 6 2013 — edited Feb 6 2013

11.2.0.3/Solaris 10

Setup Type : Physical Standby

I only have toad/SQL*Plus access to the primary DB and I want to know the DB_UNIQUE_NAME of the standby DB.
LOG_ARCHIVE_DEST_2 will only have the TNS entry of the standby DB and I don't have server level access to the primary DB server to check the tnsnames.ora file !

Is there any other way (like an init.ora parameter) to find the DB_UNIQUE_NAME of the standby DB when connected to the DB from SQL*Plus/Toad ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2013

Added on Feb 6 2013

#data-guard, #performance-availability

3 comments

10,729 views