LOGICAL STANDBY CREATION STEPS

Step-1:

Using Grid Control create a new physical standby database on any machine but better on new. Then follow the following stpes to convert it into Logical standby.


Note: CREATE SERVICE dg03 ON THE THIRD NODE AND REGISTER THE SERVICE dg03 WITH LISTENER.


Step-2: On logical standby

SQL_Logical> alter database recover managed standby database cancel;


Step-3: Do nothing with pfile (It is updated automatically by Grid Control)

But just analyze the pfile and see the new entries added by Grid Control.


Step-4: On primary database, Ensures supplemental logging is enabled properly and builds the LogMiner dictionary by the this command

SQL_Primary> exec dbms_logstdby.build(); 


Note:
------
Use this procedure on the primary database to record relevant metadata (LogMiner dictionary) information in the redo log, which will subsequently be used by SQL Apply. This procedure will enable database-wide primary- and unique-key supplemental logging, if necessary.



Step-5: On logical standby fire this command to convert physical Standby db to Logical
---------------------------------------------------------------------------------------

SQL_Logical> alter database recover to logical standby dg04;


Step-6: on logical Standby Database
------------------------------------

SQL_Logical> shut immemdiate

SQL_Logical> startup mounts

SQL_Logical> alter database open resetlogs


Step-7: on Logical standby


SQL_Logical> alter database start logical standby apply immediate; ----> (it will start LSP)


Note: To stop LSP Process on logical standby 


SQL_Logical> alter database stop logical standby apply;


Step-8: Update Broker Configuration for new Logical Standby



Broker setup on dg01



1. (on dg01)DGMGRL> disable configuration

2. (on dg01) DGMGRL> remove configuration

3. DGMGRL> add database dg02 as connect identifier is 'dg02' maintained as physical;
Database "dg02" added

4. DGMGRL> add database dg04 as connect identifier is 'dg04' maintained as logical;
Database "dg04" added




5. DGMGRL> enable configuration;
Configuration
Name:                dgconfig1
Enabled:             YES
  Protection Mode:     MaxPerformance
  Fast-Start Failover: DISABLED
  Databases:
    dg01 - Primary database
    dg02 - Physical standby database
    dg04 - Logical standby database

Current status for "dgconfig1":

SUCCESS