查看rman用哪个备份集恢复 restore preview database

RMAN> restore preview database;


Starting restore at 09-AUG-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK




List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
46      Incr 0  116.05M    DISK        00:00:39     08-AUG-12
        BP Key: 46   Status: AVAILABLE  Compressed: YES  Tag: TAG20120808T235738
        Piece Name: /u01/oracle/rman_backupscripts/arch_u1eni5s7i_s46_p1_t790819058
  List of Datafiles in backup set 46
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 681951     08-AUG-12 /u01/oradata/augus/system01.dbf
  2    0  Incr 681951     08-AUG-12 /u01/oradata/augus/undotbs01.dbf
  3    0  Incr 681951     08-AUG-12 /u01/oradata/augus/sysaux01.dbf
  4    0  Incr 681951     08-AUG-12 /u01/oradata/augus/users01.dbf
  5    0  Incr 681951     08-AUG-12 /u01/oradata/augus/example01.dbf
using channel ORA_DISK_1




List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
25      1    3       A 08-AUG-12 /u01/flash_recovery_area/AUGUS/archivelog/2012_08_08/o1_mf_1_3_82534zss_.arc
Media recovery start SCN is 681951
Recovery must be done beyond SCN 681951 to clear data files fuzziness
Finished restore at 09-AUG-12