模拟控制文件丢失进行恢复。

模拟三个控制文件丢失

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             121636456 bytes
Database Buffers          155189248 bytes
Redo Buffers                7168000 bytes
ORA-00214: control file '/u01/oracle/oradata/orcl/control01.ctl' version 687
inconsistent with file '/u01/oracle/oradata/orcl/control02.ctl' version 673


SQL> shutdown abort;
ORACLE instance shut down.




ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             121636456 bytes
Database Buffers          155189248 bytes
Redo Buffers                7168000 bytes


SQL> alter system set control_files='/u01/oracle/oradata/orcl/control03.ctl'scope=spfile;


System altered.


SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u01/oracle/oradata/orcl/control01.ctl' version 687
inconsistent with file '/u01/oracle/oradata/orcl/control02.ctl' version 673




SQL> alter system set control_files='/u01/oracle/oradata/orcl/control01.ctl'scope=spfile
  2  ;


System altered.


SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u01/oracle/oradata/orcl/control01.ctl' version 687
inconsistent with file '/u01/oracle/oradata/orcl/control02.ctl' version 673




SQL> alter system set control_files='/u01/oracle/oradata/orcl/control02.ctl'scope=spfile
  2  ;


System altered.


SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u01/oracle/oradata/orcl/control01.ctl' version 687
inconsistent with file '/u01/oracle/oradata/orcl/control02.ctl' version 673




SQL> select status from v$instance;


STATUS
------------
STARTED


SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             121636456 bytes
Database Buffers          155189248 bytes
Redo Buffers                7168000 bytes
SQL> alter system set control_files='/u01/oracle/oradata/orcl/control03.ctl' scope=spfile;


System altered.


SQL> alter database mount;


Database altered.


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/oracle/oradata/orcl/system01.dbf'
ORA-01207: file is more recent than control file - old control file




SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             121636456 bytes
Database Buffers          155189248 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> alter database open;


Database altered.
____________________________________________________________________________________________




控制文件恢复后
今天查看表空间发现个MISSING00005数据文件   --->原因：编辑控制文件的时候被遗漏掉的数据文件(example表空间)
SQL> select file_id,tablespace_name,file_name,online_status from dba_data_files;


   FILE_ID TABLESPACE_NAME      FILE_NAME                                ONLINE_
---------- -------------------- ---------------------------------------- -------
         6 TEST                 /u01/oracle/oradata/orcl/test01.dbf      ONLINE
         4 USERS                /u01/oracle/oradata/orcl/users01.dbf     ONLINE
         2 UNDOTBS1             /u01/oracle/oradata/orcl/undotbs01.dbf   ONLINE
         3 SYSAUX               /u01/oracle/oradata/orcl/sysaux01.dbf    ONLINE
         1 SYSTEM               /u01/oracle/oradata/orcl/system01.dbf    SYSTEM
         5 EXAMPLE              /u01/oracle/db_1/dbs/MISSING00005        RECOVER


6 rows selected.






SQL> alter tablespace example rename datafile '/u01/oracle/db_1/dbs/MISSING00005' to '/u01/oracle/oradata/orcl/example01.dbf';


Tablespace altered.


SQL> select file_id,tablespace_name,file_name,online_status from dba_data_files;


   FILE_ID TABLESPACE_NAME      FILE_NAME                                ONLINE_
---------- -------------------- ---------------------------------------- -------
         6 TEST                 /u01/oracle/oradata/orcl/test01.dbf      ONLINE
         4 USERS                /u01/oracle/oradata/orcl/users01.dbf     ONLINE
         2 UNDOTBS1             /u01/oracle/oradata/orcl/undotbs01.dbf   ONLINE
         3 SYSAUX               /u01/oracle/oradata/orcl/sysaux01.dbf    ONLINE
         1 SYSTEM               /u01/oracle/oradata/orcl/system01.dbf    SYSTEM
         5 EXAMPLE              /u01/oracle/oradata/orcl/example01.dbf   RECOVER


6 rows selected.


SQL> select name from v$datafile;


NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/orcl/system01.dbf
/u01/oracle/oradata/orcl/undotbs01.dbf
/u01/oracle/oradata/orcl/sysaux01.dbf
/u01/oracle/oradata/orcl/users01.dbf
/u01/oracle/oradata/orcl/example01.dbf
/u01/oracle/oradata/orcl/test01.dbf


6 rows selected.





中间不知道什么原因试了好多次才成功，这个还有待研究。

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

转载于:http://blog.itpub.net/29618264/viewspace-2089051/