Recovery process record for Oracle control file corruption

Have done some testing, in the startup or shutdown of the database to delete the control file, because this database is only my own test database, then did not care to recover.

Today, when I wanted to start this database, I ran into problems:

[Oracle@bjtest ~]$ Sqlplus "/As SYSDBA"

Sql*plus:release9.2.0.4.0-production on Wednesday June 3 01:47:42 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

You are connected to an idle routine.

Sql> Startup

The Oracle routine has started.

Total System Global area 9432971568 bytes

Fixed Size 756016 bytes

Variable Size 838860800 bytes

Database buffers 8589934592 bytes

Redo buffers 3420160 bytes

ORA-00214:???? '/data/oradata/bjtest/control01.ctl '?? 6178246???

'/data/oradata/bjtest/control02.ctl '?? 6178204???

Seeing this mistake, I immediately thought of the test that I had done the previous two days. However, the specific test details were not clear, just remember to delete the control file.

This error is clearly two control files inconsistent, then only need to overwrite the wrong control file.

Sql> Host

[Oracle@bjtest ~]$ cd/data/oradata/bjtest/

[Oracle@bjtest bjtest]$ CP Control01.ctl Control02.ctl

[Oracle@bjtest bjtest]$ exit

Exit

Sql> ALTER DATABASE Mount;

ALTER DATABASE Mount

*

Error is on line 1th:

ORA-00214:???? '/data/oradata/bjtest/control01.ctl '?? 6178246???

'/data/oradata/bjtest/control03.ctl '?? 6178204???

After covering the control file Control02.ctl, found that control file 1 and control file 3 is inconsistent, the problem is the control file is Control01.ctl. Just by the impression that Control02.ctl has a problem, this time can no longer rely on the impression, in order to avoid the loss of real control files, the control file for the first backup:

Sql> exit

From Oracle9i Enterprise Edition release9.2.0.4.0-64bit Production

With the partitioning, OLAP and Oracle Data Mining options

Disconnect in Jserver release 9.2.0.4.0-production

[Oracle@bjtest ~]$ cd/data/oradata/bjtest/

[Oracle@bjtest bjtest]$ CP Control03.ctl Control03.bak

[Oracle@bjtest bjtest]$ CP Control01.ctl Control01.bak

[Oracle@bjtest bjtest]$ CP Control03.ctl Control01.ctl

Try loading the control file again:

[Oracle@bjtest ~]$ Sqlplus "/As SYSDBA"

Sql*plus:release9.2.0.4.0-production on Wednesday June 3 01:49:45 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connect to:

Oracle9i Enterprise Edition release9.2.0.4.0-64bit Production

With the partitioning, OLAP and Oracle Data Mining options

Jserver Release 9.2.0.4.0-production

Sql> ALTER DATABASE Mount;

ALTER DATABASE Mount

*

Error is on line 1th:

ORA-00214:???? '/data/oradata/bjtest/control02.ctl '?? 6178246???

'/data/oradata/bjtest/control01.ctl '?? 6178204???

Still error, think also, because the control file Control02.ctl has been controlled file Control01.ctl covered, so just copy is not thorough.

Sql> exit

From Oracle9i Enterprise Edition release9.2.0.4.0-64bit Production

With the partitioning, OLAP and Oracle Data Mining options

Disconnect in Jserver release 9.2.0.4.0-production

[Oracle@bjtest ~]$ cd/data/oradata/bjtest/

[Oracle@bjtest bjtest]$ CP Control01.ctl Control02.ctl

[Oracle@bjtest bjtest]$ Sqlplus "/As SYSDBA"

Sql*plus:release9.2.0.4.0-production on Wednesday June 3 01:50:32 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45541.htm