Chapter 11. Backup and Recovery

There are a thousand excuses for failure but never a good reason. - Mark Twain

In this chapter we will discuss the basics of Oracle Database XE backup and recovery. This chapter introduces Oracle's backup and recovery tool, Recovery Manager (RMAN). We will also discuss a few backup and recovery scenarios. The following are the topics covered in this chapter:

• A brief introduction to backup and recovery

• Recovery Manager

• Connecting to Oracle Database XE using RMAN

• The ARCHIVELOG mode

• Placing a database in the ARCHIVELOG mode

• Backing up a database (the NOARCHIVELOG mode)

• Simulating a database failure (the NOARCHIVELOG mode)

• Restoring the NOARCHIVELOG database

• Configuring the RMAN environment

• Backing up the ARCHIVELOG database

• Simulating a database failure (the ARCHIVELOG mode)

• Restoring ARCHIVELOG database

The full range of backup and recovery techniques is out of the scope of this book. Refer to Oracle documentation for more details.

Introduction to backup and recovery

In...