You Lost all datafiles of the database !! But all your online redo log files are safe !! Now what !?

You must first put your database in mount mode to perform a database-wide restore and recovery.This is because the system tablespace datafile(s) must be offline when beign restored and recovered.Oracle won’t allow you to operate your database in open mode with the system datafile offline.

1.       Perform Database-Level complete recovery with current control file:

RMAN>connect target /

RMAN>Startup Mount;

RMAN>Restore database;

RMAN>Recover database;

RMAN>Alter database open;

2.       Perform Database Level Complete recovery with backed by control file:

RMAN> Connect target /

RMAN> Startup mount

RMAN> Restore control file from autpbackup

RMAN> Alter database mount

RMAN> Restore database

RMAN> Recover database

RMAN> Alter database open resetlogs;

You are required to open your database with the open resetlogs command anytime you use a backup control file during a recovery operation.