DIFFERENCE BETWEEN INSTANCE AND CRASH AND MEDIA RECOVERY ORACLE

Crash recovery –

  • If a single instance or all RAC database instance crash due to failure , then the database needs to be recovered by smon.
  • There is no manual intervantion required by any DBA for crash recovery of database.
  • There is no need of archivelog apply by DBA

Instance recovery –

  • If any one node instance of a RAC node fail due to some issue, then the surviving node should involve in recovering the failed instance using smon
  • There is no need of archivelog apply by DBA

Media recovery –

  • Here DBA intervention is required for manual restore of datafiles and recovery of database using rman

Leave a Reply