ORA-27046: file size is not a multiple of logical block size
查了一下metalink ：
Problem Description:
====================
You are attempting to recreate the controlfiles for an existing database.
During creation you may see the following errors:
Case 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
- or -
Case 2:
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'
Solution Description:
=====================
Adjust the DB_BLOCK_SIZE parameter accordingly:
- If you received the errors in Case 1 (ORA-01503, ORA-01565, and ORA-27046),
you should decrease the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
- If you received the errors in Case 2 (ORA-01503, ORA-01160, and ORA-01110),
you should increase the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
Explanation:
============
Both cases occur due to an incorrect setting of the db_block_size parameter in
the "init.ora" file.
Case 1: The specified db_block_size in the "init.ora" is too large.
Case 2: The specified db_block_size in the "init.ora" is too small.
The database blocksize must be specified correctly in the init.ora in order
to successfully recreate the controlfile.
Search Words:
=============
ORA-1503 ORA-1565 ORA-1503 ORA-1160 ORA-1110
Additional References:
======================Note 265265.1 - ORA-01503 ORA-01160 ORA-01110 while creating controlfile
====================
You are attempting to recreate the controlfiles for an existing database.
During creation you may see the following errors:
Case 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
- or -
Case 2:
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'
Solution Description:
=====================
Adjust the DB_BLOCK_SIZE parameter accordingly:
- If you received the errors in Case 1 (ORA-01503, ORA-01565, and ORA-27046),
you should decrease the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
- If you received the errors in Case 2 (ORA-01503, ORA-01160, and ORA-01110),
you should increase the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
Explanation:
============
Both cases occur due to an incorrect setting of the db_block_size parameter in
the "init.ora" file.
Case 1: The specified db_block_size in the "init.ora" is too large.
Case 2: The specified db_block_size in the "init.ora" is too small.
The database blocksize must be specified correctly in the init.ora in order
to successfully recreate the controlfile.
Search Words:
=============
ORA-1503 ORA-1565 ORA-1503 ORA-1160 ORA-1110
Additional References:
======================Note 265265.1 - ORA-01503 ORA-01160 ORA-01110 while creating controlfile
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8203880/viewspace-480107/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request (Release 11 and up)
- Drop user fails with ora-600 [qmxiUnpPacked2]
- Solaris 9/10 SCSA(310-015,310-202)中文教材：NIS配置实例
- Sun Solaris 培训教材 (二) . PROM状态命令和参数
- 9istatspack使用指南
- Oracle IO问题解析
- Statspack分析报告详解
- Oracle 11i EBS DBA Apps DBA
- [转]dbms_redefinition的使用
- ebs dba 面试题
