Recovery of lost data files recovered from Rman database

Delete a data file:
sql> HOST del D:\app\Administrator\oradata\orcl\USERS01.dbf

Start the database and prompt for loss of data file 4, at which point the database handles mount status:

Rman> STARTUP

......

An error occurred on line 1th:
ORA-01157: Unable to identify/lock data file 4-see DBWR trace file
ORA-01110: Data file 4: ' D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01. DBF '

Perform Rman recovery
====================

Connect to the recovery directory, connect to the target database, perform restore, execute recover

C:\users\administrator>Rman Recovery manager: Release 11.2.0.1.0-production on Sunday December 21 19:05:45 2014Copyright (c) 1982, the Oracle and/or its affiliates. AllRights reserved. rman> CONNECT CATALOG Rmanct/[email protected]; RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE, STACK follows =============== RMAN-00571: ===========================================================  RMAN-04004: Warning from recovering the catalog database: ORA-01033 : ORACLE is initializing or shutting down rman> connect target sys/[email protected] ; connected to the target database: ORCL (dbid= 1392118573 , not open) rman> restore datafile 4 ; start Restore in 2 January-December -14  Use the target database control file instead of the channel that restores the directory allocation: ora_disk_ 1-channel ora_disk_1:sid=10 device type =disk  Channel ora_disk_1: Starting restore data file backup set Channel Ora_disk_1: Specifying data file channel to restore from backup set ora_disk_1: Data file 00004  revert to D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01. DBF Channel Ora_disk_1: Reading backup fragment D:\RMAN_BAK\FUL_BAK_20141221 Channel Ora_disk_1: segment handle = D:\RMAN_BAK\FUL_BAK_20141221 Tag =  tag20141221t134059 Channel Ora_disk_1: restored backup fragment 1  Channel ora_disk_1: Restore Complete, spents: 00:00:04  completed Restore on 2 January-December -14  rman& Gt RECOVER datafile 4 ; start RECOVER on 2 January-December -14  recovery media with channel Ora_disk_1 starting media recovery complete, when: 00:00:01  complete RECOVER on 21-12 Month -14                

Open the database:

rman> ALTER DATABASE OPEN;

Database is open

Sql> SELECT STATUS from V$instance;
STATUS
------------
OPEN

Recovery of lost data files recovered from Rman database