Loss of datafiles associated with System Tablespace

Scenario: Database is in archive log mode and system datafile is lost while database is running. Without any dataloss, system datafile can be restored from previous backup and recovery can be performed.

Is Down time Required : YES

1. Shutdown the database and take backup of control files, redo logfiles and data files

2. Insert some records into a test table

3. Remove the system datafiles and again insert some records into the test table

4. Shut abort the database

5. Startup mount and restore the system datafile from backup and recover the database

SQL> startup mount;

SQL> recover database;

SQL> alter database open;

That's it!!!

Regards

Charan