Oracle 11g RMAN恢复-场景1：所有的数据文件损坏，数据库CLOSE

--查看当前日志组 sys@TESTDB11>select sequence#, group#, status from v$log;    SEQUENCE#     GROUP# STATUS ---------- ---------- ----------------         22          1 INACTIVE         23          2 INACTIVE         24          3 CURRENT --日志切换5组 sys@TESTDB11>alter system switch logfile;   System altered.   sys@TESTDB11>select sequence#, group#, status from v$log;    SEQUENCE#     GROUP# STATUS ---------- ---------- ----------------         28          1 INACTIVE         29          2 CURRENT         27          3 INACTIVE --关库后,所有数据丢失 sys@TESTDB11>shutdown abort; ORACLE instance shut down.   sys@TESTDB11>! rm /oradata/ *.dbf   --用RMAN恢复 --先启动实例到mount状态 RMAN> startup mount;   Oracle instance started database mounted   Total System Global Area     855982080 bytes   Fixed Size                     2230792 bytes Variable Size                641730040 bytes Database Buffers             209715200 bytes Redo Buffers                   2306048 bytes --查看备份集 RMAN> list backup;     List of Backup Sets ===================     BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 62      Full    1.25G      DISK        00:02:39     14-AUG-13              BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T070001         Piece Name: /pooldisk02/backup03/22oh8mbh_1_1   List of Datafiles in backup set 62   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1       Full 2647806    14-AUG-13 /oradata/system01.dbf   2       Full 2647806    14-AUG-13 /oradata/sysaux01.dbf   3       Full 2647806    14-AUG-13 /oradata/undotbs01.dbf   4       Full 2647806    14-AUG-13 /oradata/users01.dbf   5       Full 2647806    14-AUG-13 /oradata/example01.dbf   6       Full 2647806    14-AUG-13 /oradata/newts01.dbf   7       Full 2647806    14-AUG-13 /oradata/fbtbs01.dbf   8       Full 2647806    14-AUG-13 /oradata/users02.dbf   BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 63      Full    9.67M      DISK        00:00:02     14-AUG-13              BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T070246         Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823417366_90pwh7q8_.bkp   SPFILE Included: Modification time: 14-AUG-13   SPFILE db_unique_name: TESTDB11   Control File Included: Ckp SCN: 2648076      Ckp time: 14-AUG-13   --还原 RMAN> restore database;   Starting restore at 14-AUG-13 configuration for DISK channel 2 is ignored allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=18 device type=DISK   channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /oradata/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /oradata/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /oradata/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /oradata/users01.dbf channel ORA_DISK_1: restoring datafile 00005 to /oradata/example01.dbf channel ORA_DISK_1: restoring datafile 00006 to /oradata/newts01.dbf channel ORA_DISK_1: restoring datafile 00007 to /oradata/fbtbs01.dbf channel ORA_DISK_1: restoring datafile 00008 to /oradata/users02.dbf channel ORA_DISK_1: reading from backup piece /pooldisk02/backup03/22oh8mbh_1_1 channel ORA_DISK_1: piece handle=/pooldisk02/backup03/22oh8mbh_1_1 tag=TAG20130814T070001 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:06 Finished restore at 14-AUG-13 --实地检查 [oracle@S1011:/oradata]$ ls example01.dbf  fbtbs01.dbf    newts01.dbf    sysaux01.dbf   system01.dbf   undotbs01.dbf  users01.dbf    users02.dbf --恢复 RMAN> recover database;   Starting recover at 14-AUG-13 using channel ORA_DISK_1   starting media recovery   archived log for thread 1 with sequence 24 is already on disk as file /archive1/1_24_823328120.dbf archived log for thread 1 with sequence 25 is already on disk as file /archive1/1_25_823328120.dbf archived log for thread 1 with sequence 26 is already on disk as file /archive1/1_26_823328120.dbf archived log for thread 1 with sequence 27 is already on disk as file /archive1/1_27_823328120.dbf archived log for thread 1 with sequence 28 is already on disk as file /archive1/1_28_823328120.dbf archived log file name=/archive1/1_24_823328120.dbf thread=1 sequence=24 archived log file name=/archive1/1_25_823328120.dbf thread=1 sequence=25 archived log file name=/archive1/1_26_823328120.dbf thread=1 sequence=26 media recovery complete, elapsed time: 00:00:05 Finished recover at 14-AUG-13   --开库 RMAN> open database;   database opened --确认数据 sys@TESTDB11>select * from scott.dept;       DEPTNO DNAME          LOC ---------- -------------- -------------         10 ACCOUNTING     NEW YORK         20 RESEARCH       DALLAS         30 SALES          CHICAGO         40 OPERATIONS     BOSTON

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1154714/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1154714/