[vc_row][vc_column][thim-heading title=”Oracle Database 12c: Backup And Recovery” line=””][vc_tta_tabs][vc_tta_section title=”Objectives” tab_id=”1499000133846-29206f2f-f06a”][vc_column_text]Upon Completion Of this Course you will have good understanding on:

  • Develop appropriate backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape
  • Learn How to perform complete recovery without data loss
  • Learn How to perform incomplete recovery ie with data loss.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Topics” tab_id=”1498238586529-5e633eb6-2d3f”][vc_column_text]Introduction

  • Assess your Recovery Requirements
  • Categories of failures
  • Oracle Backup and Recovery Solutions
  • Oracle Maximum Availability Architecture
  • Benefits of using Oracle Data Guard


Getting Started

  • Core Concepts of the Oracle Database, Critical for Backup and Recovery
  • Oracle DBA Tools for Backup and Recovery
  • Connecting to Oracle Recovery Manager (RMAN)
  • Quick Start: A Problem-Solution Approach


Configuring for Recoverability

  • RMAN commands
  • Configuring and managing persistent settings
  • Using the Fast Recovery Area (FRA)
  • Control File
  • Redo Log File
  • Archiving Logs


Using the RMAN Recovery Catalog

  • Creating and Configuring the Recovery Catalog
  • Managing Target Database Records in the Recovery Catalog
  • Using RMAN Stored Scripts
  • Maintaining and Protecting the Recovery Catalog
  • Virtual Private Catalogs


Backup Strategies and Terminology

  • Backup Solutions Overview and Terminology
  • Balancing Backup and Restore Requirements
  • Backing Up Read-Only Tablespaces
  • Best Practices for Data Warehouse Backups
  • Additional Backup Terminology


Performing Backups

  • RMAN Backup Types
  • Incrementally Updated Backups
  • Fast Incremental Backup
  • Block Change Tracking
  • Oracle-Suggested Backup
  • Reporting on Backups
  • Managing Backups


Improving Your Backups

  • Compressing Backups
  • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
  • Creating and Managing Archival Backups
  • Backing Up Recovery Files
  • Backing Up the Control File to a Trace File
  • Cataloging Additional Backup Files
  • Backing Up ASM Disk Group Metadata


Using RMAN-Encrypted Backups

  • Creating RMAN-Encrypted Backups
  • Using Transparent-Mode Encryption
  • Using Password-Mode Encryption
  • Using Dual-Mode Encryption


Diagnosing Database Failures

  • Reducing Problem Diagnosis Time
  • Automatic Diagnostic Repository
  • Interpreting RMAN Message Output and Error Stacks
  • Data Recovery Advisor
  • Diagnosing Data File Loss (file system and ASM)
  • Handling Block Corruption


Restore and Recovery Concepts

  • Restoring and Recovering
  • Instance Failure and Instance/Crash Recovery
  • Media Failure
  • Complete Recovery (Overview)
  • Point-in-Time Recovery (Overview)
  • Recovery Through RESETLOGS


Performing Recovery, Part 1

  • RMAN Recovery in NOARCHIVELOG Mode
  • Performing Complete Recovery (of critical and noncritical data files)
  • Restoring ASM Disk Groups
  • Recovery with Image Files
  • Performing Point-in-Time (PITR) or Incomplete Recovery
  • Table Recovery from Backups


Performing Recovery, Part 2

  • Recovery of Server Parameter File, Control File
  • Redo Log File Loss and Recovery
  • Password Authentication File Re-creation
  • Index, Read-Only Tablespace, and Tempfile Recovery
  • Restoring the Database to a New Host
  • Disaster Recovery
  • Restoring RMAN Encrypted Backups


Using Flashback Technologies

  • Flashback Technology: Overview and Setup
  • Using Flashback Technology to Query Data
  • Flashback Table
  • Flashback Transaction (Query and Backout)
  • Flashback Drop and the Recycle Bin
  • Flashback Data Archive


Using Flashback Database

  • Flashback Database Architecture
  • Configuring Flashback Database
  • Performing Flashback Database
  • Best Practices for Flashback Database


Managing Backup Space or Transporting Data

  • Transporting Tablespaces
  • Transporting Databases


Duplicating a Database

  • Using a Duplicate Database
  • Choosing Database Duplication Techniques
  • Creating a Backup-up Based Duplicate Database
  • Understanding the RMAN Duplication Operation
  • Using Cloud Control to Clone a Database


RMAN Performance and Tuning

  • Tuning Principles
  • RMAN Multiplexing
  • Diagnosing Performance Bottlenecks


Backup and Recovery Workshop

  • Workshop Structure
  • Workshop Approach to Solving Failure Scenarios
  • Business Requirements for Database Availability and Procedures

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Duration” tab_id=”1499002323244-d633bd72-5b3c”][vc_column_text]Duration of the course : 30 hrs

Please note :

  • This is the approximate duration .We love more discussion with students and ┬ádepending on the interaction , the duration may increase
  • This is the time for the class delivery . Please reserve more ┬átime for your practice

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Prerequisite ” tab_id=”1499003837802-98134766-f676″][vc_column_text]Course Prerequisite

  • Good Understanding on Oracle Database Concepts
  • Good Understanding on Linux OS and Commands

Recommended Prerequisite Courses

  • Oracle 12c Database Administration
  • Linux Operating System For DBAs

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Materials” tab_id=”1498238586589-176de701-7b7a”][vc_column_text]This Training is an instructor led training . Along with training we will give the following study materials ,which are provided via our elearning portal

  • ┬áVideo Tutorials
  • Student guide
  • PowerPoint Presentations

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Lab Facility” tab_id=”1498239023279-143db322-9807″][vc_column_text]

  • We provide individual lab servers for our students .
  • They students can access the lab for 2 months even after completion of the class
  • We also help students in setting up their laptop / desktop for study purpose

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Schedule ” tab_id=”1498239230065-92ecb939-5380″][thim-list-events layout=”layout-2″ text_link=”View All Events”][/vc_tta_section][/vc_tta_tabs][/vc_column][/vc_row]

[vc_row][vc_column][vc_empty_space height="70px"][/vc_column][/vc_row]

!create support for students

[vc_row][vc_column][vc_cta h2="Have a Doubt.?" h2_font_container="font_size:18|color:%23a100ff" h2_google_fonts="font_family:Vidaloka%3Aregular|font_style:400%20regular%3A400%3Anormal" shape="round" style="custom" add_button="bottom" btn_title="Create Support Ticket" btn_color="danger" use_custom_fonts_h2="true" btn_link="url:https%3A%2F%2Fwww.wysheid.com%2Fcreate-support-ticket%2F||target:%20_blank|" css=".vc_custom_1533631526787{border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;border-left-color: #303030 !important;border-right-color: #303030 !important;border-top-color: #303030 !important;border-bottom-color: #303030 !important;}" custom_background="#fff7f7"]Our Expert Team can help you.Click below Button to Create a support ticket[/vc_cta][/vc_column][/vc_row]

!Addition Help

[vc_row][vc_column][vc_cta h2="Looking for Additional Help .?" h2_font_container="font_size:16.5|color:%230800ff" h2_google_fonts="font_family:Vidaloka%3Aregular|font_style:400%20regular%3A400%3Anormal" shape="round" style="custom" add_button="bottom" btn_title="Contact Support" btn_color="danger" btn_shape="round" use_custom_fonts_h2="true" btn_link="url:https%3A%2F%2Fwww.wysheid.com%2Fproduct%2Fdatabase-support-one-month-trial-access%2F||target:%20_blank|" css=".vc_custom_1531740256100{border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;border-left-color: #303030 !important;border-right-color: #303030 !important;border-top-color: #303030 !important;border-bottom-color: #303030 !important;}" custom_background="#fff7f7"]Our Expert team may help you .Click below Button to Create a support ticket[/vc_cta][/vc_column][/vc_row]

!additional help logged in

[vc_row][vc_column][vc_cta h2="Looking For Additional Help.?" h2_font_container="font_size:16.5|color:%23a100ff" h2_google_fonts="font_family:Vidaloka%3Aregular|font_style:400%20regular%3A400%3Anormal" shape="round" style="custom" add_button="bottom" btn_title="Enroll For Support" btn_color="danger" use_custom_fonts_h2="true" btn_link="url:https%3A%2F%2Fwww.wysheid.com%2Fproduct%2Fdatabase-support-one-month-trial-access%2F||target:%20_blank|" css=".vc_custom_1531739931871{border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;border-left-color: #303030 !important;border-right-color: #303030 !important;border-top-color: #303030 !important;border-bottom-color: #303030 !important;}" custom_background="#fff7f7"]Our Expert Team can help you.Click below Button to Create a support ticket[/vc_cta][/vc_column][/vc_row]

! learn from expert

[vc_row css=".vc_custom_1529677765264{margin-top: -2px !important;margin-right: 0px !important;margin-bottom: 0px !important;margin-left: 0px !important;border-top-width: 0px !important;border-right-width: 0px !important;border-bottom-width: 0px !important;border-left-width: 0px !important;padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}"][vc_column][vc_cta h2="Learn From Experts" h2_font_container="font_size:16.5|color:%237f00ff" h2_google_fonts="font_family:Vidaloka%3Aregular|font_style:400%20regular%3A400%3Anormal" shape="round" style="custom" add_button="bottom" btn_title="Enroll Today" btn_color="danger" btn_shape="round" use_custom_fonts_h2="true" btn_link="url:https%3A%2F%2Fwww.wysheid.com%2Fselflearningpremiumcourses%2F||target:%20_blank|" css=".vc_custom_1531739555445{margin-top: 0px !important;margin-right: 0px !important;margin-bottom: 0px !important;margin-left: 0px !important;border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;border-left-color: #3d3d3d !important;border-left-style: none !important;border-right-color: #3d3d3d !important;border-right-style: none !important;border-top-color: #3d3d3d !important;border-top-style: none !important;border-bottom-color: #3d3d3d !important;border-bottom-style: none !important;}" custom_background="#fff7f7"]Our courses will help you to take the

career to next level[/vc_cta][/vc_column][/vc_row]

Custom Space

[vc_row][vc_column][vc_empty_space height="5px"][/vc_column][/vc_row]