Database Administration (MOSC)

MOSC Banner

ORA-01157 how to get out of this situation - deleted DBF file

edited Oct 26, 2016 12:55PM in Database Administration (MOSC) 1 comment

*

FEHLER in Zeile 1:

ORA-01157: Datendatei 12 kann nicht identifiziert/gesperrt werden - siehe

DBWR-Trace-Datei

ORA-01110: Datendatei 12:

'C:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\E_DATA.DBF'

SQL>

Just before this I inadvertently deleted the datafile E_DATA.DBF

Somehow the database still is looking for this file. How can I repair this situation?

SQL> select name from v$datafile;NAME---------------------------------------------------------------------------C:\APP\CHRISLOCAL\ORADATA\ORCL\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBSEED\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBSEED\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\UNDOTBS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SAMPLE_SCHEMA_USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\EXAMPLE01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\E_DATA.DBFNAME-------------------------------------------------------------------C:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\PDBORCL01_USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\E_DATA.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL2\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL2\SYSAUX01.DBF17 Zeilen ausgewõhlt.SQL>

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