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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s