Recipe: Restore and Recovery point in time of Single Pluggable Database with Veeam Plugin for Oracle RMAN

Expected deliverables:

Point in Time Restore and Recovery of Single Pluggable database.

Time to complete: 10 minutes

Ingredients: The account with Oracle SYSDBA access. The oracle environment should be set. Configured Veeam Plugin for Oracle RMAN. Healthy Oracle Container Database.

Before you start: User account with SysDBA permissions. Veeam Plugin for Oracle RMAN installed and configured.

Method:

1. rman target /
2. RMAN> run { SET UNTIL TIME “to_date(‘01-June-2022 04:00:00’,’DD-MON-YYYY HH24:MI:SS’)”; RESTORE PLUGGABLE DATABASE dbname; RECOVER PLUGGABLE DATABASE dbname; ALTER PLUGGABLE DATABASE dbname; }

---