Posts

Oracle Auto upgrade RAC with dataguard

 Upgrading RAC database from Oracle 11g (11.2.0.4) to Oracle 19c (19.9.0) Practical upgrade RAC and dataguard environment : >>>High-level steps of the AutoUpgrade process  1  Take a full backup of the primary database.  2  Enable the flashback feature in the primary and the physical standby database.  3  Set the fast recovery area size to a higher value in both the primary and the physical standby database.  4  Gather the dictionary statistics to the latest as this will help the database upgrade process to run faster.  5  Purge the recyclebin as this will help us to save time during the database upgrade and in reducing the  downtime needed for the database upgrade.  6  Ensure that the physical standby database is in sync with the primary database before starting the            database upgrade process.  7  Create a GRP in the physical standby database.  8  Dis...
Post a Comment
Read more
Image
  AutoUpgrade utility: The AutoUpgrade tool is a new upgrade utility which allows you to upgrade your Oracle databases with minimal manual intervention. The AutoUpgrade tool is designed in such a way that when it’s run, it not only identifies the issues before the database upgrade but also fixes them, and then performs the database upgrade and runs any post upgrade steps.  The AutoUpgrade tool can upgrade both the single instances and the cluster databases. It also supports both the non-container database(non-cdb) and thecontainer database(cdb) upgrades. The AutoUpgrade tool supports upgrading a non-cdb database to apluggable database(pdb) using one single command, and also supports all the operating systems where we can have the Oracle databases configured, and it upgrades multiple databases in one single operation. It is used only to upgrade the Oracle database NOT GRID  Support of the AutoUpgrade utility The AutoUpgrade tool can be used to upgrade the Oracle databases ...
Post a Comment
Read more