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:
Some important assumptions if you want to recover your database up to the point of failure are: