The Backup and Recovery Curriculum is composed of two courses.
1) A 3 day backup and recovery course which covers all the concepts, architecture and mechanics of backing up and recovering an Oracle database.
2) A Recovery Manager course which covers the architecture and functionality of Oracle's backup and recovery tool (RMAN).
The RMAN course has a 1 day and a 2 day version.
The 1 day version covers the architecture and functionality of RMAN.
The 2nd day covers the extended functionality of RMAN.
Delegates can choose as to whether they attend the 3 day backup and recovery course alone or with the addition of 1 or 2 days of the RMAN course.
Backup and Recovery
This course is designed to give delegates a detailed knowledge of Oracle's Backup and Recover architecture, processes and procedures.
The course contains extensive practical exercises in recovering from various failure scenarios. Each of the possible file failure types is considered in detail. The exercises are all carried out using the command line, together with standard operating system tools and commands. The culmination of the course is a workshop in which the instructor repeatedly breaks the delegate's database and the delegates have to diagnose the problem and recover the database without assistance. After each recovery the method adopted is assessed for its effectiveness, efficiency and appropriateness. At the end of the course delegates should be confident in their ability to design and implement an appropriate backup strategy to support recovery requirements of the business. They should be confident in their ability to recover the database and given the appropriate backup strategy, to do so within a designated recovery window.
Recovery Manager (RMAN)
This course teaches delegates how to use the RMAN tool to perform backups and recovery of an Oracle database. Rman is an extremely rich backup tool and the various types of backups and their options are considered in detail. Rman's restore and recovery capabilities including the new 11g Data Recovery Advisor are also explained in detail.
The course deals with the architecture of Rman and the various configuration options available. Rman is considered both as a stand-alone tool and with the use of a 'recovery catalog'. The creation and configuration of a recovery catalog is covered along with the registering of databases in the recovery catalog. The maintenance of Rman backup data is explained for both catalog and non-catalog environments.
The course covers the use of 'Block Change Tracking' to optimize incremental backups and the use of incremental backups to 'update' an existing 'standby backup'. Combining these two techniques offers a powerful way to minimize both backup and recovery time.
Delegates will be shown how to enable 'Flashback Database' and to use Rman to perform flashback on the database. The course also deals extensively with block corruptions. It covers the tools available for finding block corruptions early and the tools to help deal with the consequences. Foremost of which is Rman's block level media recovery capabilities.
Lastly RMAN's database duplication capabilities are covered. There are various options available within RMAN for duplicating a database and this course covers the three main scenarios.
1) Duplicating a database for a test or development environment
2) Restoring the entire database during a disaster recovery
3) Creating a Standby database clone
Please note this course deals with the establishment of the Standby database clone. It does not cover the configuration and management of a standby database, this is covered in our Data Guard course.
Instance and Media Recovery Structures
Securing Committed Changes
Writing Changed Data Blocks to Data Files
Database Checkpoints
Types of Checkpoints
Recording Changes Written to the Data Files
Control Files and Structural Data
Control Files and Synchronization Data
Database Synchronization
Multiplexed Redo Log Files
Securing a History of Database Changes
Backup and Restoration in No-Archive Mode
NO-ARCHIVE LOG Mode
Restoration in NOARCHIVELOG Mode with Redo Log File Backups
Restoration in NOARCHIVELOG Mode Without Redo Logs Backups
Backup in No-Archivelog Mode
Taking a No-Archivelog Backup
Obtaining Database File Information
Enabling Database Recovery
ARCHIVELOG Mode
Enabling Archiving Mode
Archiving Parameters
Controlling Archiving
Specifying the number of Archive Processes
Specifying the Archive Log Destination
LOG_ARCHIVE_DEST_n Options
Specifying a Minimum Number of Local Destinations
Controlling Availability of Archive Destinations
Setting The Naming Convention for Archive Log Files
Manual Archiving
Obtaining Archive Log Information
Archivelog Mode Backups
Terminology
Backup in Archivelog Mode
Backups: open or closed
Backing up Online logs
Closed Backup in Archivelog Mode
Securing Archive Logs For Disaster Recovery
Open Database Backup: Data Files
Performance Implications of Online Data File Backups
Performing Online Tablespace Backup
Failure During Online Tablespace Backup
Control File Backups
Backing Up the Initialization Parameter File
Backup Issues with LOGGING and NOLOGGING Operations
Managing Non-logged Operations
Read-Only Tablespace Backup
DBVERIFY Command-Line Interface
Data File Recovery
Data File Recovery in Archivelog Mode
The 'RECOVER' Command options
Complete Recovery Scenarios
Complete Recovery of a Closed Database
Closed Database Recovery: Example
Open Database Recovery When the Database Is Closed
Open Database Recovery When the Database Is Open
Re-Creating Lost Data files Without Backup
Restoring Data files to a New Location
Applying Archive Log Files During Recovery
Temp File Recovery
Read-Only Tablespace Recovery
Read-Only Tablespace Recovery Issues
Determining Which Files Need Recovery
Control File Recovery
Recovering Control Files
Recovering from the Loss of a Single Control Files
Recovering from the Loss of all Control Files
Situations Requiring Recreation of the Control Files
Log File Recovery
Loss of Redo Log Member
Loss of Inactive Redo Log Group
Loss of Active Redo Group
Loss of the Current Group (following a clean shutdown)
Loss of the Current Group (resulting in system crash)
Incomplete Recovery (Roll Forward Method)
Incomplete Recovery Overview
Reasons for Performing an Incomplete Recovery
Types of Incomplete Recovery
Incomplete Recovery Guidelines
Incomplete Recovery and the Alert Log
Procedures for Incomplete Recovery
RECOVER Command Overview
Time-Based Recovery: Example
Cancel-Based Recovery: Example
Using a Backup Control File During Recovery
Using a Backup Control File During Recovery
Incomplete Recovery of Tablespaces
Incomplete Recovery (Flashback Methods)
Flashback Database
Flashback Database Architecture
Configuring Flashback Database
Excluding Tablespaces from Flashback Database
Monitoring Flashback Database
Flashback Query
Flashback Versions Query
Flashback Transaction Query
Flashback Table
Performing Flashback Table
Flashback Drop and the Recycle Bin
Recycle Bin
Restoring Tables from the Recycle Bin
Recycle Bin: Automatic Space Reclamation
Recycle Bin: Manual Space Reclamation
Bypassing the Recycle Bin
Querying the Recycle Bin
Querying Data from Dropped Tables
Restore Points
Guaranteed Restore Points
Overview and Configuration
Features of Recovery Manager
Recovery Manager Components
Channel Allocation
Automatic Channel Allocation
Manual Channel Allocation
Media Management
Connection Types with RMAN
Connecting Without a Recovery Catalog
Additional RMAN Command-Line Arguments
Recovery Manager Command Modes
Types of RMAN Commands
The LIST Command
The REPORT Command
The REPORT NEED BACKUP Command
Configuring Persistent Settings for RMAN
The SHOW Command
Control File Auto backups
Managing Persistent Settings
Using a Flash Recovery Area with RMAN
Flash Recovery Area Space Usage
V$FLASH_RECOVERY_AREA_USAGE
Setting Parameters That Affect RMAN
RMAN Usage Considerations
RMAN Backups
RMAN Backup Concepts
Recovery Manager Backups
Image copy
Backup Sets
Characteristics of Backup Sets
Backup Piece
Backup Piece Size
The BACKUP Command
Multiplexed Backup Sets
Parallelization of Backup Sets
Duplexed Backup Sets
Backups of Backup Sets
Archived Redo Log File Backups
Archived Redo Log Backup Sets
Backup Constraints
Compressed Backups
Image Copy
Image Copy Parallelization
Tags for Backups and Image Copies
BACKUP Command Options
Whole Database Backup
RMAN Backup Types
Differential Versus Cumulative
Backup in NOARCHIVELOG Mode
Control File and Server Parameter File Auto backups
Backing Up the Server Parameter File
Block Change Tracking
Enabling Block Change Tracking
Incrementally Updating Backups
RMAN Dynamic Views
Monitoring RMAN Backups
Complete Recovery
Restoration and Recovery
RMAN RESTORE command
RMAN RECOVER command
RMAN Recovery:
Recovering a Database in ARCHIVELOG Mode
Using RMAN to Recover a Tablespace
RESTORE TABLESPACE
RECOVER TABLESPACE
Restore Data files to a New Location
SWITCH command
Recovering a Control File 'Autobackup'
Incomplete Recovery
Performing Incomplete Recovery
Time-Based Recovery
Time-Based: Example
Log Sequence Recovery
Log Sequence: Example
Performing Flashback Database
Time based Flashback
SCN based Flashback
Restore Points and Flashback
Checking the state of the Database
Flashing back and Rolling Forward
Incomplete Recovery and the Alert Log
Data Recovery Advisor
Overview of Data Recovery Advisor
Purpose of Data Recovery Advisor
Basic Concepts of Data Recovery Advisor
User Interfaces to Data Recovery Advisor
Data Integrity Checks
Failure Status
Failure Priority
Failure Grouping
Manual repair Actions
Automatic Repair Options
Consolidated Repairs
Repair Scripts
Supported Database Configurations
Diagnosing and Repairing Failures
Listing Failures
Listing All Failures
Listing a Subset of Failures
Determining Repair Options
Repair Options for All Failures
Repair Options for a Subset of Failures
Repairing Failures
About Repairing Failures
Repairing a Failure
Changing Failure Status and Priority
Checking for Block Corruptions
Validating the database
Dealing with Block Corruptions
What Is Block Corruption?
Block Corruption Symptoms: ORA-01578
How to Handle Corruption
Corruption-Related Features
DBVERIFY Utility
Interpreting DBVERIFY Output
ANALYSE Command
Verifying Block Integrity in Real Time: DB_BLOCK_CHECKING
Verifying Block Integrity in Real Time: DB_BLOCK_CHECKSUM
Using EXP to Detect Corruption
Using Flashback for Logical Corruption
DBMS_REPAIR Package
Using DBMS_REPAIR
Block Media Recovery (BMR)
BLOCKRECOVER Command
Examples of Using BLOCKRECOVER
The RMAN BMR Interface
Alternative Actions
Recovery Catalog
Overview
Recovery Catalog Contents
Benefits of Using a Recovery Catalog
Creating Recovery Catalog
Connecting Using a Recovery Catalog
Recovery Catalog Maintenance
Resynchronization
Using RESYNC CATALOG
Resetting a Database Incarnation
Recovery Catalog Reporting
Viewing the Recovery Catalog
Stored Scripts
Script Examples
Managing Scripts
Backup of Recovery Catalog
Recovering the Recovery Catalog
RMAN Maintenance
Cross Checking Backups and Copies
The CROSSCHECK Command
Deleting Backups and Copies
The DELETE Command
Changing the Availability of Backups and Copies
Exempting a Backup or Copy
The CHANGE Command
The CHANGE 'KEEP' option
Cataloging Archived Redo Log Files
The CATALOG Command
Uncataloging RMAN Records
The CHANGE 'UNCATALOG' option
Duplicating a Database with RMan
How RMan Duplicates a Database
Database Duplication Options
Prerequisites and Restrictions
Generating Files for the Duplicate Database
Creating the Duplicate Control Files
Creating the Duplicate Online Redo Logs
Renaming Data files
Read-Only Tablespaces
OFFLINE NORMAL Tablespaces
Password File for the Auxiliary Instance
Oracle Net Connectivity to the Auxiliary Instance
Parameter File for the Auxiliary Instance
Starting the Auxiliary Instance
Remote Host with the Same Directory Structure
Remote Host with a Different Directory Structure
Creating a Duplicate Database on the Local Host
Performing Disaster Recovery
Restoring the Database to a New Host
Specifying File names on a New Host
Restoring Datafile Copies to a New Host
Determining the SCN for Incomplete Recovery After Restore
Creating a Standby Database
Preparing RMAN to Create a Standby Database
Standby Database Preparation Using RMAN
Creating the Standby Control File with RMAN
Naming the Standby Data files Using RMAN
Naming the Standby Log Files Using RMAN
Creating a Standby Database with RMAN
Creating a Standby Database with Image Copies
Creating a Standby Database: No Recovery
Creating a Standby Database With Recovery