ORA-27046错误

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8203880/viewspace-480107/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8203880/viewspace-480107/