Re: Database Renaming

Thank you all!
This was very helpful

On Wed, Nov 8, 2023 at 6:38 AM Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

> Mark,
>
> For the 11.2 Data Guard physical standby
> switchover steps, please refer to Oracle
> Support Doc 1304939.1.
>
> It has some additional steps that might
> be worth considering..
>
> Rajeev
>
> On Nov 7, 2023 at 4:35 PM, <Mladen Gogala <gogala.mladen_at_gmail.com>>
> wrote:
>
> On 11/7/23 15:29, Mark Davidson 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
>
> Mark, you don't rename anything when switching to and from a standby. You
> switch between databases. The whole procedure is described here:
> https://oracle-base.com/articles/11g/data-guard-setup-11gr2
>
> The version is 11G but the procedure is more or less the same in newer
> versions. As for renaming databases, I did have to do it several times but
> I've always re-created the control file. However, the database rename was
> necessary to conform to the company's naming convention. The database was
> old, created and upgraded all the way from 8i to 12c. However, renaming the
> database doesn't have anything to do with standby databases. Standby
> databases use db_unique_name, not db_name.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

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