Oracle RMAN Interview Question:

Explain the steps for recovery of missing data file?

Submitted by: Administrator

Connect to RMAN and make the affected Tablespace offline immediate.

SQL> !rman target /
RMAN> sql 'ALTER TABLESPACE DATA OFFLINE IMMEDIATE';

Perform Restore and Recover of The tablespace.

RMAN> RESTORE TABLESPACE DATA;
RMAN> RECOVER TABLESPACE DATA;

Make the status online of the tablespace.

RMAN> sql 'ALTER TABLESPACE DATA ONLINE';

In this case oracle at first create and empty datafile and then apply all archived redo logs and online redo logs on the tablespace up to the current time.
Alternate way without using RMAN :

SQL> ALTER DATABASE CREATE DATAFILE 'c:oracleoradatarheacc_capture SIZE 2048m AS datafile_file51_spec;

Determine whether you entered the correct filename. If you did, then check to see whether the log is missing from the operating system. If it is missing, and you have a backup, then restore the backup and apply the log. If you do not have a backup, then if possible perform incomplete recovery up to the point of the missing log.
Submitted by: Administrator