rman recover

On a high-level, the following three steps are performed in recovering the database from RMAN backup.

1. Restore controlfile from backup

MAN> SET DBID 12345;

RMAN> STARTUP NOMOUNT;

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";

RMAN> ALTER DATABASE MOUNT;

2. Restore the databse

RMAN> RESTORE DATABASE;

3. Recover the database

RMAN> RECOVER DATABASE;

RMAN> ALTER DATABASE OPEN RESETLOGS;