The objectives for this course are as follows:

• 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.

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

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

Certification Examination

This course is applicable to certification training as an Oracle Database 12c Administrator Certified Professional (OCP) for "Exam 1Z1-063 Oracle Database 12c: Advanced Administration" and certification training as an Oracle Certified Implementation Specialist for "Exam 1Z0-497 Oracle Database 12c: Essentials".

Suggested Next Course

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

• ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE
• ORACLE DATABASE 12C: ADVANCED ADMINISTRATION & ASM

Oracle Training Course duration

5 Days

Oracle Training Course outline

GETTING STARTED: ABOUT DATABASE FAILURE & RECOVERY

• BACKUP & RECOVERY FACILITIES
• 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 CHECKLISTOracle Database 12c: Backup & Recovery Workshop

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 & CONTROLOracle Database 12c: Backup & Recovery Workshop
• 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

---

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