Oracle Database 11g: Backup & Recovery

This course has been superseded

We suggest the following instead:
Oracle Database Administration Course

Course Description

This Oracle 11g training course will consider the latest and most advanced elements of a robust backup and recovery strategy for the Oracle database platform. It is intended to allow a database administrator to become certified as a backup and recovery specialist.
5 Days
Contact us for pricing
 

Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these titles:
• ORACLE DATABASE 11g: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: ADMINISTRATION I

RECOVERY CONCEPTS

ABOUT THE BACKUP & RECOVERY STRUCTURES
MANAGING REDO DATA
MANAGING ARCHIVED REDO DATA
CREATING A FOUNDATION FOR SOUND RECOVERY

ORACLE FLASHBACK TECHNOLOGY

ABOUT FLASHBACK TECHNOLOGY
FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
CONFIGURING UNDO MANAGEMENT FOR FLASHBACK
UNDO_RETENTION
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK VERSIONS QUERY
FLASHBACK TRANSACTION QUERY
FLASHBACK TRANSACTION BACKOUT

FLASHBACK DATABASE

ABOUT FLASHBACK DATABASE
CONFIGURING THE FLASH RECOVERY AREA
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE

INSTANCE RECOVERY

ABOUT INSTANCE RECOVERY
INSTANCE RECOVERY PARALLELISM
MTTR ADVISOR & TUNING CHECKPOINTS
LOG_CHECKPOINTS_TO_ALERT
REDO LOGFILE SIZE ADVISOR
FAST-START ON-DEMAND PARALLELISM

CONFIGURING RMAN

RMAN ARCHITECTURE
LAUNCH & USE RMAN
CONFIGURE RMAN SETTINGS
ALLOCATE RMAN CHANNELS

BACKUP WITH RMAN

ABOUT BACKUP FILE TYPES
PERFORMING FULL BACKUPS
PERFORMING INCREMENTAL BACKUPS
ESTABLISHING A BACKUP RETENTION POLICY
GENERATE REPORTS
REPORT UNRECOVERABLE
REPORT NEED BACKUP
LIST INCARNATION

RMAN MANAGEMENT WITH EM

MONITORING THE FLASH RECOVERY AREA
THE EM INTERFACE TO RMAN
SCHEDULING RMAN BACKUPS
USING THE ORACLE-SUGGESTED BACKUP STRATEGY
MANAGE CURRENT BACKUPS
BACKUP REPORTS
MANAGE RESTORE POINTS

USER-MANAGED RECOVERY OPERATIONS

RECOVERY CONCEPTS
RECOVER TEMPORARY TABLESPACES
RECOVER READ-ONLY TABLESPACES
RECOVER INDEX TABLESPACES
RECOVER REDO LOG GROUP MEMBER
RECREATE THE PASSWORD FILE

RECOVERY WITH RMAN

COMPLETE MEDIA RECOVERY
INCOMPLETE MEDIA RECOVERY
RECOVERY USING EM

USING THE RMAN RECOVERY CATALOG

UNDERSTANDING CATALOG CONCEPTS
CREATE THE RECOVERY CATALOG
MANAGE VIRTUAL PRIVATE CATALOGS
DATA PROTECTION OF THE RECOVERY CATALOG
USING RMAN SCRIPTS

DATABASE DUPLICATION & CLONING

WHY PERFORM DATABASE DUPLICATION?
RMAN DUPLICATE DATABASE
RMAN DUPLICATE
DATABASE CLONING

ADVANCED RMAN CAPABILITIES

BACKUP OPTIMIZATION
ENHANCING PARALLELISM WITH SECTION SIZES
ARCHIVAL BACKUPS
BACKUP SET ENCRYPTION
COPYING FILES BETWEEN DATABASES

TRANSPORTING TABLESPACES

ABOUT TABLESPACE TRANSPORTATION
READ-ONLY TABLESPACE TRANSPORTATION
READ-WRITE TABLESPACE TRANSPORTATION
TRANSPORT TABLESPACES USING EM

RECOVERING FROM CORRUPTION WITH DATA RECOVERY ADVISOR

HOW DOES CORRUPTION OCCUR?
DETECTING CORRUPTION
ANALYZE
V$DATABASE_BLOCK_CORRUPTION View
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
RECOVERY USING THE DATA RECOVERY ADVISOR
BLOCK MEDIA RECOVERY
ISOLATING CORRUPTION WITH DBMS_REPAIR()
OracleOracle 11gOracle Database 11g