![d4cd2b244d41b1e87498c5758252df9b.png](https://i-blog.csdnimg.cn/blog_migrate/f452bde9aa6e8387dfc210f921a5bc95.jpeg)
[oracle@dbserver sztech1]$ pwd
/oracle/app/oracle/oradata/sztech1
[oracle@dbserver sztech1]$ ls
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
redo01.log redo03.log system01.dbf undotbs01.dbf
执行破坏动作,将一个控制文件删掉。
[oracle@dbserver sztech1]$ rm -f control01.ctl
重启后就会出错,如:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 234884184 bytes
Database Buffers 71303168 bytes
Redo Buffers 6336512 bytes
SQL> 1* alter database archivelog
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
解决办法:
将另一个控制文件复制到丢失的控制文件目录下
[oracle@dbserver sztech1]$ pwd
/oracle/app/oracle/flash_recovery_area/sztech1
[oracle@dbserver sztech1]$ cp control02.ctl
/oracle/app/oracle/oradata/sztech1/control01.ctl
[oracle@dbserver sztech1]$ cd /oracle/app/oracle/oradata/sztech1
[oracle@dbserver sztech1]$ ls
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
这时候就能执行成功了
SQL> r
1* alter database mount
Database altered.
![45fa8261423a07da332ca59225226128.png](https://i-blog.csdnimg.cn/blog_migrate/665d48db64f9146354af29257011c2ab.jpeg)