Detailed Course Outline
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