Time for action – converting a physical standby database into a logical standby database

  1. Execute the following special recovery command on the standby database in order to recover it until the SCN that the dictionary was built:
    SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY ORCL2;
    
    Database altered.
  2. At the same time, if you check the standby database alert log you'll see the following lines:
    Media Recovery Log /u01/app/oracle2/archive/1_106_791552282.arc
    Media Recovery Log /u01/app/oracle2/archive/1_107_791552282.arc
    Incomplete Recovery applied until change 1873735 
    Media Recovery Complete (INDIA)
    ...
    RESETLOGS after incomplete recovery UNTIL CHANGE 1873735
    Resetting resetlogs activation ID 1319360408 (0x4ea3d798)
    standby became primary SCN: 1873733 ...

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.