EDIT FAR_SYNC

The EDIT FAR_SYNC command changes the name, properties, or initialization parameters of a far sync instance.

Format

EDIT FAR_SYNC <db_unique_name>  RENAME TO <new_db_unique_name>;

EDIT FAR_SYNC <db_unique_name> SET PROPERTY <property_name> = value;

EDIT FAR_SYNC <db_unique_name> SET PARAMETER <parameter_name>=value [ initialization_parameter_options ];

Command Parameters

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the far sync instance for which you want to edit information. It must match (case_insensitive) the value of the corresponding database DB_UNIQUE_NAME initialization parameter.

new_db_unique_name

The new value of the DB_UNIQUE_NAME initialization parameter.

property_name

The name of an existing far sync instance-specific configurable property.

parameter_name

The name of the existing database initialization parameter that must be modified.

value

The new value for the property or parameter.

initialization_parameter_options

Additional options include the following:

• SCOPE: Set one of the following values for scope: SPFILE, MEMORY, or BOTH. The default value is BOTH. If the specified parameter is a static parameter, then set SCOPE=SPFILE.

• SID: Specify the name of a database instance for which the parameter must be set. If the specified parameter must be set for all instances, set SID=’*’.

Command Examples

The command that follows should replace "chicago_typo" with "chicago" and rename it to "dallas".

DGMGRL> DISABLE FAR_SYNC 'chicago_typo';
EDIT FAR_SYNC 'chicago_typo' RENAME TO 'chicago';
ENABLE FAR_SYNC 'chicago;

The following example sets the initialization parameter of a far sync instance named chicago.

DGMGRL> EDIT FAR_SYNC 'chicago' SET PARAMETER log_archive_trace=1;