Recovering from removed/deleted datafile

In this post will discuss on how to recover from the scenario where someone somehow deleted any datafile. But before proceeding make sure you have a backup of the database, and the archive logs from the backup till date. So to recover from that scenario we must create that scenario.

For creating scenarios follow this:

• Make sure you’ve a Permanent Tablespace which is not that important (In Test Env). If you don’t want to use any existing tablespace then create a new tablespace to take it to this scenario.

SYS@DBACODE > CREATE TABLESPACE USERS DATAFILE '/oracle_11204/oracle/oradata/dbacode/datafile/users01.dbf' SIZE 60M;

Tablespace created.

Difference between Recovery Window & Backup Window

Recovery Window :
A recovery window is a period of time that begins with the current time and extends backward in time to the point of recoverability. The point of recoverability is the earliest time for a hypothetical point-in-time recovery, that is, the earliest point to which you can recover following a media failure.
To configure a retention policy based on recovery window, use

 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW no DAYS;  

RMAN Restartable Backups or Re-Initiating RMAN Backups

Using the restartable backups feature, RMAN can backup only those files that have not been backup since a specified date. You can use this feature after a failed backup to re-initiate that backup. The unit of restartability is a backup set.