Thank you all!
This was very helpful
On Wed, Nov 8, 2023 at 6:38 AM Rajeev Prabhakar <rprabha01@xxxxxxxxx> 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@xxxxxxxxx>>
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