The objective of this training module is to assist you in designing, testing and implementing a robust backup and recovery strategy. Subjects include:

• User-managed and automatically managed backup strategies and database recovery operations using RMAN 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.
• Automatically managed backup strategies and database recovery operations using RMAN and other database facilities. Complete and incomplete media recovery, including database point-in-time recovery and tablespace point-in-time recovery.
• Build upon basic RMAN capabilities with 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.
• Data preservation through archival backups.
• Duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes.
• Detecting and handling failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.

Oracle Training Audience

The primary target audiences for this course are:

• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers

Oracle Training Certification

This course along with its prerequisites cover information necessary to complete the certification test ORACLE DATABASE 11g: ADMINISTRATION II.

Oracle Training 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 R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: ADMINISTRATION I

Suggested Next Courses

Administrators may wish to proceed onto more focused and specialized courses with these modules:

• ORACLE DATABASE 11G R2: GRID INFRASTRUCTURE & ASM
• ORACLE DATABASE 11G R2: PERFORMANCE TUNING
• ORACLE DATABASE 11G R2: SQL TUNING
• ORACLE DATABASE 11G R2: ENCRYPTION & ADVANCED DATA SECURITY
• ORACLE ENTERPRISE MANAGER 11G R2: GRID CONTROL

Oracle Training Course duration

3 Days

Oracle Training Course outline

INSTANCE RECOVERY

• ABOUT INSTANCE RECOVERY
• INSTANCE RECOVERY PARALLELISM
• Changing 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 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
• 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
• 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, SECTION SIZES
• BACKUP PERFORMANCE & CONTROL
• MINIMIZE TIME vs. MINIMIZE LOAD
• ARCHIVAL BACKUPS
• COPYING FILES BETWEEN DATABASES

TRANSPORTING TABLESPACES

• ABOUT TABLESPACE TRANSPORTATION
• READ-ONLY TABLESPACE TRANSPORTATION
• READ-WRITE TABLESPACE TRANSPORT
• 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
• USING THE DATA RECOVERY ADVISOR
• BLOCK MEDIA RECOVERY
• DBMS_REPAIR() ISOLATION

---

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved