如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
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
Comment