Oracle 11g 数据库恢复-场景5：部分文件损坏恢复,开库状态,低可用恢复方式

sys@TESTDB11>select status from v$instance;   STATUS ------------ OPEN   --删除系统表空间的文件 sys@TESTDB11>select name from v$datafile;   NAME -------------------------------------------------- /u01/app/oracle/oradata/TestDB11/system01.dbf /u01/app/oracle/oradata/TestDB11/sysaux01.dbf /u01/app/oracle/oradata/TestDB11/undotbs01.dbf /u01/app/oracle/oradata/TestDB11/users01.dbf /u01/app/oracle/oradata/TestDB11/example01.dbf /u01/app/oracle/oradata/TestDB11/rotbs01.dbf   6 rows selected.   sys@TESTDB11>!rm /u01/app/oracle/oradata/TestDB11/system01.dbf   --此时用户都登录不了(当然已经登录的用户还是可以登录的)-----做个实验 [oracle@S1011:/export/home/oracle]$ sqlplus hr/hr   SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 10 11:49:12 2013   Copyright (c) 1982, 2011, Oracle.  All rights reserved.   ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/u01/app/oracle/oradata/TestDB11/system01.dbf' ORA-27041: unable to open file Solaris-AMD64 Error: 2: No such file or directory Additional information: 3     Enter user-name:   --此时使用前面的方法，使系统表空间数据文件脱机已经不可能了 sys@TESTDB11>alter database datafile 1 offline; alter database datafile 1 offline * ERROR at line 1: ORA-01541: system tablespace cannot be brought offline; shut down if necessary   --关库，重启动到MOUNT状态 sys@TESTDB11>startup mount force; ORACLE instance started.   Total System Global Area  855982080 bytes Fixed Size                  2230792 bytes Variable Size             641730040 bytes Database Buffers          209715200 bytes Redo Buffers                2306048 bytes Database mounted.   --只还原一个数据文件 sys@TESTDB11>!cp /backup/inconsistent_backup/system01.dbf /u01/app/oracle/oradata/TestDB11   --查看一致性状态 sys@TESTDB11>select name, checkpoint_change# from v$datafile_header;   NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/TestDB11/system01.dbf                 2654775 /u01/app/oracle/oradata/TestDB11/sysaux01.dbf                 2727508 /u01/app/oracle/oradata/TestDB11/undotbs01.dbf                2727508 /u01/app/oracle/oradata/TestDB11/users01.dbf                  2728854 /u01/app/oracle/oradata/TestDB11/example01.dbf                2727508 /u01/app/oracle/oradata/TestDB11/rotbs01.dbf                  2727508   6 rows selected.   --进行恢复 sys@TESTDB11>recover database; ORA-00279: change 2654775 generated at 08/09/2013 21:25:44 needed for thread 1 ORA-00289: suggestion : /archive2/1_98_813665348.dbf ORA-00280: change 2654775 for thread 1 is in sequence #98     Specify log: {<RET>=suggested | filename | AUTO | CANCEL} auto ORA-00279: change 2660981 generated at 08/09/2013 22:19:48 needed for thread 1 ORA-00289: suggestion : /archive2/1_99_813665348.dbf ORA-00280: change 2660981 for thread 1 is in sequence #99     ORA-00279: change 2667783 generated at 08/10/2013 00:00:55 needed for thread 1 ORA-00289: suggestion : /archive2/1_100_813665348.dbf ORA-00280: change 2667783 for thread 1 is in sequence #100     ORA-00279: change 2679804 generated at 08/10/2013 03:00:28 needed for thread 1 ORA-00289: suggestion : /archive2/1_101_813665348.dbf ORA-00280: change 2679804 for thread 1 is in sequence #101     ORA-00279: change 2699110 generated at 08/10/2013 08:29:58 needed for thread 1 ORA-00289: suggestion : /archive2/1_102_813665348.dbf ORA-00280: change 2699110 for thread 1 is in sequence #102     ORA-00279: change 2725650 generated at 08/10/2013 10:27:18 needed for thread 1 ORA-00289: suggestion : /archive2/1_103_813665348.dbf ORA-00280: change 2725650 for thread 1 is in sequence #103     ORA-00279: change 2726122 generated at 08/10/2013 10:29:03 needed for thread 1 ORA-00289: suggestion : /archive2/1_104_813665348.dbf ORA-00280: change 2726122 for thread 1 is in sequence #104     Log applied. Media recovery complete.   --查看一致性状态 sys@TESTDB11>select name, checkpoint_change# from v$datafile_header;   NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/TestDB11/system01.dbf                 2749172 /u01/app/oracle/oradata/TestDB11/sysaux01.dbf                 2749172 /u01/app/oracle/oradata/TestDB11/undotbs01.dbf                2749172 /u01/app/oracle/oradata/TestDB11/users01.dbf                  2749172 /u01/app/oracle/oradata/TestDB11/example01.dbf                2749172 /u01/app/oracle/oradata/TestDB11/rotbs01.dbf                  2749172   6 rows selected.   --开库 sys@TESTDB11>alter database open;   Database altered.

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

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