In the previous article, we have seen Preparation and consideration we need to see before creating Logical Standby Database.

Preparing to Create a Logical Standby Database

We can use following steps to create Logical Standby Database.

Prerequisites : Physical Standby database already created.

Step 1: Check Physical Standby Database is created and is synchronized with Primary Database.

Primary Database :

Archive log sequence at Primary Database.

Standby Database :

Maximum Archive log sequence at Standby database

Step 2 : At Primary Database , Build a Log Miner Dictionary in redo data so that sql apply can properly interpret changes in the redo

When execute this, supplemental logging is automatically enabled , if not already enabled.

Step 3 : Cancel recovery at Physical Standby Database :

Step 4 : Shut down standby database:

Step 5 : Start database in mount state.

Note : Database needs to be in mount state to create logical standby database.

Step 6 : Use the following command to create logical standby database.

Step 7: the Open database with a resetlogs  option

Step 8 : Start logical apply recovery

Step 9 : Check database role and open mode in logical standby database :

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.