(FALL 2009)

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices. Prerequisites: Oracle Database 11g: Administration Workshop I.

Victor T. Wu, M.S., is a CTO and co-founder of EmpowerTrain, an Irvine-based company that offers high-end training on technologies including Oracle Database, Sun Solaris, Microsoft technologies. He has worked in the information systems field for the past 25 years as developer, information architect, director, and CIO. His expertise includes C++, Java programming, Oracle database and SQL Server development, high availability and performance tuning, Sun Solaris security and system tuning. He is frequently involved in large scale database and system tuning projects in San Francisco, Los Angeles, and San Diego. Wu is a UCLA graduate, Oracle Certified DBA, Oracle Certified Developer and holder of three Oracle Masters. Wu received UC Irvine Extension's Distinguished Instructor Award (2003) and UCLA Extension's Distinguished Instructor Award (2007).