Chapter 4. Database Recovery
ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Recover the control file.
Explain reasons for incomplete recovery.
Perform incomplete recovery using EM.
Perform incomplete recovery using RMAN.
Perform incomplete recovery using SQL.
Perform database recovery following a RESETLOGS operation.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
Recovering an Oracle Database 10g (Oracle 10g) can be performed in one of three ways: using traditional user-managed recovery procedures, Recovery Manager (RMAN), or Enterprise Manager (EM). As a DBA, you must have the ability to successfully recover your database to a normal state in many failure situations.
This chapter walks you through the steps for recovering the database in many situations. You will use the RECOVER command in different scenarios with user-managed recovery. The RESTORE and RECOVER commands will be utilized with RMAN to perform many different types of recovery. You will also look at new Oracle 10g features such as simplified RESETLOGS recovery, and you will use EM to perform an incomplete database recovery. We will include demonstrations and have step-by-step examples performing each of these events, as well as other related activities.