Example: Recovering a PDB in an Oracle RAC Environment
The process to restore and recover a PDB in an Oracle Real Application Clusters (Oracle RAC) environment has some slight additions to the non-Oracle RAC process. This example demonstrates how to recover a PDB in an Oracle RAC environment.
To restore and recover a PDB in an Oracle RAC environment:
-
Ensure that the prerequisites described in “Prerequisites for Restoring and Recovering Data from Recovery Appliance” are met.
-
Use RMAN to connect to the root of the CDB as
TARGETand the Recovery Appliance catalog asCATALOGas described in “Connecting to the Protected Database and Recovery Appliance Using CLI”. -
Ensure that all instances of the affected PDB are closed.
The following command closes all instances of the PDB
hr_pdb.ALTER PLUGGABLE DATABASE "hr_pdb" CLOSE IMMEDIATE INSTANCES=all; -
Restore and recover the affected PDB in your protected database.
The following command restores and recovers the
hr_pdb.RUN { ALTER PLUGGABLE DATABASE "hr_pdb" CLOSE IMMEDIATE; RESTORE PLUGGABLE DATABASE 'hr_pdb'; RECOVER PLUGGABLE DATABASE 'hr_pdb'; ALTER PLUGGABLE DATABASE "hr_pdb" OPEN RESETLOGS; ALTER PLUGGABLE DATABASE "hr_pdb" OPEN INSTANCES=all; }