OraFAQ Forum: Backup & Recovery » ORA-01157: cannot identify/lock data file 1

Home » RDBMS Server » Backup & Recovery » ORA-01157: cannot identify/lock data file 1 - see DBWR trace file (Oracle 9.2/Win NT)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file [message #358693]

Wed, 12 November 2008 03:19

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

Dear Sir,
My oracle Version Oracle9.2 and OS is NT.
When I try to connect my database then it gives the error ...

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

and i see the trace file it shoes..that message ..p

Dump file e:\ora9\admin\oracle\bdump\oracle_dbw0_3320.trc
Wed Nov 12 14:37:55 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Instance name: oracle

Redo thread mounted by this instance: 1

Oracle process number: 3

Windows thread id: 3320, image: ORACLE.EXE

*** SESSION ID:(2.1) 2008-11-12 14:37:55.000
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'E:\ORA9\ORADATA\ORACLE\SYSTEM01.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04000: logical block size mismatch (OS 8192)
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'E:\ORA9\ORADATA\ORACLE\UNDOTBS01.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04000: logical block size mismatch (OS 8192)
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'E:\ORA9\ORADATA\ORACLE\DRSYS01.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04000: logical block size mismatch (OS 8192)
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'E:\ORA9\ORADATA\ORACLE\EXAMPLE01.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04000: logical block size mismatch (OS 8192)
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

please give me suggestion ...

[Updated on: Wed, 12 November 2008 03:22]

Report message to a moderator

Re: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file [message #358695 is a reply to message #358693]

Wed, 12 November 2008 03:26

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-27046: file size is not a multiple of logical block size
 *Cause:  file size as indicated by stat is not correct, additional
          information indicates which function encountered the error
 *Action: verify that the file has not been overwritten or truncated

Regards
Michel

Report message to a moderator

Previous Topic:	restore time
Next Topic:	Error in RMAN Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 23:07:39 CDT 2024