ADD_DB

This procedure adds the specified database to the Recovery Appliance, and assigns a protection policy to the database. This procedure enables a non-protected database to attain the status of a protected database.

Enrolling a database with the Recovery Appliance involves:

adding the protected database with ADD_DB.

granting access to this database to a Recovery Appliance user account (GRANT_DB_ACCESS).

registering this database in the virtual private catalog (RMAN REGISTER DATABASE command). The protected database must be enrolled before Recovery Appliance can process backup and restore operations.

You cannot use this procedure to add additional databases in a physical standby configuration. Such databases will be automatically recognized as they perform recovery catalog resynchronizations.

Syntax

PROCEDURE add_db (
   db_unique_name IN VARCHAR2,
   protection_policy_name IN VARCHAR2,
   reserved_space IN VARCHAR2 DEFAULT NULL,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 22-4 ADD_DB Parameters

Parameter	Description
`db_unique_name`	The `DB_UNIQUE_NAME` of the database to add.
`protection_policy_name`	The name of the protection policy to assign to the database. The protection policy must exist.
`reserved_space`	The amount of disk space that is guaranteed to be available for the protected database. The format of this value is a character string that must contain a number consisting only of the characters `0-9`, followed optionally by one of the following unit specifiers: `K`: Kilobytes `M`: Megabytes `G`: Gigabytes `T`: Terabytes `P`: Petabytes If no unit is specified, then the Recovery Appliance interprets the value as a number of bytes. `reserved_space` may be specified as a `NULL` if the controlling protection policy supports the `autotune_reserved_space` feature.
`comments`	Optional user supplied comment describing reason for executing this command.