DISABLE

The DISABLE function can be used to convert a snapshot standby database to a physical standby database.

DISABLE Function 

DBMS_DG.DISABLE (
     member_name          IN VARCHAR2,
     severity             OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter Description
member_name

The DB_UNIQUE_NAME initialization parameter value of the member to be disabled.

severity The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers:
  • ORA-0: normal, successful completion
  • ORA-16501: The Oracle Data Guard broker operation failed.
  • ORA-16502: The Oracle Data Guard broker operation succeeded with warnings.

Usage Notes

  • This function returns a binary integer.

  • This function can only be called while connected to a primary database.
Error Description
ORA-00000: normal, successful completion

The member was successfully disabled.
ORA-16540: invalid argument The name specified for the member was not a valid DB_UNIQUE_NAME value.
Other

The Data Guard broker was unable to disable the member and the return value will indicate the reason for this failure.