RelationalDBDesign 





Database Backup   «Prev  Next»
Lesson 1

Introduction to Oracle Recovery Manager

The most important job for an Oracle database administrator (DBA) is the backup and recovery of Oracle databases. In the first course in this series, you learned what could happen when you do not take this role to heart. As a DBA, you can almost get away with a poorly performing database, as long as the data within the database is correct. After all, poor performance can be eliminated with tuning, Oracle Sql Tuning. But if the data is not available or cannot be recovered, your ability to restore the original state will be in jeopardy.

New Backup and Recovery Features for Oracle 11g Release 2

The following Backup and Recovery features are new in Oracle Database 11g Release 2
  1. Oracle Secure Backup (OSB) Cloud Module
    Users can take advantage of the Internet-based data storage services offered by Amazon Simple Storage Service (Amazon S3) for their RMAN backup and recovery tasks. The OSB Cloud Module interface extends the Amazon S3 functionality and provides an easy-to-manage, cost-efficient, and scalable alternative to maintaining in-house data storage and a local, fully configured backup infrastructure.
  2. DUPLICATE Database Command Enhancements
    Users can duplicate a database without connecting to a target database. The only requirements for this operation are a connection to a catalog and an auxiliary database. This new functionality is useful when the target database is not always available. Users can also duplicate a database without connecting to a target database and a recovery catalog. In this case, the only requirement is that you provide a disk backup location where RMAN can find all the backups, data file copies, archived logs, and control file copies for database duplication. This database duplication enhancement is helpful when it is not possible to connect to the target database and the recovery catalog. When you duplicate from a target database, RMAN determines if any excluded tablespaces contain SYS-owned objects, materialized views, and identifies tablespaces that are not self-contained before starting any duplication operations.


Recovery Manager
Oracle contains a new utility called Recovery Manager, or RMAN, to manage the backup, restoration, and recovery of Oracle database files. If you are managing multiple databases, RMAN is the tool for you. This module introduces Recovery Manager and its components.
  1. By the end of this module, you will be able to:
  2. Discuss the purpose and features of Oracle Recovery Manager
  3. Review the basic components of RMAN
  4. Discuss the preparation involved in using RMAN
  5. Discuss the role of Backup Manager as a graphical user interface (GUI) tool for backup and recovery
  6. Discuss how backup sets are used within Recovery Manager
  7. Discuss the concept of image copies
  8. Discuss the role of the recovery catalog
  9. Demonstrate how to create a recovery catalog
For more detailed information, refer to the Oracle Server Backup and Recovery documentation. You can find this on your Oracle release CDs. This documentation can also be found online at the Oracle Web site refer to the Resources page for additional information. Several third-party books on the topic can also provide practical examples and can be found on the Resources page. In the next lesson, you will learn the basic features of Oracle Recovery Manager.