How does Oracle Database crash recovery work? What is the ACID Test? (Atomicity, Consistency, Isolation, Durability)
In this tutorial you’ll learn Oracle’s mechanism of redo and undo and then, you will know! Undo / redo architecture is probably the best developed by mankind for guaranteeing that a database can never lose data and will never be corrupted. If a database ever loses one row of committed data, management reaction is often to fire the DBA. That’s because Oracle is famous for reliability: if properly configured, you can’t corrupt the database and it will never lose data. So if anything goes wrong, it isn’t Oracle’s fault; it is the DBA’s. This webinar will go through what actually happens in memory and on disc when you execute DML statements, demonstrating how it is that committed transactions can never be lost and how the instance recovery process guarantees that the database will never be corrupted. So long as the DBA takes simple precautions.
Course Features
- Lectures 2
- Quizzes 0
- Duration 40 Minutes
- Skill level All levels
- Language English
- Students 11
- Assessments Yes