Updating Protected Database Properties

This section explains how to update protected database properties using either Cloud Control (recommended) or the DBMS_RA command-line interface.

Cloud_Control
Command_Line

To update a protected database properties with Cloud Control:

Assume that you have the following business requirements:

You want to change the protection policy for protected database ORCL11 from GOLD to BRONZE.
You want change the reserved space from 6355 GB to 7000 GB.
You want to change the Recovery Appliance user account associated with this protected database from rauser11 to rauser12.

Access the Protected Databases page, as described in "Accessing the Recovery Appliance Home Page".
Click Edit.

The Edit Protected Databases page appears.
Change the desired attributes of the protected database, and then click OK:
- In the Protection Policy section, select the row for the policy named BRONZE.
  
  For example, select All.
- In the Reserved Space field, enter the new minimum amount of disk space to be reserved for this protected database.
  
  For example, enter 7000, and then select GB for the units.
- In the Recovery Appliance User section, enter the credentials for the database user rauser12.
The newly updated database appears in the table of protected databases.

To update a protected database properties with DBMS_RA:

Assume that you have the following business requirements:

You want to change the protection policy for protected database zdlrac from silver to bronze.

Start SQL*Plus or SQL Developer, and then log in to the metadata database as RASYS or as a named db_user with user_type=admin.

Query the existing protection policies.

For example, execute the following query (sample output included):

COL POLICY_NAME FORMAT a11
COL DESCRIPTION FORMAT a35
SELECT POLICY_NAME, DESCRIPTION, 
       TO_CHAR(EXTRACT(DAY FROM RECOVERY_WINDOW_GOAL),'fm00')||':'||
       TO_CHAR(EXTRACT(HOUR FROM RECOVERY_WINDOW_GOAL),'fm00')||':'||
       TO_CHAR(EXTRACT(MINUTE FROM RECOVERY_WINDOW_GOAL),'fm00')||':'||
       TO_CHAR(EXTRACT(SECOND FROM RECOVERY_WINDOW_GOAL),'fm00')
         AS "DD:HH:MM:SS"
FROM   RA_PROTECTION_POLICY;
 
POLICY_NAME DESCRIPTION                         DD:HH:MM:SS
----------- ----------------------------------- ---------------
BRONZE      For protected dbs in bronze tier    01:00:00:00
SILVER      For protected dbs in silver tier    07:00:00:00
GOLD        For protected dbs in gold tier      14:00:00:00

Determine which protected databases are associated with which protection policies.

For example, execute the following query (sample output included):

SELECT d.DB_UNIQUE_NAME, d.POLICY_NAME
FROM   RA_PROTECTION_POLICY p, RA_DATABASE d
WHERE  p.policy_name=d.policy_name
ORDER BY d.DB_UNIQUE_NAME;
 
DB_UNIQUE_NAME                   POLICY_NAME
-------------------------------- -----------
ZDLRA                            BRONZE
ZDLRAC                           SILVER
.
.
.

Run the DBMS_RA.UPDATE_DB procedure to associate a database with a new policy.

For example, execute the following PL/SQL anonymous block to associate the database named zdlrac, which has silver as its current policy, with the protection policy named bronze:
```
BEGIN
 DBMS_RA.UPDATE_DB(
   db_unique_name             => 'zdlrac',
   protection_policy_name     => 'bronze');
END;
```

Optionally, confirm that the database is associated with the correct policy.

For example, execute the following query (sample output included):

SELECT d.DB_UNIQUE_NAME, d.POLICY_NAME
FROM   RA_PROTECTION_POLICY p, RA_DATABASE d
WHERE  p.POLICY_NAME=d.POLICY_NAME
ORDER BY d.DB_UNIQUE_NAME;
 
DB_UNIQUE_NAME                   POLICY_NAME
-------------------------------- -----------
ZDLRA                            BRONZE
ZDLRAC                           BRONZE
.
.
.