Database Backup and Recovery (MOSC)

MOSC Banner

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

edited Aug 1, 2014 1:27AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
Hi Team,

Please help how can I proceed further with the above error -

OS : Solaris 5.9

Database : 10.2.0.3 EE

Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Sep 11 16:14:04 2013
ALTER DATABASE OPEN
Wed Sep 11 16:14:04 2013
Errors in file /opt/oracle/admin/DBDEV01/bdump/dbdev01_dbw0_1193.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/oradata/ora04/DBDEV01/DBDEV01_DATA_T02a.dbf'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
ORA-1157 signalled during: ALTER DATABASE OPEN...

During Startup:
===============
SQL> startup
ORACLE instance started.

Total System Global Area 2130706432 bytes
Fixed Size                  2031448 bytes

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center