Database Administration (MOSC)

MOSC Banner

ORA-01157 ORA-0110 PDB is missing datafile on startup

edited Apr 1, 2017 5:00AM in Database Administration (MOSC) 1 commentAnswered

I managed again to screw a database. Loss of the data is not an issue. Problem is, that the PDB is in an inconsistent state. Trying to issue the command:

ALTER PLUGGABLE DATABASE pdborcl open;

gives

ORA-01157: Datendatei 22 kann nicht identifiziert/gesperrt werden - siehe DBWR-Trace-DateiORA-0110: Datendatei 22'C:\APP\MELOCAL\ORADATA\ORCL\PDBORCL\COMPANY_DATA.DBF'SQL>

It happened that I inadvertently deleted the datafile. I also cannot recover it.

As said, it is not so important to recover the data. I can receate it from a dump. More important is, to get the PDB back to a functioning state. That is, either delete the dependency from that datafile

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