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
No comments:
Post a Comment