Hello Friend's,
In This Post we will discuss about how to migrate database from Noncdb to PDB 19.3 using autoupgrade utility
So let's get started
Enviornment Used for Activity Noncdb to PDB :
Source :
Hostname : MUMSX0019c.database.com
Database : MIGDB
Version : 19.3.0
CDB/PDB : NON CDB/PDB
Oacle_Home : /oracle/app/orawork/product/19.0.0/db_1
OS : OEL 8.4
Target :
Hostname : MUMSX0019c.database.com
Database : CDBMIG
PDB : MIGDB
Version : 19.3.0
CDB/PDB : Yes
Oacle_Home : /oracle/app/orawork/product/19.0.0/db_1
OS : OEL 8.4
The Oracle AutoUpgrade software can be used to migrate a database from a non-CDB to a CDB (Container Database). The following are the steps for using AutoUpgrade in this Activity.
Database Status Before Migration :
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE DB_VERSION LOGINS LOG_MODE DB_UPTIME
--------- ------------------------------ -------------------- ---------- -------------------- ---------- -------------------- -----------------------------------
MIGDB MUMSX0019c.database.com PRIMARY READ WRITE 19.0.0.0.0 ALLOWED ARCHIVELOG 31-JAN-2024 17:41:20
Prepare the Configuration File:
Create a configuration file that includes the source (non-CDB) and target (CDB) details, such as Oracle Home directories, database names, versions, and other important factors. Specify the target_cdb argument to indicate which Container Database you wish to migrate.
global.autoupg_log_dir=/oracle/Autoupgrade/global_logs
upg1.log_dir=/oracle/Autoupgrade/convert_PDB_logs/
upg1.source_home=/oracle/app/orawork/product/19.0.0/db_1
upg1.target_home=/oracle/app/orawork/product/19.0.0/db_1
upg1.sid=MIGDB
upg1.target_cdb=CDBMIG
Prechecks:
Run AutoUpgrade in "analyze" mode to run prechecks. This phase ensures that the source database is ready to migrate to the target CDB.
Command : ./java -jar /oracle/Autoupgrade/autoupgrade.jar -config /oracle/Autoupgrade/noncdb_to_pdb.cfg -mode analyze
[oracle@MUMSX0019c bin]$ ./java -jar /oracle/Autoupgrade/autoupgrade.jar -config /oracle/Autoupgrade/noncdb_to_pdb.cfg -mode analyze
AutoUpgrade 23.4.230921 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be analyzed
Type 'help' to list console commands
upg> Job 100 completed
----- Execute AutoUpgrade in DEPLOY mode directly ----
ANALYZE and FIXUPS modes are not run when converting a Non-CDB database to a PDB
where the source and the target homes are the same version.
Job 100 for MIGDB
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Perform Migration:
Run AutoUpgrade in "deploy" mode to start the migration process.
Command : nohup java -jar /oracle/Autoupgrade/autoupgrade.jar -config /oracle/Autoupgrade/noncdb_to_pdb.cfg -mode deploy -noconsole &
[oracle@MUMSX0019c bin]$ java -jar /oracle/Autoupgrade/autoupgrade.jar -config /oracle/Autoupgrade/noncdb_to_pdb.cfg -mode deploy -noconsole
AutoUpgrade is not fully tested on OpenJDK 64-Bit Server VM, Oracle recommends to use Java HotSpot(TM)
AutoUpgrade 23.4.230921 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be processed
Job 101 database migdb
+----+-------+-----------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|10s ago|Executing describe|
+----+-------+-----------+---------+-------+----------+-------+------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 2s ago|Executing describe|
+----+-------+-----------+---------+-------+----------+-------+------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|14s ago|Executing describe|
+----+-------+-----------+---------+-------+----------+-------+------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|44s ago|Executing describe|
+----+-------+-----------+---------+-------+----------+-------+------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 5s ago|noncdb_to_pdb - 0%|
+----+-------+-----------+---------+-------+----------+-------+------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 5s ago|noncdb_to_pdb - 40%|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 5s ago|noncdb_to_pdb - 60%|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 5s ago|noncdb_to_pdb - 70%|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|35s ago|noncdb_to_pdb - 70%|
+----+-------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 4s ago|80% utlrp 24,342|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 2s ago|80% utlrp 22,588|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 1s ago|80% utlrp 21,748|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 0s ago|80% utlrp 19,922|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|30s ago|80% utlrp 19,922|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|29s ago|80% utlrp 18,358|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|28s ago|80% utlrp 16,871|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+----------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|27s ago|80% utlrp 13,072|
+----+-------+-----------+---------+-------+----------+-------+----------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|26s ago|80% utlrp 9,349|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|25s ago|80% utlrp 6,868|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|24s ago|80% utlrp 5,919|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|22s ago|80% utlrp 5,426|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|21s ago|80% utlrp 3,189|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|20s ago|80% utlrp 2,280|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+---------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|19s ago|80% utlrp 1,892|
+----+-------+-----------+---------+-------+----------+-------+---------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|18s ago|80% utlrp 966|
+----+-------+-----------+---------+-------+----------+-------+-------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|17s ago|80% utlrp 603|
+----+-------+-----------+---------+-------+----------+-------+-------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|16s ago|80% utlrp 255|
+----+-------+-----------+---------+-------+----------+-------+-------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|14s ago|80% utlrp 29|
+----+-------+-----------+---------+-------+----------+-------+------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|13s ago|80% utlrp 22|
+----+-------+-----------+---------+-------+----------+-------+------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|12s ago|80% utlrp 17|
+----+-------+-----------+---------+-------+----------+-------+------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+------------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|11s ago|80% utlrp 12|
+----+-------+-----------+---------+-------+----------+-------+------------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-----------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-----------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04|10s ago|80% utlrp 8|
+----+-------+-----------+---------+-------+----------+-------+-----------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-----------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-----------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 9s ago|80% utlrp 4|
+----+-------+-----------+---------+-------+----------+-------+-----------+
Total jobs 1
+----+-------+-----------+---------+-------+----------+-------+-----------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+----------+-------+-----------+
| 101| MIGDB|NONCDBTOPDB|EXECUTING|RUNNING| 19:33:04| 8s ago|80% utlrp 0|
+----+-------+-----------+---------+-------+----------+-------+-----------+
Total jobs 1
+----+-------+---------+---------+-------+----------+-------+-------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-------+
| 101| MIGDB|DBUPGRADE|EXECUTING|RUNNING| 19:33:04| 6s ago|Running|
+----+-------+---------+---------+-------+----------+-------+-------+
Total jobs 1
+----+-------+---------+---------+-------+----------+-------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------+
| 101| MIGDB|DBUPGRADE|EXECUTING|RUNNING| 19:33:04| 4s ago|90%Patching MIGDB|
+----+-------+---------+---------+-------+----------+-------+-----------------+
Total jobs 1
Job 101 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs restored [0]
Jobs pending [0]
Please check the summary report at:
/oracle/Autoupgrade/global_logs/cfgtoollogs/upgrade/auto/status/status.html
/oracle/Autoupgrade/global_logs/cfgtoollogs/upgrade/auto/status/status.log
Status HTML :
Summary report :
********************************************************************************
Datapatch Apply Summary Report for MIGDB
Return code = 0 SUCCESS
Failure reason = null
Total time = 21.6930019855499
Install patches = 0
Database Open = SUCCESS
Invocation Log = /oracle/app/orawork/cfgtoollogs/sqlpatch/sqlpatch_31174_2024_01_31_19_50_57/sqlpatch_invocation.log
Bootstrap Required = 0
Bootstrap Status = N/A
Bootstrap Log = N/A
Total patches = 0
Migration complete HTML :
Monitor Upgrade Progress:
I have used noconsole in the command so all the things are on the cmd you can also user -console in command and check the status using below commands : 1) lsj 2) status Or you can monitor the logs created by autoupgrade process
Database Status After Migration :
[oracle@MUMSX0019c bin]$ . oraenv
ORACLE_SID = [MIGDB] ? CDBMIG
The Oracle base remains unchanged with value /oracle/app/orawork
[oracle@MUMSX0019c bin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 31 20:12:26 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> col DB_UPTIME for a35
col DATABASE_ROLE for a20
col DB_VERSION for a20
set lines 200
col LOG_MODE for a20
set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,version DB_VERSION,LOGINS,LOG_MODE,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB_UPTIME" from v$database,gv$instance;
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE DB_VERSION LOGINS LOG_MODE DB_UPTIME
--------- ------------------------------ -------------------- ---------- -------------------- ---------- -------------------- -----------------------------------
CDBMIG MUMSX0019c.database.com PRIMARY READ WRITE 19.0.0.0.0 ALLOWED ARCHIVELOG 31-JAN-2024 18:39:59
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 MIGDB READ WRITE NO
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Testing After Migration :
After the migration is complete, perform any necessary post-upgrade steps specific to migrating from non-CDB to CDB. This may include tasks related to pluggable databases, user accounts, and application validations etc.
Cleanup :
If the non-CDB components are no longer required, you might need to clean them up, depending on your migration plan.
This concludes our activity of Migration from Non-CDB to CDB
Follow the below link for the Steps to Manual Migrate database from Noncdb to PDB
Migrate Database from NON-CDB to CDB (12.2 to 19c)
Hope This Help's
See You Next Post
Regards
Sultan Khan
ConversionConversion EmoticonEmoticon