RMAN> restore database;
Starting restore at 17-FEB-13 12:04:59
using channel ORA_DISK_1
using channel ORA_DISK_2
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 +BIG_DATA/db1dup/datafile/system.263.807297175
channel ORA_DISK_1: restoring datafile 00004 to +BIG_DATA/db1dup/datafile/hh_test.266.807622509
channel ORA_DISK_1: reading from backup piece +FRA/db1dup/backupset/2013_02_17/nnndf0_db1dup_noarchivelog_0.355.807623101
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00002 to +BIG_DATA/db1dup/datafile/sysaux.265.807297173
channel ORA_DISK_2: restoring datafile 00003 to +BIG_DATA/db1dup/datafile/undotbs1.264.807297175
channel ORA_DISK_2: reading from backup piece +FRA/db1dup/backupset/2013_02_17/nnndf0_db1dup_noarchivelog_0.354.807623101
channel ORA_DISK_1: piece handle=+FRA/db1dup/backupset/2013_02_17/nnndf0_db1dup_noarchivelog_0.355.807623101 tag=DB1DUP_NOARCHIVELOG
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:27
channel ORA_DISK_2: piece handle=+FRA/db1dup/backupset/2013_02_17/nnndf0_db1dup_noarchivelog_0.354.807623101 tag=DB1DUP_NOARCHIVELOG
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:37
Finished restore at 17-FEB-13 12:05:38
RMAN> recover database noredo preview;
Starting recover at 17-FEB-13 12:05:53
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished recover at 17-FEB-13 12:05:53
RMAN> recover database noredo;
Starting recover at 17-FEB-13 12:06:24
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished recover at 17-FEB-13 12:06:25
RMAN> sql ‘alter database open’;
sql statement: alter database open