Recover Database 10g without Control Files and Redo Log Files with minimum Loss.

How to Recover Database without Control Files and Redo Log File and Even RMAN or Other Backup from Data Files Only with minimum Loss.

K5 is Database name or SID

1.       Database is crashed and it is in shutdown mode. and all control files and redo log file are either corrupt or loss or deleted , And now see the screen shot.

1^st Screen (All files are available in K5 Directory

Let’s Play with database

I deleted all control files and log file, I have only DBF files in K5 Directory

We face this error and we can not even  mount database, so it time to check the parameter and start recovering database from only data files survived yet.

Now create control file and redo file with reference to DBF files.

Now this is time for Check mate.

This is way you can recover database using data files with minimum chance of database structure and data loss in no mount  state.