| « PREVIOUS « |
MAIN INDEX 19C HOL | » FALLBACK » |
In this part of the Hands-On Lab you will now unplug an Oracle 12.2.0.1 pluggable database (PDB) from CDB1 and plug it into 19c’s CDB2, including all the necessary steps.
Index
1. Preparation work in CDB1
The PDB3 we will use in this part of the lab is created already in CDB1 – but you need to startup CDB1 and PDB3.
. cdb1
sqlplus / as sysdba
startup
show pdbs
exit
2. AutoUpgrade will do it for you
In /home/oracle/scripts you will find a precreated config file for this task:
cat /home/oracle/scripts/PDB3.cfg
It has the following contents:
global.autoupg_log_dir=/home/oracle/logs
upg1.source_home=/u01/app/oracle/product/12.2.0.1
upg1.target_home=/u01/app/oracle/product/19
upg1.sid=CDB1
upg1.pdbs=PDB3
upg1.target_cdb=CDB2
upg1.log_dir=/home/oracle/logs
upg1.target_pdb_copy_option=file_name_convert=('CDB1', 'CDB2')
At first, run the analyze phase with autoupgrade:
java -jar $OH19/rdbms/admin/autoupgrade.jar -mode analyze -config PDB3.cfg
- In rare occasions, AutoUpgrade may give you an error that the content of PDB3.cfg has altered after the deploy. Then you need to clear the log information kept by AutoUpgrade:
java -jar $OH19/rdbms/admin/autoupgrade.jar -config PDB3.cfg -clear_recovery_data
You may want to check the HTML output from this analyze run:
firefox /home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.html &
There shouldn’t be any issues. AutoUpgrade will take care on everything.
Now you can initiate the deploy run which will repeat the analyze, then run the fixups, unplug the PDB, plug it in and upgrade it to Oracle 19c.
java -jar $OH19/rdbms/admin/autoupgrade.jar -mode deploy -config PDB3.cfg
Of course, you can monitor the upgrade automatically in your browser as well:
firefox /home/oracle/logs/cfgtoollogs/upgrade/auto/state.html
In your xterm you may receive this output after approximately 10-15 minutes:
upg> Job 102 completed ------------------- Final Summary -------------------- Number of databases [ 1 ] Jobs finished [1] Jobs failed [0] Jobs pending [0] Please check the summary report at: /home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.html /home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.log
Done.
If you’d like, you can now try some fallback exercises. For this part of the lab you should restore the initial snapshot again.
Mark the initial snapshot in the VirtualBox Manager with the mouse <click>:
Then <click> on the Restore icon.
| « PREVIOUS « |
MAIN INDEX 19C HOL | » FALLBACK » |
