ORA-00202: control file: ‘/u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf’
对于如题所示的问题,虽然,前面写的NOMOUNT阶段手动创建控制文件,虽然也能解决如题所示的问题,但是还有更简单的做法:
日志文件中的问题详情:
1 2 3 4 5 6 7 8 9 |
Sat Apr 23 10:40:11 2016 ALTER DATABASE MOUNT Sat Apr 23 10:40:11 2016 ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-205 signalled during: ALTER DATABASE MOUNT... |
将本地已有的OMF管理的控制文件,复制到dbs/cntrlcallah.dbf:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
[oracle@rhel7 datafile]$ cd .. [oracle@rhel7 CALLAH]$ ls controlfile datafile [oracle@rhel7 CALLAH]$ cd controlfile/ [oracle@rhel7 controlfile]$ ls o1_mf_ckonsh94_.ctl o1_mf_ckoo9xsz_.ctl [oracle@rhel7 controlfile]$ [oracle@rhel7 controlfile]$ ll -ltr total 34848 -rw-r----- 1 oracle oinstall 17842176 Apr 23 09:43 o1_mf_ckonsh94_.ctl -rw-r----- 1 oracle oinstall 17842176 Apr 23 10:36 o1_mf_ckoo9xsz_.ctl [oracle@rhel7 controlfile]$ cp o1_mf_cko o1_mf_ckonsh94_.ctl o1_mf_ckoo9xsz_.ctl [oracle@rhel7 controlfile]$ cp o1_mf_ckoo9xsz_.ctl /u01/app/oracle/product/12/db_1/dbs/cntrlcallah.dbf [oracle@rhel7 controlfile]$ |
这样,再拉起数据库,就不会遇到上面的问题了:
1 2 3 4 5 6 7 8 9 10 |
SQL> alter database mount; Database altered. SQL> SQL> alter database open; Database altered. SQL> |
——————————————————
Done。