Re: Database Renaming

From: Rajeev Prabhakar <rprabha01_at_gmail.com>
Date: Wed, 8 Nov 2023 06:38:25 -0500
Message-ID: <C4C60365-5A44-446C-B564-B6AD550C7214_at_edison.tech>

       

  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 (mailto: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-1217 https://dbwhisperer.wordpress.com
>
>
           

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

Received on Wed Nov 08 2023 - 12:38:25 CET