SUSPEND_DB

This procedure deletes all local disk backups associated with this database from the Recovery Appliance. Backups on tape, in the cloud, or replicated to other Recovery Appliances are not affected.

While a database is suspended, it will not accept backups. The database must be resumed before it can return to normal operation.

A suspended database does not have a reserved_space.

If the Recovery Appliance cannot delete the local backups owned by this database due to errors, then the SUSPEND_DB operation fails. If errors occur, then the backups from the specified database are not completely removed from the Recovery Appliance local storage. The Recovery Appliance logs errors that occur during the SUSPEND_DB procedure in the RA_INCIDENT_LOG view. If the wait parameter is specified as TRUE, then the Recovery Appliance also raises these errors in the session in which the SUSPEND_DB is called. If you diagnose the errors and fix the problem, then you can run SUSPEND_DB again.

Syntax

PROCEDURE suspend_db (
   db_unique_name IN VARCHAR2,
   wait IN BOOLEAN DEFAULT TRUE,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 21-51 SUSPEND_DB Parameters

Parameter	Description
db_unique_name	The DB_UNIQUE_NAME of the database to be suspended.
wait	The wait behavior of the procedure. If TRUE, then the procedure will not return until the backups and metadata for the specified database are completely removed from the Recovery Appliance. If FALSE, then the procedure returns immediately, and the database deletion operation continues in the background.
comments	Optional user supplied comment describing reason for executing this command.