Restore and Recover Database From RMAN Backup.

C:\Users\rajib.pradhan>SET ORACLE_SID=DBRMAN

C:\Users\rajib.pradhan>RMAN

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jul 16 16:21:34 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> CONNECT TARGET /

connected to target database (not started)

RMAN> STARTUP FORCE MOUNT;

Oracle instance started
database mounted

Total System Global Area     535662592 bytes

Fixed Size                     1375792 bytes
Variable Size                478151120 bytes
Database Buffers              50331648 bytes
Redo Buffers                   5804032 bytes

RMAN> RESTORE DATABASE;

Starting restore at 16-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\APP\ORADATA\DBRMAN\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to D:\APP\ORADATA\DBRMAN\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to D:\APP\ORADATA\DBRMAN\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to D:\APP\ORADATA\DBRMAN\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to D:\APP\ORADATA\DBRMAN\CATALOG_SPC01.DBF
channel ORA_DISK_1: restoring datafile 00006 to D:\APP\ORADATA\DBRMAN\TBS_RAMN_CAT_01.DBF
channel ORA_DISK_1: restoring datafile 00008 to D:\APP\ORADATA\DBRMAN\BEFTN01.DBF
channel ORA_DISK_1: restoring datafile 00009 to D:\APP\ORADATA\DBRMAN\MICR01.DBF
channel ORA_DISK_1: restoring datafile 00010 to D:\APP\ORADATA\DBRMAN\EXAMPLE01.DBF
channel ORA_DISK_1: restoring datafile 00011 to D:\APP\ORADATA\DBRMAN\MICRACK01.DBF
channel ORA_DISK_1: restoring datafile 00012 to D:\APP\ORADATA\DBRMAN\MICRDFT01.DBF
channel ORA_DISK_1: restoring datafile 00013 to D:\APP\ORADATA\DBRMAN\MICR_IMG01.DBF
channel ORA_DISK_1: restoring datafile 00014 to D:\APP\ORADATA\DBRMAN\MICRIND01.DBF
channel ORA_DISK_1: restoring datafile 00015 to D:\APP\ORADATA\DBRMAN\MICRINW01.DBF
channel ORA_DISK_1: restoring datafile 00016 to D:\APP\ORADATA\DBRMAN\MICRLOG01.DBF
channel ORA_DISK_1: restoring datafile 00017 to D:\APP\ORADATA\DBRMAN\MICROUT01.DBF
channel ORA_DISK_1: restoring datafile 00018 to D:\APP\ORADATA\DBRMAN\MICRSTP01.DBF
channel ORA_DISK_1: reading from backup piece D:\APP\ORADATA\DBRMAN_BACKUP\BKP_DBRMAN_853084086_53_1_1LPDI1TM
channel ORA_DISK_1: piece handle=D:\APP\ORADATA\DBRMAN_BACKUP\BKP_DBRMAN_853084086_53_1_1LPDI1TM tag=TAG20140716T154806
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06:16
Finished restore at 16-JUL-14

RMAN> recover database;

Starting recover at 16-JUL-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:19

Finished recover at 16-JUL-14

RMAN> ALTER DATABASE OPEN;

database opened

RMAN>