Cloud Control - Data Guard

From: Scott Canaan <"Scott>
Date: Mon, 9 Dec 2024 13:47:17 +0000
Message-ID: <CH3PR16MB5897FF70DBC5F6771129D05BC53C2_at_CH3PR16MB5897.namprd16.prod.outlook.com>

We are in the process of migrating our databases from Red Hat 7 Linux to Red Hat 8 Linux. The standalone databases are easy to migrate. The few data guarded databases are posing more of an issue.

It seems that Cloud Control can't handle having more than one database with the same name, even if they are on different servers. When we do the standalone migrations, we create a new database on the new server and import the data over the network. Once that's done, we decommission the old database and add the new one to Cloud Control, basically replacing the old one.

For data guard, we use Cloud Control to create the data guard using existing databases. What I was trying to do was to create the new databases and data guard them, then do the data migration. To do this, I had to create the new databases with different names (in Cloud Control - in Linux, they have the same names). For example, the Linux database names are CLAWBETA and CLAWBETB. In Cloud Control, the new ones are CLAWBETA_RH8 and CLAWBETB_RH8. When I tried to create the data guard, it failed. Cloud Control seems to get confused between the two CLAWBETBs.

Based on this, it seems that my only course of action is to:

*

create the RHEL8 CLAWBETA/CLAWBETB databases
*

migrate the data from the RHEL7 CLAWBETA to the RHEL8 CLAWBETA
*

remove the RHEL7 CLAWBETA/CLAWBETB from Cloud Control
*

Add the RHEL8 CLAWBETA to Cloud Control
*

Build the new data guard with the RHEL8 CLAWBETA/CLAWBETB databases in Cloud Control

Does this make sense? Is there a better way to accomplish this, knowing that it will eventually have to be in production?

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration

Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520

srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

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

Received on Mon Dec 09 2024 - 14:47:17 CET