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 is a recovery catalog?
How would you identify the shared_pool_size parameter that needs to be adjusted?
Mention where does the clusterware write when there is a network or storage issue?
Explain the hardware architecture used in oracle rac?
What is table partitioning and why is it required?
What are the main components of an oracle rac system?
What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?
What is tkprof?
What is the load balancing advisory?
What are the key characteristics of rac or why to use rac?
How can we identify the resources for which the sessions are waiting?
Mention in rac what files should be created on shared storage?