Database Reference
In-Depth Information
input datafile file number=00018
name=+DATA/CDB1/E6ED2028263F4B27E0436638A8C088A6/DATAFILE/rman_catalog_tbs.275.826759035
channel ORA_DISK_3: starting piece 1 at 22.09.2013 17:34
channel ORA_DISK_3: finished piece 1 at 22.09.2013 17:34
piece handle=
+RECO/CDB1/E6[...]A6/BACKUPSET/2013_09_22/nnndf0_tag20130922t173446_0.312.826824889
tag=TAG20130922T173446 comment=NONE
[...]
Starting Control File and SPFILE Autobackup at 22.09.2013 17:35
piece handle=+RECO/CDB1/AUTOBACKUP/2013_09_22/s_826824903.282.826824905 comment=NONE
Finished Control File and SPFILE Autobackup at 22.09.2013 17:35
RMAN>
You can back up multiple Pluggable Databases in a comma-separated list if you like. In a similar way it is possible
to back up only the root, using the backup database root command. Again, a full backup of the whole CDB is likely
to be more efficient in many cases.
Another command that can be used specifically with Pluggable Databases as well is backup validate . This will
check for physical corruption of the files in the database, and can be instructed to check for logical corruption too.
Physical corruption can be caused by write errors to disk or other otherwise hard to detect problems such as filesystem
glitches if you are not using ASM anyway. The result can be seen immediately when the database wants to access a
certain physically corrupt block, it will report an error. Checks for logical corruption can be made by adding the check
logical clause to the backup validate command. An example check for Pluggable Database PDB1 is shown here:
RMAN> backup validate check logical pluggable database pdb1;
Starting backup at 22.09.2013 19:22
[...]
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009
name=+DATA/CDB1/DD7D8C1D4C234B38E04325AAE80AF577/DATAFILE/sysaux.261.826623815
[...]
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 20027 80668 2130003
File Name: +DATA/CDB1/DD7D8C1D4C234B38E04325AAE80AF577/DATAFILE/sysaux.261.826623815
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 14246
Index 0 7448
Other 0 38919
[...]
Finished backup at 22.09.2013 19:22
RMAN>
Search WWH ::




Custom Search