How to recover a control file that is removed using rm ?

Instead of m_ filename if we do a rm filename by mistake and want to recover that control file, how do we do it? can it be done using a checkpoint, if yes how and is there another way?

Showing Answers 1 - 2 of 2 Answers

Tanz

Mar 21st, 2012

if data files are present simply do m_touch control file name

Siva Parvathi

Jun 5th, 2017

If only control file got deleted, simply it can be created using m_touch
As data remains in partitions, it automatically can point to corresponding partitions