Szkolenia Oracle

Cel szkolenia

his Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios.

Learn To:

  • Develop appropriate backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.

Plan szkolenia Rozwiń listę

  1. Introduction
    • Curriculum Context
    • Assess your Recovery Requirements
    • Categories of failures
    • Oracle Backup and Recovery Solutions
    • Oracle Maximum Availability Architecture
    • Oracle Secure Backup
    • Benefits of using Oracle Data Guard
    • Basic Workshop Architecture
  2. Getting Started
    • Core Concepts of the Oracle Database, Critical for Backup and Recovery
    • Oracle DBA Tools for Backup and Recovery
    • Connecting to Oracle Recovery Manager (RMAN)
    • Quick Start: A Problem-Solution Approach
  3. Configuring for Recoverablility
    • RMAN commands
    • Configuring and managing persistent settings
    • Using the Fast Recovery Area (FRA)
    • Control File
    • Redo Log File
    • Archiving Logs
  4. Using the RMAN Recovery Catalog
    • Creating and Configuring the Recovery Catalog
    • Managing Target Database Records in the Recovery Catalog
    • Using RMAN Stored Scripts
    • Maintaining and Protecting the Recovery Catalog
    • Virtual Private Catalogs
  5. Backup Strategies and Terminology
    • Backup Solutions Overview and Terminology
    • Balancing Backup and Restore Requirements
    • Backing Up Read-Only Tablespaces
    • Best Practices for Data Warehouse Backups
    • Additional Backup Terminology
  6. Performing Backups
    • RMAN Backup Types
    • Incrementally Updated Backups
    • Fast Incremental Backup
    • Block Change Tracking
    • Oracle-Suggested Backup
    • Reporting on Backups
    • Managing Backups
  7. Improving Your Backups
    • Compressing Backups Using a Media Manager
    • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
    • Creating and Managing Archival Backups
    • Backing Up Recovery Files
    • Backing Up the Control File to a Trace File
    • Cataloging Additional Backup Files
    • Backing Up ASM Disk Group Metadata
  8. Using RMAN-Encrypted Backups
    • Creating RMAN-Encrypted Backups
    • Using Transparent-Mode Encryption
    • Using Password-Mode Encryption
    • Using Dual-Mode Encryption
  9. Diagnosing Database Failures
    • Reducing Problem Diagnosis Time
    • Automatic Diagnostic Repository
    • Interpreting RMAN Message Output and Error Stacks
    • Data Recovery Advisor
    • Diagnosing Data File Loss (file system and ASM)
    • Handling Block Corruption
  10. Restore and Recovery Concepts
    • Restoring and Recovering
    • Instance Failure and Instance/Crash Recovery
    • Media Failure
    • Complete Recovery (Overview)
    • Point-in-Time Recovery (Overview)
    • Recovery Through RESETLOGS
  11. Performing Recovery, Part 1
    • RMAN Recovery in NOARCHIVELOG Mode
    • Performing Complete Recovery (of critical and noncritical data files)
    • Restoring ASM Disk Groups
    • Recovery with Image Files
    • Performing Point-in-Time (PITR) or Incomplete Recovery
    • Table Recovery from Backups
  12. Performing Recovery, Part 2
    • Recovery of Server Parameter File, Control File
    • Redo Log File Loss and Recovery
    • Password Authentication File Re-creation
    • Index, Read-Only Tablespace, and Tempfile Recovery
    • Restoring the Database to a New Host
    • Disaster Recovery
    • Restoring RMAN Encrypted Backups
  13. RMAN and Oracle Secure Backup
    • Oracle Secure Backup Overview
    • Oracle Database Disk and Tape Backup Solution
    • Backing Up the Fast Recovery Area to Tape
    • Defining Retention for RMAN Backups
    • RMAN and Oracle Secure Backup Basic Process Flow
    • Integration with Cloud Control
    • RMAN Database Backup to Tape
  14. Performing Tape Backups and Restores
    • Scheduling Backups with EM
    • Oracle-Suggested Backup
    • RMAN and OSB Process Flow
    • RMAN and Oracle Secure Backup Jobs
    • Managing Database Tape Backups
    • Performing Database Recovery
    • RMAN Automatic Failover to Previous Backup
  15. Using Flashback Technologies
    • Flashback Technology: Overview and Setup
    • Using Flashback Technology to Query Data
    • Flashback Table
    • Flashback Transaction (Query and Backout)
    • Flashback Drop and the Recycle Bin
    • Flashback Data Archive
  16. Using Flashback Database
    • Flashback Database Architecture Configuring Flashback Database Performing Flashback Database Best Practices for Flashback Database
  17. Managing Backup Space or Transporting Data
    • Transporting Tablespaces
    • Transporting Databases
  18. Duplicating a Database
    • Using a Duplicate Database
    • Choosing Database Duplication Techniques
    • Creating a Backup-up Based Duplicate Database
    • Understanding the RMAN Duplication Operation
    • Using Cloud Control to Clone a Database
  19. RMAN Performance and Tuning
    • Tuning Principles
    • RMAN Multiplexing
    • Diagnosing Performance Bottlenecks
    • Restore and Recovery Performance Best Practices
  20. Backup and Recovery Workshop
    • Workshop Structure
    • Workshop Approach to Solving Failure Scenarios
    • Business Requirements for Database Availability and Procedures
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje


Recommended Related Training Courses:

  • Oracle Database 12c: Global Data Services
  • Oracle WebLogic Server 12c: Administration I
  • Oracle Database 12c: Data Guard Administration
  • Oracle Database 12c: Performance Management and Tuning NEW
  • Oracle Database 12c: Clusterware Administration
  • Oracle WebLogic Server 12c: Administration II
Poziom trudności
Czas trwania 5 dni
Zobacz więcej szkoleń Oracle

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

Cena szkolenia

  • Forma szkolenia: stacjonarne


Czytaj więcej o ctab

Czas trwania

5 dni

Dostępne terminy