Home » RDBMS Server » Backup & Recovery » ORA-01157: cannot identify/lock data file 1 - see DBWR trace file (Oracle 9.2/Win NT)
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file [message #358693] Wed, 12 November 2008 03:19 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: restore time
Next Topic: Error in RMAN Backup
Goto Forum:
  


Current Time: Thu Dec 08 20:28:53 CST 2016

Total time taken to generate the page: 0.05473 seconds