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 to

  1. Ensuring protection mode and compatibility: Ensure the protection mode is in either maximum performance or maximum availability.
    SQL> select * from v$version;
    -----------------------------------------------------------Oracle Database 11g Enterprise Edition Release - 64bit Production
    PL/SQL Release - Production
    CORE      Production
    TNS for Linux: Version - Production
    NLSRTL Version - Production
    SQL> select protection_mode from v$database;

    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.