In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side.

Below is the environment detail:

Type Hostname db_unique_name
Primary host01 orclpri
Standby host02 orclsby

Enable force logging on primary.

2. Create standby with DBCA. Assume we have listener is running on primary side.

3. Standby Created successfully. Now we are going to login and check the roles.

Standby will automatically create pfile, spfile & orapwdfile.

Modify the tnsnames.ora on both sides.

Note: This feature only supports non-cdb database. You will get below error.

Stay Tuned for more detail on DG Broker Configuration.

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:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

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