Smarter DG Broker in Oracle 12c

In Oracle 11G, DG Broker needed to be told whether the standby database was physical or logical. The command to add database in 11G was something like this:

ADD DATABASE <DB Unique Name> AS CONNECT IDENTIFIER is <TNS Descriptor>

MAINTAINED AS [PHYSICAL|LOGICAL];

Oracle 12c is definitely smarter and can figure it out on its own. The “ADD DATABASE” syntax is simpler:

DGMGRL for 64-bit Windows: Version 12.1.0.2.0 – 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type “help” for information.
Connected as SYSDG.
DGMGRL> help add database

Adds a member to the broker configuration

Syntax:

ADD { BACKUP_APPLIANCE | DATABASE | FAR_SYNC } <object name>
[AS CONNECT IDENTIFIER IS <connect identifier>];

DGMGRL>

DG Broker will connect to the database and figure out what kind of a standby it is. The new version of DG Broker can also add Oracle’s “Zero Loss Backup Appliance”, and engineered system, or a “Far Sync Instance” for geographically dislocated standby databases. FAR SYNC looks like a very useful concept to me, but I haven’t yet had an opportunity to set one up. Here is a good article about it:

http://karandba.blogspot.com/2014/10/far-sync-in-oracle-12c-database.html

 

Advertisements

About mgogala

I am a long time Oracle DBA, who has worked on very large databases. I have worked with OPS and RAC since its inception.I am also a published book writer, having published two books about PHP. This blog is about the challenges and adventures in my professional life. Sorry, no family pictures here.
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to Smarter DG Broker in Oracle 12c

  1. DvE says:

    From 11.1 release it was already deprecated (maintained as):
    https://docs.oracle.com/cd/B28359_01/server.111/b28295/dgmgrl.htm#BABGIFID

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s