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

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.