O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Crash and media recovery

In general, database recoveries can be categorized into two broad domains:

  • Crash recovery
  • Media recovery

Crash recovery (a.k.a. instance recovery) is a more subtle form of database recovery because all that is lost is the database instance. Since it's just the instance that's lost and not any physical file of the database, the recovery won't need any physical file(s) to be restored. The background process SMON will initiate the recovery automatically at the time of the next database startup. In this recovery, only the online redo logs belonging to a single thread (for a single instance) or of multiple failed threads are used for a Real Application Cluster (RAC) database.

Note

Many DBAs often use the terms instance and crash ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required