Hi,
You can check for parameter STANDBY_ARCHIVE_DEST, this is used only in managed recovery standby db.
This parameter will tell you the location of the primary database.
Also TARGET column of v$ARCHIVE_DEST table will give you standby and primary database information.
regards
anandkl




Reply With Quote