O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required