SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Oracle Database Instance Recovery Tutorial

Oracle Consultants Available

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

Sep 11 - SkillBuilders Oracle 11g PL/SQL Programming Workshop

This free tutorial is segmented into fourteen separate lessons:

Listen to the Podcast for this Training
1. Introduction to Oracle Certified Master John Watson and SkillBuilders   (1:44)  
2. Tutorial Agenda   (2:40)  
3. The Database ACID Test   (3:09)  
4. Physical and Logical Corruption   (1:37)  
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)  
7. When Why and How Does Oracle Write to Disk   (1:58)  
8. What About Checkpoints?   (1:16)  
9. Discussion about COMMIT NOWAIT   (3:46)  
10. Lecture - What Oracle Database does when DML is Executed   (7:22)  
11. The Oracle Instant Crash Recovery Mechanism   (6:24)  
12. Principles to Remember   (0:52)  
13. Oracle - The Incorruptible Database   (1:54)  
14. Next Steps   (0:47)  

Date: Jun 4, 2013

View all videos now - Free Online Registration required

Here is a preview:

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