Posted by Shaik Ahmed Ali on December 13, 2020 | No comments
In oracle 19c we have a new feature called "Autoupgrade utility "
Autoupgrade:
An autoupgrade utility is a feature that releases in the 19c Oracle database which is available for on-premises also.
it consists of the configuration file in which we need to mention the details of the source and target oracle home for an upgrade.
autoupgrade utility identifies the issue before the upgrade and performs the pre and post-upgrade actions, deploy upgrade, perform post-upgrade actions, and start the upgrade database.
you can also upgrade multiple databases at the same time using this utility with a single configuration file.
so the manual work for an upgrade can be handle by this utility.
Download Autoupgrade.jar:
In oracle 19.3 or later release the autoupgrade.jar file exists by default but oracle strongly recommend to download the latest jar file from my oracle support Document 2485457.1
Modes of Autoupgrade Utility:
- Analyze
- Fixup
- Deploy
Analyze:
In analyze mode, it performs a read-only analysis of the database before the upgrade and finds the issues which might prevent the database from the upgrade, you can run the analyze mode while the database is in normal operation mode.
it also creates the Html file under the log directory which consists of error which can prevent us from upgrade so you can solve it by possible fixups like by running the fixup script or manual intervention.
Fixup:
In fixup mode, the utility performs the error fixups which are found in the analyze mode before the upgrade.
Deploy:
In deploy mode, the auotupgrade utility performs the actual upgrade of the database, and after it also does the post-upgrade script actions. it also confirms that the upgrade is succeeded and copied the networking files( listener,tnsname,sqlnet) from source to target home and start the instance from the target home.
For more details on autoupgrade utility you can reach the below link
Posts
0 comments:
Post a Comment