Tag: V$datafile

Offlining a datafile

When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile SQL> alter database datafile 5 offline; Database altered. -- Shows datafile is in recover state SQL> select status from v$datafile where file# = 5; STATUS ------- RECOVER -- datafile can't be made online SQL> alter … Continue reading Offlining a datafile →

Scenario when the controlfile is lost and there was a datafile added

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 →