Write an Oracle boot error problem resolution

Since the table space was previously deleted directly, after restarting Oracle error ORA-01157, the following records the workaround.

ORA-01157:Unrecognized /Locked data file string-see DBWR trace file
Reason: The background process could not find one of the data files or could not lock it because the file was already in use. The database will prohibit access to this file, but other files will not be affected. However, opening the first instance of a database requires access to all online data files. the accompanying error from the operating system describes why the file could not be recognized.
Action: AddThe operating system make file is provided to the database. then open the database or execute ALTER SYSTEM CHECK datafiles.

Reference: http ://docs.oracle.com/cd/b28359_01/server.111/b28278/e900.htm#ora-01157

ORA-01157 This error is raised when the database writer (DBWR) cannot locate and lock the data file. This may be due to a variety of reasons, such as
-Data files are deleted or corrupted
-Data files are renamed or moved
-mount point is incorrect
-read/write permission issues for data files

To resolve ORA-01157, we can use one of the following steps:
-If the data file is deleted or corrupted instead of temp or undo tablespace, then we need to restore it using a valid backup.
-If the data file is deleted or corrupted and is not a temp or undo tablespace, but the table space does not contain important segments, you can delete them offline
-If the data file is renamed or moved, then we need to save it in the original location
-If the mount point is incorrect, simply re-create the mount point
-if it is caused by permissions, then

When I restore a cold backup, We need to grant me permission to face ORA-01157 in my on-premises environment at the operating system level . It is not important to add a tablespace for testing purposes. So I simply use the "OFFLINE drop" clause to delete the data file and open the database.

C:\>sqlplus Sys/sys asSysdbasql*plus:release11.2.0.3.0Production on Tue APR -  +: -: -  -Copyright (c)1982, ., Oracle. All rights reserved. Connected to an idle instance. SQL>Startuporacle instance started. Total System Global Area778387456bytesfixed Size1384856bytesvariable Size520097384Bytesdatabase Buffers251658240Bytesredo Buffers5246976bytesdatabase mounted. ORA-01157: Cannot identify/LockData file One–see DBWR Trace Fileora-01110: Data File -:'E:\oracle\app\nimish.garg\oradata\orcl\test_ts.dbf'SQL>SelectNAME fromV$datafilewherefile#= -; NAME--------------------------------------------------------------------------------E:\ORACLE\APP\NIMISH. Garg\oradata\orcl\test_ts.dbfsql> ALTER DATABASE DataFile -OFFLINE Drop;database altered. SQL>ALTER DATABASE open;database altered.

I hope this solution helps to solve your problem.

Reference: http://nimishgarg.blogspot.com/2014/01/ora-01157-cannot-identifylock-data-file.html

Write an Oracle boot error problem resolution