Description

This course will allow you to master RMAN tools, advanced features such as using a catalog, stored scripts, duplication and transport of cross-platform databases.

Who is this training for ?

This course is aimed at anyone who wants to use RMAN to perform backups of their Oracle databases.

Training objectives

Training program

• Introduction and reminders
  • - Network configuration.
  • - Redo log files.
  • - Control files.
  • - Data files.
  • - Archivelog mode.
  • - The quick recovery area.
  • - Practical work Configuring the database in Archivelog mode.
  • - Start the database remotely.
• Introduction to RMAN
  • - Architecture.
  • - Client utility.
  • - Basics.
  • - The control file.
  • - The memory usage.
  • - The quick recovery area.
  • - Persistent configuration in the target database control file.
  • - Channel concept and use of channels.
  • - Practical work Configuration of the control file.
• Media managers
  • - Magnetic tapes.
  • - Media Manager.
  • - Media Management Library.
  • - Tape backup/restore.
  • - Oracle Secure Backup.
  • - User interface.
• Backup with RMAN
  • - Cold/hot backup.
  • - Image copies vs. backup sets.
  • - Backup compression.
  • - Full backup/ incremental.
  • - Processing read-only files.
  • - Corruption test.
  • - Using command groups.
  • - RUN command.
  • - SET command.
  • - Backup of tablespaces, files, archived redo log files, control file, SPFILE file.
  • - Practical work Using commands BACKUP and RUN.
• Restoration/recovery with RMAN
  • - RESTORE command.
  • - Restoring the SPFILE file and the control file.
  • - Restoring a specific/old backup.
  • - Restoration with renaming.
  • - The RECOVER command.
  • - Partial/incremental recovery.
  • - Practical work Restoration to a new location.
  • - Recovering a database following file loss.
• Maintenance de RMAN
  • - The catalog database.
  • - Creation of the catalog.
  • - Registration of target databases.
  • - Addition of catalog backups.
  • - Using stored scripts.
  • - Saving the catalog database.
  • - The LIST command.
  • - The REPORT command.
  • - Views.
  • - CROSSCHECK, CHANGE and DELETE commands.
  • - Practical work Creating the catalog.
  • - Using stored scripts and LIST commands and REPORT.
  • - Checking backups.
• Advanced Features
  • - Block corruption.
  • - TableSpace Point-In-Time Recovery (TSPITR).
  • - Cloning a database.
  • - Practical work Recovery of corrupted blocks.