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