We’ll show a tool developed by NUCLI that orchestate automated flows to upgrade large Oracle Database fleet in a safe and quick way with minimal downtime. The toolallows the execution of database upgrade by Operators without Oracle Database experience with support of Oracle Database Administrators.
Minimal downtime is achieved using “Transient Logical Standby” feature. The developed method allows testing the applications behaviour over the new version in the first cycle that execute a provisioning of an upgraded Oracle Database. The second cycle executes an upgrade over the Logical Standby database on the same or different hardware infrastructure and new version is usable by the applications. The method guarantee rollback and the availability of Disaster Recover