Description

This course is essential for anyone who wants to establish an effective backup strategy for Oracle 12c database. They will mainly see operation in ARCHIVELOG mode, RMAN, specific backup/restore scenarios, LogMiner and the use of Flashback Database.

Who is this training for ?

For whom ?

Oracle 12c database administrators, application administrators, system administrators, consultants.

Prerequisites

Training objectives

Establish a backup and restoration management strategy for an Oracle 12c database Apply RMAN tool features Restore an Oracle database following file loss Duplicate an Oracle database Move an Oracle database

Training program

• Reminders
  • The redo log, control and data files.
  • ARCHIVELOG mode.
  • The DBNEWID utility.
  • Exercise: Save the control file and change the database name.
• RMAN Components and Features
  • Configuration and commands.
  • Automatic backup of the control file.
  • Compression, encryption and parallelism of backups.
  • Save a CDB and PDB database.
  • Incremental backup.
  • Multisection backups.
  • Exercise: Compressed and parallelized backup of the database.
• Maintenance de RMAN
  • Creating the catalog and virtual catalogs.
  • Enrolling in the catalog.
  • Adding or removing catalog backups.
  • Stored scripts and saving the catalog.
  • Exercise: Creation of the catalog and registration of the database.
• Maintenance de RMAN
  • Creating the catalog and virtual catalogs.
  • Enrolling in the catalog.
  • Adding or removing catalog backups.
  • Stored scripts and saving the catalog.
  • Exercise: Creation of the catalog and registration of the database.
• File loss and recovery
  • Losing control files.
  • Rebooting with missing files.
  • Losing files from the UNDO tablespace or a read-only tablespace.
  • Use RMAN.
  • The RESTORE and RECOVER commands.
  • Validating backups and the database.
  • Checks and list of failures.
  • Exercise: Restoring the database after losing files.
• Duplicate a database
  • Duplicate a database.
  • Choose the PDB databases.
  • Duplicate a database without stopping it.
  • Exercise: Clone a hot database.
• Incomplete recovery
  • Configure and use LogMiner.
  • Incomplete recovery of a tablespace or an inserted PDB database.
  • Restore a database to a previous incarnation.
  • Exercise: Find the deletion SCN of a deleted object and recover the object.
• Flashback Database
  • Flashback Database and backup of the quick recovery area.
  • Flashback on a table deleted in PDB.
  • Exercise: Recovering a user with Flashback Database and a tablespace with RMAN.
• Data movement
  • Data Pump and transport of a tablespace or the database.
  • Use external tables.
  • Transport a database to another OS.
  • Exercise: Transporting a tablespace from one database to another.