SET_STATE_TRANSPORT_OFF

The SET_STATE_TRANSPORT_OFF function can be used to set the redo transport state to off for a primary database.

SET_STATE_TRANSPORT_OFF Function

DBMS_DG.SET_STATE_TRANSPORT_OFF (
     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 primary database.
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.

• The transport state can only be set to off for a primary database.
• All instances of an Oracle RAC database are affected by this database state change.

Return Values

Error	Description
ORA-00000: normal, successful completion	The transport state for the primary database was successfully set to OFF.
Other	The Data Guard broker was unable to set the transport state to OFF and the return value will indicate the reason for this failure.