Performing Database Recovery

Introduction

The Performing Database Recovery module shows how to use the Data Recovery Advisor, which can help find and recover the database.

• Performing Recovery Operations
• Recovering from User Errors
• Recovering from Loss of Control Files
• Recovering from Loss of Redo Log Files
• Recovering from Loss of Non-System Critical Data Files
• Recovering from Loss of System Critical Data Files

Exercise 1 - Performing Recovery Operations

In this exercise you will learn the following about performing recovery operations:

• Establishing a connection to the database
• Understanding Instance Start-up

Exercise 2 - Recovering from User Errors

In this exercise, you will learn the following about how to recover from user errors:

• Using Flashback Query
• Using Flashback Drop and the Recycle Bin
• Using Flashback Table

Exercise 3 - Recovering from a Loss of a Control File

In this exercise, you will learn the following about recovering a control file loss:

• Recovering a Control File Loss

Exercise 4 - Recovering from the Loss of a Redo Log File

In this exercise, you will learn the following about recovering a redo log file loss:

• Recovering a Redo Log File Loss

Exercise 5 - Recovering from a Loss of a Non-System Critical Data File

In this exercise, you will learn the following about recovering a non-system critical data file loss:

• Recovering a Non-System Critical Data File Loss

If a non-system-critical data file (not the system or UNDO tablespace) is lost, most of your recovery efforts in the ARCHIVELOG mode take place while the database is still open to users who can use tablespaces except the one that is being recovered. The loss can occur in two modes: NOARCHIVELOG Mode and ARCHIVELOG Mode.

Exercise 6 - Recovering from a Loss of a System Critical Data File

In this exercise, you will learn the following about recovering a system critical data file loss:

• Recovering a System Critical Data File Loss

When a system critical data file is lost, the kinds of recovery available depend on whether the mode of operation is ARCHIVELOG mode or NOARCHIVELOG mode. Oracle strongly recommends operating in ARCHIVELOG mode for any production database that is not read-only.