Mention what is the difference between instance recovery and crash recovery?
Answer Posted / Ark Gopal
"Instance recovery is a process that brings an Oracle database instance back to a consistent state after it has been shut down abnormally or manually.nn1. Instance Recovery: This occurs when the instance is started with the NOMOUNT, MOUNT, or OPEN command.n2. Crash Recovery: This occurs automatically when an instance is started after a database crash, such as a power outage or hardware failure.n3. Crash recovery scans all online redo logs to ensure that all committed transactions have been applied to the database."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category