Archive log mode is required for hot backups; however, hot backups are not required for databases running in Archivelog mode. You can still perform cold backups with a database running in Archivelog mode. These are not mutually exclusive.
When you restore datafiles from your backup (cold or hot), try not to restore the control files if at all possible. The control files contain the most current SCN along with information about the archived redo logs. This information can make rolling forward (the recovery process) much easier.
I would highly recommend looking at Oracle Backup & Recovery Handbook by Velpuri & Adkoli on Oracle Press. It has many recovery scenarios for you to practice such as the one above.
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.