Creating and updating duplicate databases with rman 11g
Also test ALL backup and recovery scenarios carefully. Regardless of your strategy, also remember to backup all required software libraries, parameter files, password files, etc.If your database is in ARCHIVELOG mode, you also need to backup archived log files.Remember, it's the little things that will get you.Most failed recoveries are a result of organizational errors and miscommunication.This can be done to replace damaged files or to copy/move a database to a new location.Recovery is the process of applying redo logs to the database to roll it forward.It is easier to restore from off-line backups as no recovery (from archived logs) would be required to make the database consistent.
Except for Oracle exports, one can only do on-line backups when the database is ARCHIVELOG mode.
Other backup strategies normally back-up the physical data files.
One of the advantages of exports is that one can selectively re-import tables, however one cannot roll-forward from an restored export.
Point-in-time recovery (regardless if you do on-line or off-line backups) is only available when the database is in ARCHIVELOG mode.
Restoring involves copying backup files from secondary storage (backup media) to disk.