Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of the controlfile was taken so the controlfile does not know about the new datafile. 1) Start database in nomount state SQL> connect /as sysdba SQL> startup nomount ORACLE instance started. Total System Global Area 209715200 … Continue reading Scenario when the controlfile is lost and there was a datafile added →