Time for action – performing a rolling upgrade using the transient logical standby database

We will now see a step-by-step approach to upgrade a database from 11.2.0.1 to 11.2.0.3.

1. Ensuring protection mode and compatibility: Ensure the protection mode is in either maximum performance or maximum availability.

   SQL> select * from v$version;
   BANNER
   -----------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
   PL/SQL Release 11.2.0.1.0 - Production
   CORE    11.2.0.1.0      Production
   TNS for Linux: Version 11.2.0.1.0 - Production
   NLSRTL Version 11.2.0.1.0 - Production
   SQL> select protection_mode from v$database;
   PROTECTION_MODE
   --------------------
   MAXIMUM PERFORMANCE

   The COMPATIBLE initialization parameter should be same as the software release version. Once we upgrade to the new release and after all the post checks, we can change the compatible parameter value.

   SQL> show parameter compatible
   NAME              TYPE...