title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 12c: Backup and Recovery Workshop
Duration
4 Days
Course
DBOR-962
Available Formats
Classroom Training, Online Training
Course Description
Overview
All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training is to assist you in doing just that.Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, Redo Log File Size Advisor and the MTTR Advisor. Since it can be tempting to short-cut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.
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'.
Objectives
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.
Audience
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Prerequisites
- DBOR-950 and DBOR-951 Oracle Database 12C: SQL Fundamentals (Levels I & II), or equivalent experience
- DBOR-955 Oracle Database 12C: Install & Upgrade Workshop, or equivalent experience
- DBOR-956 Oracle Database 12C: Architecture & Internals, or equivalent experience
- DBOR-957 Oracle Database 12C: Administration Workshop, or equivalent experience
Topics
- Backup & Recovery Facilities
- HA & MAA
- The Backup Administrator
- Backup Storage Technologies
- Manage Redo Data
- Manage Archived Redo Data
- About The Fast Recovery Area
- Recoverability Checklist
- About Instance Recovery
- Mean Time To Recover (MTTR)
- Instance Recovery Parallelism
- Mttr Advisor & Checkpoint Tuning
- Redo Logfile Size Advisor
- FAST-START ON-DEMAND Parallelism
- RMAN Architecture
- Launch & Use RMAN
- Configure RMAN Settings
- RMAN Channels
- 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
- 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
- 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 Concepts
- Recover Temporary Tablespaces
- Recover Read-Only Tablespaces
- Recover Index Tablespaces
- Recover Redo Log Group Member
- Recreate The Password File
- 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
- Backup Optimization
- Parallelism With Section Sizes
- Backup Performance & Control
- Minimize Time Vs. Minimize Load
- Archival Backups
- Why Perform Database Duplication?
- RMAN Duplicate Operation
- RMAN Duplicate
- Database Cloning With Em
- About Transportation
- Read-Only TS Transportation
- Read-Write TS Transportation
- Cross-Platform TS Transportation
- Database Transportation
- EM Tablespace Transportation
- 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()
- About Flashback Technology
- Flashback & Database Security
- Configuration For Flashback
- FLASHBACK TABLE
- FLASHBACK DROP
- FLASHBACK TABLE...TO BEFORE DROP
- FLASHBACK DATABASE
Related Courses
-
Oracle SQL
DBOR-910- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,295.00 USD
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart