ORA-01157 ORA-0110 PDB is missing datafile on startup
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