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 ...

Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.