RMAN> list backupset summary;
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
25 B A A DISK 25-JUL-11 1 1 NO TAG20110725T104634
28 B 0 A DISK 25-JUL-11 1 1 NO TAG20110725T104645
29 B A A DISK 25-JUL-11 1 1 NO TAG20110725T104711
30 B F A DISK 25-JUL-11 1 1 NO TAG20110725T104713
31 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105333
32 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105350
33 B 1 A DISK 25-JUL-11 1 1 NO TAG20110725T105353
34 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105408
35 B F A DISK 25-JUL-11 1 1 NO TAG20110725T105411
36 B A A DISK 25-JUL-11 1 1 NO TAG20110725T111403
37 B 1 A DISK 25-JUL-11 1 1 NO TAG20110725T111405
38 B A A DISK 25-JUL-11 1 1 NO TAG20110725T111421
39 B F A DISK 25-JUL-11 1 1 NO TAG20110725T111423
2. 还原数据库:
SQL>shutdown immediate;
SQL>startup mount;
RMAN>restore database from tag TAG20110725T104645;
RMAN> recover database from tag TAG20110725T104645;
RMAN> alter database open;
b. 不完全恢复:
SQL>shutdown immediate;
SQL>startup mount;
RMAN>restore database from tag TAG20110725T104645;
RMAN>recover database until time "to_date('2011-08-04 15:37:25','yyyy/mm/dd hh24:mi:ss')";