Re: Database Renaming

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_at_gmail.com> 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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l