Recovering with the current control file using RMAN

This method applies when using Oracle disk backups.

Restoring files from backup is a first step when recovering a database and can also be performed in other cases, such as when upgrading from a single-host to a multi-host configuration. Disk backups are supported for both AS300 and AS3000 Oracle Database Servers.

With the current control file, you can restore the database to the point of the database failure so that no committed transactions are lost.

To recover with the current control file using RMAN

Log in as user oracle (Solaris) or AgfaService (Windows).
Log in as Administrator user.
If the Oracle database is still open, shut it down. Type
rman target /
shutdown abort;
To start up the database, from the rman prompt, type
startup mount;
To restore the database, type
restore database;
After all the files have been restored, at the rman prompt, type
recover database;
If you see the message Media recovery complete, type
alter database open;
Type exit.