Configuring the Alternate Recovery Appliance for Backup and Redo Failover
To configure the alternate Recovery Appliance, you perform tasks similar to setting up an upstream Recovery Appliance in a replication scenario.
Task 1 Create a protection policy for Backup and Redo Failover on the alternate Recovery Appliance
Follow the instructions in Creating a Protection Policy. Ensure that you set the store_and_forward
field to YES
.
For example, execute the following PL/SQL program to create an alt_brf
policy:
BEGIN DBMS_RA.CREATE_PROTECTION_POLICY ( protection_policy_name => 'alt_brf', description => 'For protected dbs on alternate', storage_location_name => 'delta', recovery_window_goal => INTERVAL '28' DAY, guaranteed_copy => 'NO', store_and_forward => 'YES'); END;
Task 2: Add the database to the protection policy on the alternate Recovery Appliance
Follow the instructions in Enrolling Protected Databases.
For example, execute the following PL/SQL program to add orcl12
to the alt_brf
policy that you created in the previous task:
BEGIN DBMS_RA.ADD_DB ( db_unique_name => 'orcl12', protection_policy_name => 'alt_brf', reserved_space => '128G'); END;
Task 3: Grant database access to the VPC user on the alternate Recovery Appliance
You created this user in "Task 1: Create a VPC user account and a replication user account on the primary Recovery Appliance".
Follow the instructions in Enrolling Protected Databases.
For example, execute the following PL/SQL program to grant the VPC user vpcuser
the required privileges on protected database orcl12
:
BEGIN DBMS_RA.GRANT_DB_ACCESS ( username => 'vpcuser', db_unique_name => 'orcl12'); END;