CONVERT_TO_PHYSICAL

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

CONVERT_TO_PHYSICAL Function

Format

DBMS_DG.CONVERT_TO_PHYSICAL (
     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 snapshot standby database to be converted to a physical 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.
The client must be connected to the primary database to call this function.
The snapshot standby database must be running in mount mode for the conversion to physical standby to complete.

Return Values

Error	Description
`ORA-00000: normal, successful completion`	The snapshot standby database was successfully converted to a physical standby database.
`ORA-16540: invalid argument`	The name specified for the database was not a valid `DB_UNIQUE_NAME` value.
`ORA-16732: Oracle Clusterware is restarting the database instance`	Oracle Clusterware is restarting the database to the mode required by the broker to convert the snapshot standby database to a physical standby database. Wait for the database to complete restarting and then retry this function call.
`ORA-16897: start database to mount mode`	The conversion to physical standby could not be performed because the snapshot standby database was not running in mount mode. Restart the database to mount mode and retry this function call.
`ORA-16899: Operation requires a connection to the primary database.`	This function must be called while connected to the primary database to complete. Reconnect to the primary database and retry this function call.
`Other`	The Data Guard broker was unable to convert the database and the return value will indicate the reason for this failure.