12c Database: Lost of data files and its impacts

Hello,

I have been reading in other blog citing that what if lost of a data file scenario.

Here are the questions.

1) If in case of system/user datafile lost of Pluggable database, what happens to CDB?

ANS: Nothing happens to CDB, it will still running, similar case in non-cdb database if a user data file is lost does it hamper your database running, No right, similar way it wont affect the other PDB’s nor the CDB except the users that are using that data file.

2) If you have 10 PDB’s of one CDB, if there is lost of any single datafile of PDB(pdb1)

ANS: Same as above.

3) If you lost a datafile in CDB would that be affect?

ANS: Yes, this will affect the whole as its the master (container) for all the DB’s so any DF or system datafile lost will hamper the PDB’s