Re: Database Renaming
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 7 Nov 2023 16:34:00 -0500
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
Other related posts: