ORA-00205: error in identifying control file, check alert log for more info
(2011-01-14 17:59:38)
标签:
ora-oracle笔记数据库资料杂谈 |
分类: ora-xxxxx |
当控制文件不存在时候的报错:
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@localhost dbs]$ cd /oracle/oradata/peng
[oracle@localhost peng]$ mkdir control
[oracle@localhost peng]$ mv control0* control
[oracle@localhost peng]$
ORACLE instance started.
Total System Global Area
Fixed
Size
Variable
Size
Database
Buffers
Redo
Buffers
ORA-00205: error in identifying control file,
check alert log for more info
[oracle@localhost bdump]$ pwd
/oracle/admin/peng/bdump
[oracle@localhost bdump]$
[oracle@localhost bdump]$ tail -f alert_peng.log
starting up 1 shared server(s) ...
Sat Jan 15 01:48:52 2011
ALTER DATABASE
Sat Jan 15 01:48:52 2011
ORA-00202: control file: '/oracle/oradata/peng/control01.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sat Jan 15 01:48:58
2011
ORA-205 signalled during: ALTER
DATABASE
SQL>
SQL> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
将控制文件移回
[oracle@localhost peng]$ cd control/
[oracle@localhost control]$ ls
control01.ctl
[oracle@localhost control]$ mv * ..
重新启动
ORACLE instance started.
Total System Global Area
Fixed
Size
Variable
Size
Database
Buffers
Redo
Buffers
Database mounted.
Database opened.