ORA-01565 and ORA-27046 Errors

While tying to START a database sometimes if we are not lucky then we can see the following errors ;

ORA-01565 and ORA-27046

For example ;

ORA-01565: error in identifying file ‘/sapdata1/data01.dbf’

ORA-27046: file size is not a multiple of logical block size.

Usually you can see these kind of errors after RESTORE DB operation or COPIED over the NETWORK

Possible reason is , inconsistency between the SOURCE File and the TARGET File…

Unfortunately if you get this error you should Copy or Restore the DB files again but before this you can use the RESIZE option for the file which is giving the error message

If corrupted blocks are located end of the file then RESIZE option should be solve the problem…

Leave a Reply

+ 3 = seven