Back

Oracle Database Instance Recovery Tutorial

Is It Possible to Corrupt an Oracle Database?

No, You Cannot – Not If It Is Properly Administered

Why? Because the mechanism of redo and undo is the best yet developed on this planet.

In this tutorial, Oracle Certified Master John Watson will explain redo, undo, commit, instance recovery and demonstrate why your database can never lose one row of committed data.

Learn what actually happens, in memory and on disc, when DML is issued. John will demonstrate that instance recovery is automatic, and unstoppable.

This is critical and essential knowledge for all Oracle Administrators and DBA students.

Presenter: John Watson, Oracle Certified Master

This free tutorial is segmented into fourteen separate lessons:

  1. Introduction to Oracle Certified Master John Watson and SkillBuilders (1:44) (click on video below) click to read the Transcript(click to read the Transcript)
  2. Tutorial Agenda (2:40) click to read the Transcript
  3. The Database ACID Test (3:09) click to read the Transcript
  4. Physical and Logical Corruption (1:37) click to read the Transcript
  5. Demonstration – What Does Oracle do when DML is Executed? (9:47) click to read the Transcript
  6. Commit and the Log File Sync Wait Event (1:18) click to read the Transcript
  7. When Why and How Does Oracle Write to Disk (1:58) click to read the Transcript
  8. What About Checkpoints? (1:16) click to read the Transcript
  9. Discussion about COMMIT NOWAIT (3:46) click to read the Transcript
  10. Lecture – What Oracle Database does when DML is Executed (7:22) click to read the Transcript
  11. The Oracle Instant Crash Recovery Mechanism (6:24) click to read the Transcript
  12. Principles to Remember (0:52) click to read the Transcript
  13. Oracle – The Incorruptible Database (1:54) click to read the Transcript
  14. Next Steps (0:47) click to read the Transcript

Date: Jun 4, 2013


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.