Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it. They also need to ensure if a failure does occur that the loss of data is minimized as much as possible and they can recover the database in an efficient manner. As an Oracle DBA, it is important to understand the various internal consistency checks a database performs as it moves from the shutdown stage to being fully open. Equally important is an understanding of what can cause a failure, and how to recover from an instance failure. This course explores how to identify the types of failure that can occur in an Oracle database and how to prepare a database for failure recovery by using checkpoints, log files, and the flash recovery area and ARCHIVELOG mode, as well as how to perform different types of backups. It also discusses the need for performing recovery and the use of tools such as the Recovery Manager (RMAN) and the Data Recovery Advisor for file recovery operations.
This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
Oracle Failures and Instance Recovery
- identify the types of failure that can occur in a database
- configure a database for instance recovery
- prevent media failure
- configure ARCHIVELOG mode
Performing Database Backups
- identify strategies for backing up a database
- use RMAN to configure, schedule, manage, and view backup operations
- perform data recovery
- prepare a database for recovery
- perform a database backup
- perform recovery on a database