Create a Logical Standby Database

Create a Logical Standby Database

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment.

Logical Standby

STEP 1

As a step 1 we need to create Physical Standby DB. Please have look the link to create Physical Standby DB.

 How to Create Physical Standby Database Step by Step.

STEP 2

Now we need to convert Physical Standby DB to the Logical Standby DB

On standby DB.

STOP the MRP(managed recovery process) on standby.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

On primary Database.

To build the LogMiner dictionary in the redo stream of the primary database and to record additional information.

The logical standby database can be instantiated, issue the following SQL statement at the primary database

On primary database.

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

On standby database.

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY <db_name>;

ALTER DATABASE RECOVER TO LOGICAL STANDBY KARDBPRD2;  #need to put here db_name

shutdown immediate;

startup mount;

ALTER DATABASE OPEN RESETLOGS;

ALTER DATABASE START LOGICAL STANDBY APPLY;

##for realtime apply logs do

ALTER DATABASE START LOGICAL STANDBY APPLY immediate;

At this point Logical Standby Setup is completed.