When recovering a database in the ARCHIVELOG mode, you can do it using an online or offline backup, depending on the type of backup strategy you are currently using in your environment. When recovering from a user-managed backup, you will be able to recover the database up to the point that the failure occurred, and you can choose to recover the database to a specific point in time based on date and time or using a SCN.
When doing a recovery of a database in the ARCHIVELOG mode you will be also able to make a recovery of:
Datafiles
Tablespaces
Or if necessary, the entire database
Some important assumptions if you want to recover your database up to the point of failure are:
You still have at least one member of each of the current redo log groups
All archive logs required are available to be used
To perform a full database recovery from a backup of a database in the ARCHIVELOG mode, follow these steps:
Restore all the database datafiles from your backup.
Restore...
