Différences

Ci-dessous, les différences entre deux révisions de la page.

--- oracle:database:duplicate_pdb_to_another_cdb [11/03/2024 14:38] – mdl
+++ oracle:database:duplicate_pdb_to_another_cdb [02/12/2025 10:47] (Version actuelle) – mdl
@@ Ligne 39: / Ligne 39: @@
 odacli create-database --dbname CHRMSP2 --databaseUniqueName CHRMSP2 --pdbname P_ODA1901 --cdb --dbtype RAC --dbclass OLTP --dbhomeid cf868ba0-6fff-4b9d-84e2-53cc1a95ca1b --bshape odb1 --dbstorage ASM --dbdomainname db.test.com --associated-networks Public-network --characterset AL32UTF8 --nationalscharacterset AL16UTF16 --dblanguage american --dbterritory america
 </code>
-//Note: When creating a CDB, the create database command requires a PDB Name.  This is a temporary database that the DBA has to drop it, once container is created successfully.	//
+//Note: When creating a CDB, the create database command requires a PDB Name.  This is a temporary database that the DBA has to drop it, once container is created successfully.//
 b) Check create container job status
@@ Ligne 47: / Ligne 47: @@
 srvctl status database -d CHRMSP2 -v
 srvctl config database -d CHRMSP2
-<code PLSQL>
+</code>
   * Drop P_ODA1901 PDB
+<code PLSQL>
 	     SQL> show pdbs
@@ Ligne 70: / Ligne 70: @@
 PDB$SEED                       READ ONLY  NO
+</code>
+) Compare initialization parameters(init.ora) of CHRMSP1 and CHRMSP2 containers and do the necessary parameter changes.
-) Compare initialization parameters(init.ora) of CHRMSP1 and CHRMSP2 containers and do the
+) Add newly created container CHRMSP2 into OEM and schedule RMAN backup jobs
-           necessary parameter changes.
-) Add newly created container CHRMSP2 into OEM and schedule RMAN backup jobs
-) Create a TNS entry for source PDB (to be used during migration)
+) Create a TNS entry for source PDB (to be used during migration)
+<code PLSQL>
 	   P_HRDP_MIG =
 	     (DESCRIPTION =
 	         (ADDRESS = (PROTOCOL = TCP)(HOST = indodap1-scan)(PORT = 1521))
                  (CONNECT_DATA =
     	         (SERVER = DEDICATED)
 	         (SERVICE_NAME = P_HRDP.db.test.com)
 		 )
 	     )
+</code>
 ** Migration Phase **
+Referred MOS Doc ID: 2297470.1 - How to clone PDB (Remote Clone) across CDB using Database Link
+) Take Full Export backup of P_HRDP PDB
+=> Directory Location:  /acfs01/backup/CHRMSP1/P_HRDP
+<code BASH>
+nohup expdp <username>/<password>@P_HRDP_MIG DIRECTORY=DATADUMP DUMPFILE=EXPDP_P_HRDP_FULL_%U.dmp LOGFILE=EXPDP_P_HRDP_FULL.log FULL=Y PARALLEL=4 EXCLUDE=STATISTICS,MARKER &
+</code>
-	Referred MOS Doc ID: 2297470.1 - How to clone PDB (Remote Clone) across CDB using Database Link
+) Stop P_HRDP_SVC service from source container CHRMSP1
+<code BASH>
+srvctl stop service -d CHRMSP1 -s P_HRDP_SVC
+srvctl disable service -d CHRMSP1 -s P_HRDP_SVC
+</code>
-) Take Full Export backup of P_HRDP PDB
+) clone P_HRDP database from source container(CHRMSP1) to target container(CHRMSP2)
+** Source Container (CHRMSP1) **
-           Directory Location:  /acfs01/backup/CHRMSP1/P_HRDP
+<code PLSQL>
+ALTER SESSION SET CONTAINER=P_HRDP;
-	   nohup expdp <username>/<password>@P_HRDP_MIG DIRECTORY=DATADUMP DUMPFILE=EXPDP_P_HRDP_FULL_%U.dmp LOGFILE=EXPDP_P_HRDP_FULL.log FULL=Y PARALLEL=4 EXCLUDE=STATISTICS,MARKER &
+CREATE USER remote_clone_user IDENTIFIED BY remote_clone_user;
+GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO remote_clone_user;
-) Stop P_HRDP_SVC service from source container CHRMSP1
+Grant select any dictionary to remote_clone_user;
+ALTER PLUGGABLE DATABASE P_HRDP CLOSE IMMEDIATE instances=all;
-	   srvctl stop service -d CHRMSP1 -s P_HRDP_SVC
+ALTER PLUGGABLE DATABASE P_HRDP OPEN READ ONLY instances=all; <<< Restart database in read only mode
+SHOW PDBS
-    	   srvctl disable service -d CHRMSP1 -s P_HRDP_SVC
+</code>
+**Target Container (CHRMSP2)**
-) clone P_HRDP database from source container(CHRMSP1) to target container(CHRMSP2)
-	   ** Source Container (CHRMSP1) **
-	      ALTER SESSION SET CONTAINER=P_HRDP;
-	      CREATE USER remote_clone_user IDENTIFIED BY remote_clone_user;
-              GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO remote_clone_user;
-	      Grant select any dictionary to remote_clone_user;
-	      ALTER PLUGGABLE DATABASE P_HRDP CLOSE IMMEDIATE instances=all;
-	      ALTER PLUGGABLE DATABASE P_HRDP OPEN READ ONLY instances=all; <<< Restart database in read only mode
-              SHOW PDBS
-	** Target Container (CHRMSP2) **
-	   ** Create database link pointing to source PDB
+  * Create database link pointing to source PDB
+<code PLSQL>
 	      CREATE DATABASE LINK clone_link CONNECT TO remote_clone_user IDENTIFIED BY remote_clone_user USING 'P_HRDP_MIG'; <<< Use TNS Entry which was created in above step
+</code>
-           ** Test Database link (check users list and confirm it is connecting to correct database)
+  * Test Database link (check users list and confirm it is connecting to correct database)
+<code PLSQL>
 	      DESC user_tables@clone_link
 	      Select username from dba_users@clone_link where(oracle_maintained='N');
+</code>
-    	   ** Create a shell script to clone PDB
+  * Create a shell script to clone PDB
+<code BASH>
 	      cd /home/oracle
 	      vi clone_P_HRDP_pdb.sh
 	      #!/bin/sh
 	      sqlplus /nolog << ! >> /dev/null
 	      connect / as sysdba
 	      spool clone_P_HRDP_pdb_02Jan2024.log
 	      select username from dba_users@clone_link where(oracle_maintained='N' and username not like 'C##%');
 	      CREATE PLUGGABLE DATABASE P_HRDP FROM P_HRDP@clone_link;
 	      alter pluggable database P_HRDP open instances=all services=all;
 	      spool off;
+</code>
-	      !
+ * Before executing a script make sure environment is set for target container CHRMSP2
+<code BASH>
-	   ** Before executing a script make sure environment is set for target container CHRMSP2
 	      $ export ORACLE_SID=CHRMSP2
 	      $ export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_2
 	      $ nohup clone_P_HRDP_pdb.sh &
+</code>
     	   ** Logs
+<code PLSQL>
    	      $ sqlplus / as sysdba
 	      SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 22 17:58:42 2023
 	      Version 19.17.0.0.0
  	      Copyright (c) 1982, 2022, Oracle.  All rights reserved.
 	      Connected to:
 	      Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
 	      Version 19.17.0.0.0
 	      SQL> show pdbs
 	          CON_ID CON_NAME                       OPEN MODE  RESTRICTED
 	          ---------- ------------------------------ ---------- ----------
 PDB$SEED                       READ ONLY  NO
 P_HRDP                         READ WRITE NO
 	      SQL> select name from v$services;
 		   NAME
 		   ----------------------------------------------------------------
 		   CHRMSP2XDB
 		   CHRMSP2.db.test.com
 		   SYS$BACKGROUND
 		   P_HRDP_SVC
 		   SYS$USERS
 		   P_HRDP
+</code>
-	       Note: Here, we can see that cloning the pdb will also copy all the services associate with source PDB
+**Note**: Here, we can see that cloning the pdb will also copy all the services associate with source PDB
 .Create a high availability service for the new PDB in CHRMSP2
+<code BASH>
 	  srvctl add service -db CHRMSP2 -pdb P_HRDP -service P_HRDP_SVC -failovertype SELECT -failovermethod BASIC -preferred "CHRMSP21,CHRMSP22"
@@ Ligne 226: / Ligne 179: @@
 	  srvctl status service -db CHRMSP2
+</code>
+. Rename global name of Source PDB(P_HRDP) to P_HRDP_OLD in source container CHRMSP1 (This step is required to avoid conflict of pdb with same name on same server)
-. Rename global name of Source PDB(P_HRDP) to P_HRDP_OLD in source container CHRMSP1 (This step
+  * Login to CHRMSP1 container
-           is required to avoid conflict of pdb with same name on same server)
-	   Login to CHRMSP1 container
 <code PLSQL>
 alter pluggable database P_HRDP close immediate instances=all;

Outils

menus et recherche rapide

recherche rapide

statut du site

Outils de la page

meta données pour cette page

Différences