Database Reference
In-Depth Information
As you would have imagined the Point-In-Time-Restore of a PDB is not all too different from a Tablespace
Point-In-Time-Recovery which has been with Oracle for a while. The RMAN script above can be divided into two major
steps. The first is simple and is a restore of the PDB's data files to their respective locations. It is during the recover step
where the similarity begins with the “Tablespace Point In Time Recovery”. Although optional you should really specify a
location where the auxiliary instance is going to be created. A file system location worked well even with ASM-it could
be a NAS mount or similar. You will notice the creation of an auxiliary instance on the host for which you should ensure
sufficient memory to be available. The instance name will be randomly chosen to avoid conflicts with existing Oracle
instances, in the example above the auxiliary instance was named zgsF. You will see this output as part of the RMAN
command output you entered.
Creating automatic instance, with SID='zgsF'
initialization parameters used for automatic instance:
db_name=CDB1
db_unique_name=mqol_pitr_pdb1_CDB1
compatible=12.1.0.0.0
db_block_size=8192
db_files=200
sga_target=1G
processes=80
diagnostic_dest=/u01/app/oracle
db_create_file_dest=/u01/temp
log_archive_dest_1='location=/u01/temp'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
Since a Fast Recovery Area was configured it has been used for the temporary destination for the restored files.
At the end of the process the PDB was indeed restored to the SCN in question, and the table contained the
correct values:
SQL> select * from user1.t_1;
ID
----------
1
3
Full restore and recovery of a PDB is no different from restoring a non-CDB in principle. You connect to the
CDB$ROOT before starting the commands. To restore a PDB you are required to add the “pluggable” keyword as
shown here:
RMAN> select open_mode from v$pdbs where name = 'PDB1';
OPEN_MODE
----------
MOUNTED
RMAN> run {
2> allocate channel c1 device type disk;
3> restore pluggable database pdb1;
Search WWH ::




Custom Search