User-Managed and RMAN Backup and Recovery in Oracle9i

Overview/Description
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database

Target Audience


Oracle database administrators and database operators

Prerequisites


Familiarity with RDBMS technologies

Expected Duration


405 Minutes

Objectives :

User-Managed and RMAN Backup and Recovery in Oracle9i

  • describe the concepts of user-managed backup operations in an Oracle9i database.
  • describe a user-managed closed backup of an Oracle9i database.
  • discuss user-managed open database backups.
  • describe and use the different user-managed Oracle9i database backup options.
  • verify a data file and perform an online Oracle9i database backup.
  • describe the backup characteristics of the Oracle9i database Recovery Manager (RMAN).
  • back up an Oracle9i database using Recovery Manager (RMAN) backup sets.
  • explain how to create image copies in an Oracle9i database using the Recovery Manager (RMAN).
  • discuss incremental, archived redo log, and Noarchivelog mode backups of an Oracle9i database.
  • describe the functionality of the Oracle9i database Recovery Manager (RMAN).
  • perform Oracle9i database backups using the Recovery Manager (RMAN).
  • describe and perform a user-managed media recovery of an Oracle9i database.
  • perform Oracle9i database recovery in Noarchivelog mode and Archivelog mode.
  • describe the user-managed complete recovery methods that are available for an Oracle9i database.
  • describe the user-managed recovery functionality that is available for an Oracle9i database.
  • perform a user-managed complete recovery of an Oracle9i database.
  • describe how to perform complete recovery operations on an Oracle9i database using Recovery Manager (RMAN).
  • perform a complete recovery of an Oracle9i database using Recovery Manager (RMAN).
  • describe a user-managed incomplete recovery of an Oracle9i database.
  • perform a user-managed incomplete recovery of an Oracle9i database.
  • use the Recovery Manager (RMAN) to perform an incomplete recovery of an Oracle9i database.
  • use the UNTIL TIME option of the Recovery Manager (RMAN) to perform an incomplete recovery of an Oracle9i database.


    • Course Number: 66138_eng