本帖最后由 hope1234567hope 于 2015-8-12 17:16 编辑
看rman中restore database preview功能
我先restore controlfile 然后
RMAN>restore database preview;
Starting restore at 12-AUG-15
using channel ORA_DISK_1
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full6.76GDISK00:04:14 24-APR-14
BP Key: 7 Status: AVAILABLECompressed: NOTag: TAG20140424T131155
Piece Name: /usr/test/08p6hksr_1_1
List of Datafiles in backup set 7
File LV Type Ckp SCNCkp TimeName
---- -- ---- ---------- --------- ----
1 Full 59122516412-AUG-15 /u01/app/oracle/oradata/t/system01.dbf
2 Full 59122516412-AUG-15 /u01/app/oracle/oradata/t/sysaux01.dbf
3 Full 59122516412-AUG-15 /u01/app/oracle/oradata/t/undotbs01.dbf
4 Full 59122516412-AUG-15 /u01/app/oracle/oradata/t/users01.dbf
5 Full 59122516412-AUG-15 /u01/app/oracle/oradata/t/users02.dbf
archived logs generated after SCN 591224897 not found in repository
Media recovery start SCN is 591224897
Recovery must be done beyond SCN 591225164 to clear datafile fuzziness
Finished restore at 12-AUG-15