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.