1. Oracle Database 21c New Features
  2. Performance and High Availability
  3. Data Guard
  4. Data Guard Broker Far Sync Instance Creation
 

Details: Data Guard Broker Far Sync Instance Creation

This slide explains how to add a far sync instance to a Data Guard Broker configuration using the CREATE FAR_SYNC command.

Data Guard Broker allows users to create and add a far sync instance to a Data Guard Broker configuration using the CREATE FAR_SYNC command.

Command Parameters

object-name: The value for the DB_UNIQUE_NAME initialization parameter of the far sync instance.

connect-identifier: A fully specified connect descriptor or a name to be resolved by an Oracle Net Services naming method (for example, TNS). The value you specify is also used as the initial value of the DGConnectIdentifier database property.

directory-location: A directory location value for the DB_RECOVERY_FILE_DEST initialization parameter of the new far sync instance. This is an optional parameter.

size: A size value for the DB_RECOVERY_FILE_DEST_SIZE initialization parameter of the far sync instance. If this command parameter is specified, the <directory-location> command parameter must be also specified. This is an optional command parameter.

string-value-pairs: A list of string pairs. The value is set to the LOG_FILE_NAME_CONVERT initialization parameter. In addition, the value is also set to the value of PARAMETER_VALUE_CONVERT clause when the RMAN DUPLICATE command is invoked. The PARAMETER_VALUE_CONVERT clause replaces the first string with the second string in all matching initialization parameter values. Multiple pairs of strings may be specified by this parameter. For example,  ' "string1", "string2", "string3", "string4", ...'  Where:

  • string1 is the pattern of initialization parameters of the primary database.
  • string2 is the pattern of initialization parameters of the far sync instance.
  • string3 is the pattern of initialization parameters of the primary database.
  • string4 is the pattern of initialization parameters of the far sync instance.

This is an optional argument. If not specified, a copy of the server parameter file on the primary database will be used on far sync instance without any modification. The following graphic shows an example of the CREATE FAR_SYNC command.