Database Reference
In-Depth Information
File Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18\
O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP.old
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18\
O1_MF_ANNNN_TAG20131018T153543_4HNOP6OH_.BKP.old
File Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18\
O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP.old
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1253 B F A DISK 18-OCT-13 1 1 YES
TAG20131018T152908
The CATALOG command can come in quite handy during disaster-recovery exercises when
all you have are backup set pieces and an Oracle Database instance. You can create the
instance, catalog the backup set pieces (including control-file autobackups), and then restore
your database. The CATALOG command works only with disk devices, so in disaster-recovery
cases you might first have to restore data files from tape before you can catalog them.
Using the RESYNC Command
The RESYNC command is used to synchronize the recovery catalog with the control file.
RMAN will often perform automatic resync operations, but there may be times when you
will want to perform a manual resync operation. Simply issue the RESYNC CATALOG command
and the catalog will be synchronized with the recovery catalog, as shown in this example:
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
Tuning RMAN Operations
The final topic in this section is how to tune RMAN operations. Of course, standard Oracle
tuning methodologies apply here; use enough backup devices to get good I/O performance.
Allocate enough memory to the database, and make sure your CPUs can handle the load.
Another method of tuning your RMAN operations is through parallel channel operations.
Recall that using channels is the method that RMAN uses to write backup-related information
Search WWH ::




Custom Search