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
   ...
   RECOVER TO LOGICAL STANDBY: Complete - Database shutdown required after NID finishes
   *** DBNEWID utility started ***
   DBID will be changed from 1319333016 to new DBID of 773141456 for database ORCL
   DBNAME will be changed from ORCL to new...