#OrclDB #DBUpgrade #aioug Webinar Series July 2021: Database Upgrade and Migrations
https://buff.ly/2SE2pWA
0
0
0
0
Hashtag
#DBUpgrade
Advertisement · 728 × 90
#OraTidbit #DBUpgrade By default, the Oracle Multitenant Replay Upgrade method is enabled for upgrades on PDBs and CDBs. To disable the Parallel Upgrade Utility (http://catctl.pl default of performing a Replay Upgrade, run ALTER DATABASE UPGRADE SYNC OFF on CDB$ROOT.
0
0
0
0
#OraTidbit #DBUpgrade If you plug in an earlier release PDB to a new release CDB, then the CDB detects on opening the PDB that the PDB is an earlier release than the CDB, and automatically starts a Replay Upgrade process.
0
0
0
0
#OraTidbit #DBUpgrade Use the Oracle Database Parallel Upgrade Utility with the -T option to take schema-based tablespaces offline during upgrade. The file headers of READ ONLY tablespaces are updated when they are changed to READ WRITE.
0
0
0
0
#oratidbit #dbupgrade Database Upgrade Assistant (DBUA) has an option to use flashback database feature for restoring and recovering the Database in case of upgrade failure. This can be done by selecting the option "Use Flashback and Guaranteed Restore Point".
0
0
0
0
#oratidbit #dbupgrade Make all tablespaces OFFLINE NORMAL or make READ ONLY except for SYSTEM, SYSAUX, <UNDO> prior to upgrade. If upgrade fails, only the SYSTEM and rollback datafiles need to be restored rather than the entire database.
0
0
0
0