Mention what is the difference between instance recovery and crash recovery?
Answer / 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 |
What is the difference between single instance environment and rac environment?
Why do we need to rebuild indexes?
Mention where does the clusterware write when there is a network or storage issue?
Mention what is cluster?
What are the file storage options provided by oracle database for oracle rac?
Explain the purpose of oracle real application clusters (rac)?
How do you recover a lost control file?
Explain the oracle grid infrastructure?
What is table partitioning?
What are the different types of backups that are available in oracle?
How is clustered index different from non-clustered index?
Mention what are the benefits of oracle rac?