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 Architecture     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     Configuring for Recoverablility- RMAN commands- Configuring and managing persistent settings- Using the Fast Recovery Area (FRA)- Control File- Redo Log File- Archiving Logs     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     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     Performing Backups- RMAN Backup Types- Incrementally Updated Backups- Fast Incremental Backup- Block Change Tracking- Oracle-Suggested Backup- Reporting on Backups- Managing Backups     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     Using RMAN-Encrypted Backups- Creating RMAN-Encrypted Backups- Using Transparent-Mode Encryption- Using Password-Mode Encryption- Using Dual-Mode Encryption     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     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     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     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     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     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     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     Using Flashback Database- Flashback Database Architecture- Configuring Flashback Database- Performing Flashback Database- Best Practices for Flashback Database     Managing Backup Space or Transporting Data- Transporting Tablespaces- Transporting Databases     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     RMAN Performance and Tuning- Tuning Principles- RMAN Multiplexing- Diagnosing Performance Bottlenecks- Restore and Recovery Performance Best Practices     Backup and Recovery Workshop- Workshop Structure- Workshop Approach to Solving Failure Scenarios- Business Requirements for Database Availability and Procedures