Re: error in identifying control file

On Fri, 27 Dec 2002 05:08:06 +0530, Shravana Kumar <kumar.shravana_at_blr.spcnl.co.in> wrote:

>ORA-27046: file size is not a multiple of logical block size
This is your problem.
Evidently control01.ctl is corrupt, but of course you should verify that using the error message lookup at http://tahiti.oracle.com (you are kindly requested to look up errors *before* posting) Other than looking up the error myself, the suggestion would be to check whether all the controlfiles are of the same size and don't satisfy the multiple of a block requirement. If control01 is the only one affected, simply copy one of the others over control01

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Dec 27 2002 - 09:13:51 CST