SOLVED

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

Asked by OracleDba••14 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
ORA-01157: cannot identify/lock data file string – see DBWR trace file

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

ORA-01157

is raised when Database Writer (DBWR) is unable to find and lock a Datafile. This may be due to various reasons like ,

Datafile is deleted or corrupt.

Datafile is renamed or moved.

Mount point is incorrect

Issues with Read/write permission on Datafile
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
If datafile is renamed or moved then we need to get it in its original position.

If datafile is deleted or corrupt and do not contain important segments, that can be dropped offline.

If datafile is deleted or corrupt , we can recovered it by using a valid backup.

If Mount point is incorrect, simply recreate the mount point.

If it is due to permission then we need to grant the permission at OS level.

SQL> select NAME from v$datafile where file#=16;

NAME

--------------------------------------------------------------------------------

E:\ORACLE\APP\ORACLE\ORADATA\PRIM\USER1.DBF

SQL> alter database datafile 16 OFFLINE DROP;

Database altered.

SQL> alter database open;

Database altered.

Hope it Helps!
OracleDba•

Post Your Solution