The steps to recovery vary depending on the scenario you are recovering from. The steps to recovery also depend on whether or not you are running in archivelog mode. If you are not running in archivelog mode, then your only recovery option from a cold backup is to shut down the database, replace the control files and datafiles from your backup and start up the database again. You will lose all transactions since the backup was taken.
If you are running in archivelog mode, then you can restore transactions since the backup was taken. Please refer to the Oracle Backup and Recovery Guide for your specific version for more information.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading