Oracle ORA-01503 和 (ORA-01160 ORA-01110) 或 (ORA-01565 ORA-27406)

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]

ORA-01503  oerr ora 1503
01503, 00000, "CREATE CONTROLFILE failed"
// *Cause:  An error occurred during CREATE CONTROLFILE
// *Action: See accompanying errors.


ORA-01160  oerr ora 1160
01160, 00000, "file is not a %s"
// *Cause: The named file in the DATAFILE or LOGFILE section of the CREATE
//        CONTROLFILE command does not appear to be as stated.
// *Action:  Please double check the mentioned file.


ORA-01565 oerr ora 1565
01565, 00000, "error in identifying file '%s'"
// *Cause:  An error occurred while trying to identify a file.
// *Action:  Check the error stack for detailed information.

适用于：

Oracle Database – Enterprise Edition – 版本 8.1.7.4 到 11.2.0.2 [Release 8.1.7 到 11.2]
本文信息适用于任何平台。
于05-Jul-2012检查相关性

症状

你尝试为现有的数据库重建控制文件，在创建时收到以下错误：

情况 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘/u02/oradata/RM805/system01.dbf’
ORA-27046: file size is not a multiple of logical block size

– 或 –

情况 2:

ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : ‘/u02/oradata/RM805/system01.dbf’

– 或 –

情况 3:

ORA-00058: DB_BLOCK_SIZE must be <the correct block size> to mount this database (not <the incorrect block size>)

原因

两者情况都是由于”init.ora”文件中db_block_size参数的错误设置。

情况 1: The specified db_block_size in the “init.ora” is too large.
情况 2: The specified db_block_size in the “init.ora” is too small.
情况 3: Self explanatory

数据库块大小必须在init.ora中正确指定来成功重建控制文件。

解决方案
相应地调整DB_BLOCK_SIZE参数：

情况1 (ORA-01503, ORA-01565, and ORA-27046)，在尝试重建控制文件之前，减少DB_BLOCK_SIZE指定的值。

情况 2 (ORA-01503, ORA-01160, and ORA-01110)，在尝试重建控制文件之前，增加DB_BLOCK_SIZE指定的值。

情况 3 在尝试重建控制文件之前，设置在错误信息中指示的DB_BLOCK_SIZE 。

参考

NOTE:265265.1 – ORA-01503 ORA-01160 ORA-01110 while creating controlfile