Updating a Protection Policy
This section explains how to update protection policies using either Cloud Control (recommended) or the DBMS_RA
PL/SQL package.
You must be logged in to the metadata database as RASYS
or as a named db_user
with user_type=admin
. The protection policy must exist.
In this example, the protection policy is bronze_dev
and is changing its disk recovery window goal from 3 days to 6 days.
To update a protected database with Cloud Control:
-
Access the Protection Policies page, as described in "Accessing the Create Protection Policy Page in Cloud Control".
-
In the Protection Policies table, select the protection policy that you want to edit.
For example, select the
BRONZE_DEV
row. -
Click Edit.
The Edit Protection Policy page appears.
-
Change the desired values, and then click OK.
For example, in the Recovery Window field of the Disk Recovery Window Goal section, enter
6
.The Protection Policies page appears, with the newly updated protection policy listed.
To update a protection Policy with DBMS_RA:
To update a protection policy, execute the DBMS_RA.UPDATE_PROTECTION_POLICY
procedure. Parameters that are null retain their existing values. For example, if guaranteed_copy
is currently NO
for a protection policy, and if you specify null for this parameter in DBMS_RA.UPDATE_PROTECTION_POLICY
, then the value remains NO
.
-
Start SQL*Plus or SQL Developer, and then log in to the metadata database as
RASYS
or as a nameddb_user
withuser_type=admin
. -
Run the
DBMS_RA.UPDATE_PROTECTION_POLICY
procedure.For example, execute the following PL/SQL anonymous block:
BEGIN DBMS_RA.UPDATE_PROTECTION_POLICY( protection_policy_name => 'bronze_dev', recovery_window_goal => INTERVAL '6' DAY); END;
-
Optionally, query the recovery catalog to confirm the update of the policy.
For example, query
RA_PROTECTION_POLICY
as follows (sample output included):COL POLICY_NAME FORMAT a11 COL DESCRIPTION FORMAT a36 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 WHERE POLICY_NAME='BRONZE_DEV'; POLICY_NAME DESCRIPTION DD:HH:MM:SS ----------- ------------------------------------ --------------- BRONZE_DEV For protected dbs in bronze tier 06:00:00:00