Database Reference
In-Depth Information
4> recover pluggable database pdb1;
5> alter pluggable database pdb1 open;
6> }
[...]
Starting restore at 23.09.2013 14:53
[...]
Finished restore at 23.09.2013 14:53
[...]
Starting recover at 23.09.2013 14:55
[...]
starting media recovery
[...]
media recovery complete, elapsed time: 00:01:01
Finished recover at 23.09.2013 14:56
You can also restore individual tablespaces and datafiles. The good news is that if you connect to the PDB directly
you need not change your recovery scripts; almost everything works as before in the context of the PDB. There are
a few commands that are not applicable in the context of the PDB, they are documented in the official “Backup and
Recovery User's Guide”, Chapter 4 in section “Restrictions when Connected to a PDB”.
There are differences when you perform restore and recover operations from the context of the CDB. It is easier
to explain using an example. You might remember the syntax from the introduction section about the Data Recovery
Advisor. In this particular scenario tablespace TBS_1 of Pluggable Database PDB1 needs to be restored and recovered.
In the example the user is connected directly to the PDB.
RMAN> run {
2> allocate channel c1 device type disk;
3> alter tablespace PDB1_TBS_2 offline;
4> restore tablespace PDB1_TBS_2;
5> recover tablespace PDB1_TBS_2;
6> alter tablespace PDB1_TBS_2 online;
7> }
allocated channel: c1
channel c1: SID=30 device type=DISK
Statement processed
Starting restore at 22.09.2013 22:08
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
[...]
Finished restore at 22.09.2013 22:08
Starting recover at 22.09.2013 22:08
starting media recovery
archived log for thread 1 with sequence 92 is already on disk as file ...
[...]
Search WWH ::




Custom Search