Oracle Database 12c: Backup & Recovery Workshop

Request more details:

submit request
Description:
All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training course is to assist you in doing just that, and this is one of the most essential modules in the entire Oracle 12c database administrator curriculum. Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, Redo Log File Size Advisor and the MTTR Advisor. Since it can be tempting to short-‐cut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.
Prerequisites:
Specific prerequisites for this course are the following titles, or equivalent experience:
Oracle Database 12C: SQL Fundamentals (Levels I & II)
Oracle Database 12C: Install & Upgrade Workshop
Oracle Database 12C: Architecture & Internals
Oracle Database 12C: Administration Workshop
Objectives:
Automatically managed backup strategies and database recovery operations using RMAN, the Enterprise Manager Cloud Control, and other database facilities.
Database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the MTTR Advisor.
User-‐managed recovery scenarios, including recovery from temporary, read-‐only and index tablespaces.
Complete and incomplete media recovery, including database point-‐in-‐time, tablespace and table point-‐in-‐time recovery.
Configure a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
Optimizing backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
Achieve data preservation through archival backups.
Duplicate and clone databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes.
Tablespace transportation, database transportation, cross-‐platform transportation and endian format conversion.
Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
Newly released or enhanced features such as backup file compression, encryption, parallelization and others.
Recovering from logical failure using appropriate Oracle Flashback technologies, such as Flashback Table, Flashback Drop and Flashback Database.
Getting Started: About Database Failure & Recovery:
Backup & Recovery Facilities
HA & MAA
The Backup Administrator
Backup Storage Technologies
Getting Started: Configure The Database For Recovery:
Manage Redo Data
Manage Archived Redo Data
About The Fast Recovery Area
Recoverability Checklist
Getting Started: Automatic Instance Recovery:
About Instance Recovery
Mean Time To Recover (MTTR)
Instance Recovery Parallelism
Mttr Advisor & Checkpoint Tuning
Redo Logfile Size Advisor
FAST-‐START ON-‐DEMAND Parallelism
BACKUP: CONFIGURE RMAN:
RMAN Architecture
Launch & Use RMAN
Configure RMAN Settings
RMAN Channels
Backup: Perform RMAN Backups:
Consistent VS. Inconsistent Backups
Backup File Types
RMAN Backup Sets
RMAN Image Copies
Full Backups
Incremental Backups
Retention Policies & Obsolete Files
Expired Backup Entries
Rman Backup Reports
Report Unrecoverable
Report Need Backup
List Incarnation
Backup: RMAN Management With EM:
Monitoring The Fast Recovery Area
The EM Interface To RMAN Backup
About Backup Guided Workflows
Schedule Customized Backup
Schedule Oracle-‐Suggested Backup
Manage Current Backups
Backup Reports
Restore Points
Backup Encryption
The RMAN Recovery Catalog:
RMAN Catalog Concepts
Create The Base Catalog
Register A Target Database
Manage The Centralized Catalog
Virtual Private Catalogs
Protection Of The Recovery Catalog
Using RMAN Scripts
Recovery: User-‐Managed Recovery:
Recovery Concepts
Recover Temporary Tablespaces
Recover Read-‐Only Tablespaces
Recover Index Tablespaces
Recover Redo Log Group Member
Recreate The Password File
Recovery: RMAN Recovery:
Complete Recovery
Partial But Complete Recovery
RMAN Failure Diagnosis
Incomplete Recovery
Recovery Using EM
EM User Directed Recovery
EM Oracle Advised Recovery
Decryption During Restore
Advanced: Enhanced RMAN Capabilities:
Backup Optimization
Parallelism With Section Sizes
Backup Performance & Control
Minimize Time Vs. Minimize Load
Archival Backups
Advanced: Database Duplication & Cloning:
Why Perform Database Duplication?
RMAN Duplicate Operation
RMAN Duplicate
Database Cloning With Em
Advanced: Data Transportation:
About Transportation
Read-‐Only TS Transportation
Read-‐Write TS Transportation
Cross-‐Platform TS Transportation
Database Transportation
EM Tablespace Transportation
Advanced: Handling Corruption With Data Recovery Advisor:
Understanding Failure & Corruption
How Does Corruption Occur?
Detecting Corruption
Analyze
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
Recovering From Corruption
Block Media Recovery
Isolating Corruption
DBMS_REPAIR() Units
About ADMIN_TABLES()
About CHECK_OBJECT()
About FIX_CORRUPT_BLOCKS()
About SKIP_CORRUPT_BLOCKS()
About DUMP_ORPHAN_KEYS()
About SEGMENT_FIX_STATUS()
Flashback: About Oracle Flashback Technology:
About Flashback Technology
Flashback & Database Security
Configuration For Flashback
Flashback: Recovery Using Oracle Flashback Technology:
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK TABLE...TO BEFORE DROP
FLASHBACK DATABASE