DBMS_RA Procedures Relating to Protected Database Access

You can use the DBMS_RA package to configure protected database access. Table 8-1 describes the principal program units relating to protected databases.

Table 8-1 DBMS_RA Protected Database Access Procedures

Program Unit Description

ADD_DB

Adds metadata for the specified database to Recovery Appliance, and assigns a protection policy to the database. Note that you must set the reserved_space parameter unless the protection policy is using autotune_reserved_space.

DELETE_DB

Removes metadata for the specified database from Recovery Appliance. All metadata and backups of this database are deleted, from both disk and SBT.

SUSPEND_DB

Removes metadata for the specified database from Recovery Appliance. All metadata and backups of this database are deleted, from both disk and SBT. 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.

RESUME_DB

Restores a suspended database to normal operation. Only suspended databases may be resumed. Suspended databases must be resumed before they can be backed up.

UPDATE_DB

Changes the attributes that are assigned to the specified protected database.

GRANT_DB_ACCESS

Grants Recovery Appliance privileges to a user for a specified database.

REVOKE_DB_ACCESS

Revokes Recovery Appliance privileges from a user for a specified database.