Muhammad Nadeem Chaudhry's Blog

Oracle 18c Data Guard

Posted in Uncategorized by Muhammad Nadeem Chaudhry on January 1, 2019

A) Installation
– DB name should be same.
– Instance name (oralce unique name) should be different.
– A failover renders the original primary database useless for converting to a standby database. If flashback database is not enabled, the original primary must be scrapped and recreated as a standby database.

B) Application Connectivity

- Create database service using DBMS_SERVICE.CREATE_SERVICE package.
- Create entry in tnsnames.ora only for created service for addresses of hosts(s).

C) Concepts

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: