In our
dw database, these two parameters are not needed; all archived log files needed to recover the
database are kept in the flash recovery area on disk to support the defined retention policy.
464 Oracle Database 11g DBA Handbook
Validating Restore Operations
Earlier in this chapter, we validated the data blocks in the datafiles that we want to back up. In
this section, we??™ll take the opposite approach and instead validate the backups that we have
already made. We??™ll also find out from RMAN which backupsets, image copies, and archived
redo logs would be used in a recovery operation without actually performing the recovery.
RESTORE PREVIEW
The command restore preview will provide a list of the files that RMAN will use to perform
the requested operation; the preview will also indicate if a tape volume will be requested, for
example. No files are actually restored; only the recovery catalog is queried to determine which
files are needed. In the following example, we want to find out what RMAN will need if we need
to recover the USERS tablespace:
RMAN> restore tablespace users preview;
Starting restore at 04-SEP-07
using channel ORA_DISK_1
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
744 Full 239.34M DISK 00:01:45 04-SEP-07
BP Key: 747 Status: AVAILABLE Compressed: YES Tag:
TAG20070904T215119
Piece Name:
+RECOV/dw/backupset/2007_09_04/nnndf0_tag20070904t215119_0.
Pages:
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709