The database name should be the same on both the primary and the standby,
the db_Unique_name must be different. You dont use the db_unique_name for a
lot, so you may not need to change it. optionally, you can convert from a
physical standby to a logical standby, rename the logical standby, wait for
it to catch up, then switch over if the naming is a critical item.
On Tue, Nov 7, 2023 at 2:31 PM Mark Davidson <wdavidsmc@xxxxxxxxx> wrote:
Hello,
I need to migrate production (primary) databases from one machine to
another machine with minimal downtime running v12.0.1.02 of Oracle on both
machines.
I'm wondering if this is possible:
1. Create a physical standby database from the primary database
2. Break the DR and switch from a physical standby to a primary
3. Rename it back to the primary database name using NID utility.
Thank you,
Mark