Dell Avamar for Oracle 19.10 User Guide

Restoring pluggable databases

Perform the following steps to restore pluggable database.

1. Open a command shell.
2. Log in to Oracle RMAN by using the Oracle user ID and password.
   The command prompt changes to an RMAN prompt.
3. Connect to the Oracle database to back up.
4. Back up the Oracle database by typing RMAN commands similar to the following commands:

   run {
   ALTER PLUGGABLE DATABASE pdbname CLOSE; allocate channel c0
   type sbt PARMS="SBT_LIBRARY=install-dir/lib/libobk_avamar.so"
   format '%d_%U'; send channel='c0' ' "prefix=12/db"
   "--cacheprefix=db-c0" "--bindir= install-dir/bin"
   "--flagfile=/path/my-avtarflags.txt"
   "--taskfile=/path/taskfile.txt" '; set until scn XXXXX; #set until
   time "TO_DATE('DATE--2021 08:05:57','DD-MON-YYYY HH24:MI:SS')";
   #current SCN or current Time Stamp; any one of them can be used
   restore pluggable database pdbname; recover pluggable database
   pdbname; ALTER PLUGGABLE DATABASE PDBname OPEN RESETLOGS;
   }

   Where:

   • install-dir is the base installation directory for the platform. For example, specify /usr/local/avamar on Linux, /opt/AVMRclnt on Solaris, C:\Progra~1\avs\bin on Windows, and so on.
   • pdbname is the Oracle pluggable database to be backed up