Recovering from a user-managed backup

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 ...

Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.