Oracle Database 11g: Configuring for Backups


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.7

Lesson Objectives

Oracle Database 11g: Configuring for Backups

  • recognize the steps for preparing and optimizing a database for a backup.
  • recognize the steps for creating fast incremental backup and duplex backup sets using RMAN.
  • recognize the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.
  • recognize the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.
  • identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.
  • recognize the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.
  • recognize the steps for performing different types of user-managed recoveries.
  • back up a database and recover a lost online redo log file in a given scenario.
  • Course Number:
    257033_eng