Time for action – converting a physical standby database into a logical standby database
- 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;
- 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.