High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

How to fix an incorrect static identifier for dataguard

Good morning everyone,

I've been looking at a problem with a dataguard configuration that I have set up. It appears to be working but the static identifier for the standby database will not validate and has the wrong hostname.

I have a primary database on server OPRIME and a physical standby on OSTBY. I've created the databases and orclprmy and orclstby unique identifiers and orcl.tree as the global domain name. Checked and those names are correct in V$DATABASE.

I used RMAN to create the standby physical database, checked it over and startup mount ran successfully. I then did alter database recover managed standby database disconnect from session and everything appeared fine.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center