Oracle Database 12c: Backup and Recovery Workshop - Seminar / Kurs von PROTRANET GmbH

Dieser Oracle Database 12c: Backup and Recovery Workshop vermittelt Ihnen folgenden Kenntnisse: - Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure. - Describe the Oracle Database architecture components related to backup and recovery operations. - Plan effective backup and recovery procedures. - Configure the database for recoverability. - Use Recovery Manager (RMAN) to create backups and perform recovery operations. - Use the Data Recovery Advisor to diagnose and repair failures. - Use Oracle Flashback Technologies to recover from human error. - Perform an encrypted database backup and restore. - Perform tablespace point-in-time recovery. - Describe additional high availability features such as Oracle Data Guard.

Die Trainings-Schwerpunkte werden nach Ihrem persönlichen Beratungsgespräch festgelegt. In diesem Oracle Training sind folgende Themen vorgesehen: 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 ArchitectureGetting 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 ApproachConfiguring for Recoverablility - RMAN commands - Configuring and managing persistent settings - Using the Fast Recovery Area (FRA) - Control File - Redo Log File - Archiving LogsUsing 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 CatalogsBackup 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 TerminologyPerforming Backups - RMAN Backup Types - Incrementally Updated Backups - Fast Incremental Backup - Block Change Tracking - Oracle-Suggested Backup - Reporting on Backups - Managing BackupsImproving 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 MetadataUsing RMAN-Encrypted Backups - Creating RMAN-Encrypted Backups - Using Transparent-Mode Encryption - Using Password-Mode Encryption - Using Dual-Mode EncryptionDiagnosing 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 CorruptionRestore and Recovery Concepts - Restoring and Recovering - Instance Failure and Instance/Crash Recovery - Media Failure - Complete Recovery (Overview) - Point-in-Time Recovery (Overview) - Recovery Through RESETLOGSPerforming 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 BackupsPerforming 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 BackupsRMAN 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 TapePerforming 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 BackupUsing 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 ArchiveUsing Flashback Database - Flashback Database Architecture - Configuring Flashback Database - Performing Flashback Database - Best Practices for Flashback DatabaseManaging Backup Space or Transporting Data - Transporting Tablespaces - Transporting DatabasesDuplicating 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 DatabaseRMAN Performance and Tuning - Tuning Principles - RMAN Multiplexing - Diagnosing Performance Bottlenecks - Restore and Recovery Performance Best PracticesBackup and Recovery Workshop - Workshop Structure - Workshop Approach to Solving Failure Scenarios - Business Requirements for Database Availability and Procedures