4.9. Exam Essentials

Understand the different types of incomplete recovery. Make sure you are aware of the steps required for the three different types of incomplete recovery: user-managed, RMAN, and EM. Understand the different failure situations in which incomplete recovery should be used.

Know how to perform incomplete recovery using EM. Make sure you are familiar with the steps required to perform incomplete recovery using EM. Understand how to maneuver through the web screens to perform an incomplete recovery.

Know how to perform incomplete recovery using RMAN. Make sure you are familiar with the steps required to perform incomplete recovery using RMAN. Understand how to use the different RMAN commands for performing incomplete recovery.

Know how to perform incomplete recovery using SQL. Make sure you are familiar with the steps required to perform incomplete recovery using the traditional user-managed methods, which use SQL. Understand how to use the different commands for performing incomplete recovery using user-managed methods.

Understand database recovery using the RESETLOGS option. Be aware of how to recover a database using the RESETLOGS option. Know what the impacts of the improvements to the RESETLOGS option are for an incomplete database recovery.