诗檀软件专业数据库修复团队
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