One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.
Target audience for this course is Oracle database administrators.
The objective of this course is to equip database administrators with the skills necessary to backup a production Oracle database and to recover as much information as possible in the event of a major failure. Significant subjects to be considered are:
- Consider the various archive modes that the database may operate in and the effect on recovery capabilities of each mode.
- Consider advanced database configuration options that assist recovery of lost data.
- Build a backup and recovery strategy with user-managed techniques.
- Build a backup and recovery strategy with server-managed techniques and the RMAN tool.
- Configure standby databases as part of disaster recovery using Oracle Data Guard.
- Learn about advanced techniques that not only recover lost data but endeavor to do so efficiently and rapidly, allowing a quick return to normal operations
