Hello Friend's,
In this mode we will see the Pratical steps for Autoupgrade deploy option .
Steps Done in deploy mode :
1) SETUP
2) Peupgrade
3) prechecks
4) GRP
5) PREFIXUPS
6) DRAIN
7) DBUPGRADE
8) Postchecks
9) POSTFIXUPS
10) POSTUPGRADE
iv) Deploy
This mode is one of the most important modes of all, I will say it's an all-inclusive mode does all things in one
such as prechecks ,creating restore point ,upgrade , post-checks
it can be called as unattended mode no interventions needed
e.g command : $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode deploy
[oracle@Linux-Mach oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode deploy
AutoUpgrade tool launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be processed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 100| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/25 15:56|15:56:41|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------+
| 100| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/25 15:56|15:57:10|Remaining 92/212|
+----+-------+---------+---------+-------+--------------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
| 100| Aupg|PREFIXUPS|EXECUTING|FINISHED|21/02/25 15:56|15:58:38|Loading database information|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+-----+---------+-------+--------------+--------+----------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----+---------+-------+--------------+--------+----------------------+
| 100| Aupg|DRAIN|EXECUTING|RUNNING|21/02/25 15:56|15:58:43|Shutting down database|
+----+-------+-----+---------+-------+--------------+--------+----------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|15:59:21|Running|
+----+-------+---------+---------+-------+--------------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|15:59:30|0%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:11:40|32%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:17:45|49%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:20:47|59%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:32:56|93%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:34:44|0%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:37:46|3%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:49:57|21%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:53:00|21%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:53:00|21%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|16:59:05|32%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/oracle/config_upgrd.txt]
General logs location [/oracle/autoupg/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [1]
Jobs stage summary
Job ID: 100
DB name: Aupg
SETUP <1 ----------------="" ------------="" 1="" 60="" cpu="" dbupgrade="" drain="" grp="" in="" jvm="" mb="" memory="" min="" prechecks="" prefixups="" preupgrade="" processes="" progress="" resources="" threads="" upg="" use="" used=""> tasks
+---+-----------------------+-------------+
| ID| NAME| Job#|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 57| event_loop|TIMED_WAITING|
| 58| console| RUNNABLE|
| 59| queue_reader| WAITING|
| 60| cmd-0| WAITING|
| 61| job_manager-0| WAITING|
| 62| bqueue-100| WAITING|
|454| exec_loop| WAITING|
|876| pool-4-thread-1| WAITING|
|877| pool-4-thread-2| WAITING|
|878| monitor_aupg-pdb$seed|TIMED_WAITING|
|879| monitor_aupg-pdbupg|TIMED_WAITING|
|883| catctl_PDB$SEED| WAITING|
|884| catctl_PDBUPG| WAITING|
|885| abort_monitor_PDB$SEED|TIMED_WAITING|
|886| abort_monitor_PDBUPG|TIMED_WAITING|
|887| async_read| RUNNABLE|
|888| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:05:10|41%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:05:10|41%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:08:12|49%Upgraded PDBUPG|
+----+-------+---------+---------+-------+--------------+--------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:11:15|54%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:14:17|67%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:23:25|91%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 100| Aupg|DBUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:23:25|91%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+----------------------------+
| 100| Aupg|POSTFIXUPS|EXECUTING|RUNNING|21/02/25 15:56|17:35:27|Loading database information|
+----+-------+----------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
| 100| Aupg|POSTUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:37:35|Creating final SPFILE|
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
Total jobs 1
upg> lsj
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
| 100| Aupg|POSTUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:37:35|Creating final SPFILE|
+----+-------+-----------+---------+-------+--------------+--------+---------------------+
Total jobs 1
upg> lsj
+----+-------+-----------+---------+-------+--------------+--------+----------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----------+---------+-------+--------------+--------+----------+
| 100| Aupg|POSTUPGRADE|EXECUTING|RUNNING|21/02/25 15:56|17:38:04|Restarting|
+----+-------+-----------+---------+-------+--------------+--------+----------+
Total jobs 1
upg> Job 100 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs pending [0]
---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from Aupg: drop restore point AUTOUPGRADE_9212_AUPG122010
Please check the summary report at:
/oracle/autoupg/cfgtoollogs/upgrade/auto/status/status.html
/oracle/autoupg/cfgtoollogs/upgrade/auto/status/status.log
Output of STATUS logfile :
/oracle/autoupg/cfgtoollogs/upgrade/auto/status/status.log
[oracle@Linux-Mach oracle]$ cat /oracle/autoupg/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Thu Feb 25 17:38:39 IST 2021
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] Aupg
[Version Before Upgrade] 12.2.0.1.0
[Version After Upgrade] 19.3.0.0.0
------------------------------------------
[Stage Name] GRP
[Status] SUCCESS
[Start Time] 2021-02-25 15:56:40
[Duration] 0:00:00
[Detail] Please drop the following GRPs after Autoupgrade completes:
AUTOUPGRADE_9212_AUPG122010
------------------------------------------
[Stage Name] PREUPGRADE
[Status] SUCCESS
[Start Time] 2021-02-25 15:56:41
[Duration] 0:00:00
[Log Directory] /oracle/autoupg/Aupg/100/preupgrade
------------------------------------------
[Stage Name] PRECHECKS
[Status] SUCCESS
[Start Time] 2021-02-25 15:56:41
[Duration] 0:00:47
[Log Directory] /oracle/autoupg/Aupg/100/prechecks
[Detail] /oracle/autoupg/Aupg/100/prechecks/aupg_preupgrade.log
Precheck passed and no manual intervention needed
------------------------------------------
[Stage Name] PREFIXUPS
[Status] SUCCESS
[Start Time] 2021-02-25 15:57:29
[Duration] 0:01:13
[Log Directory] /oracle/autoupg/Aupg/100/prefixups
------------------------------------------
[Stage Name] DRAIN
[Status] SUCCESS
[Start Time] 2021-02-25 15:58:42
[Duration] 0:00:22
[Log Directory] /oracle/autoupg/Aupg/100/drain
------------------------------------------
[Stage Name] DBUPGRADE
[Status] SUCCESS
[Start Time] 2021-02-25 15:59:05
[Duration] 1:33:54
[Log Directory] /oracle/autoupg/Aupg/100/dbupgrade
------------------------------------------
[Stage Name] POSTCHECKS
[Status] SUCCESS
[Start Time] 2021-02-25 17:32:59
[Duration] 0:02:18
[Log Directory] /oracle/autoupg/Aupg/100/postchecks
[Detail] /oracle/autoupg/Aupg/100/postchecks/aupg_postupgrade.log
------------------------------------------
[Stage Name] POSTFIXUPS
[Status] SUCCESS
[Start Time] 2021-02-25 17:35:18
[Duration] 0:02:15
[Log Directory] /oracle/autoupg/Aupg/100/postfixups
------------------------------------------
[Stage Name] POSTUPGRADE
[Status] SUCCESS
[Start Time] 2021-02-25 17:37:34
[Duration] 0:01:04
[Log Directory] /oracle/autoupg/Aupg/100/postupgrade
------------------------------------------
Output of Status.html
ConversionConversion EmoticonEmoticon