CONVERT_TO_SNAPSHOT

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

CONVERT_TO_SNAPSHOT Function

Format

DBMS_DG.CONVERT_TO_SNAPSHOT (
     db_name          IN VARCHAR2,
     severity         OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter Description
db_name

The DB_UNIQUE_NAME initialization parameter value of the physical standby database to be converted to a snapshot standby 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.

Return Values

Error Description
ORA-00000: normal, successful completion

The database was successfully converted to a snapshot standby database.
ORA-16540: invalid argument The name specified for the database was not a valid DB_UNIQUE_NAME value.
Other

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