What is the difference between instance recovery and crash recovery?
Answer / Prem Shankar Sah
Instance recovery occurs when a database instance is started after it has been shut down, either normally or abnormally. Crash recovery, on the other hand, occurs automatically when an instance is restarted after a system failure. During crash recovery, the database is rolled forward to the last committed transaction before the failure.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the key components of oracle’s maximum availability architecture?
What do we mean by hot backup & cold backup and how are they different?
What are the different tools that are provided by oracle to assist performance monitoring?
Where does the clusterware write when there is a network or storage issue?
What do you mean by database normalization and why is it important?
What do you understand by row chaining?
What is rac?
What is rac and what are the various benefits of using rac architecture?
How do you recover a lost control file?
How would you identify the shared_pool_size parameter that needs to be adjusted?
What is the difference between media recovery & crash recovery?
How can we collect the statistics of different database objects?