Oracle Database 12c Backup and Recovery Workshop 2.0 Training & Placements in Chennai "ISQL Global"

Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
(Course materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.
Learn To:

• Developappropriate backup and recovery procedures to address yourbusiness needs.
• Implementbackup and recovery settings and perform backup operations to diskand tape.
• EmployOracle database recovery procedures to recover from media andother failures.
• Diagnose and repair data failures.
• Useflashback technologies and data duplication to complement backupand recovery procedures.
• Securethe availability of your database by appropriate backup andrecovery strategies.

The student benefits by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail.Students gain knowledge of the Recovery Manager (RMAN) command line interface for various backup, failure, restore, and recovery scenarios, including tape backup and data duplication. (Familiarity with basic database tools and utilities, such as, SQL*Plus, is assumed.) Hands-On Lessons Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies.After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.
Prerequisites
Suggested Prerequisite

• Knowledgeof Oracle Database 12c
• Knowledgeof SQL and PL/SQL (for DBA use)

Required Prerequisite

• Oracle Database 12c R2: Install and Upgrade Workshop
• Oracle Database 12c R2: Administration Workshop Ed 3
• Using Oracle Enterprise Manager Cloud Control 13c Ed 1

Audience

• Database Administrators
• Database Administrators
• Support Engineer
• Support Engineer
• Technical Consultant
• Technical Administrator
• Technical Administrator
• DataWarehouse Administrator
• DataWarehouse Administrator
• DataWarehouse Administrator

Course Objectives

• UseOracle Flashback Technologies to recover from human error
• Userecovery Manager (RMAN) to create backups and perform recoveryoperations
• Use the Data Recovery Advisor to diagnose and repair failures
• Planeffective backup and recovery procedures
• Describe the Oracle Database architecture components related to backup andrecovery operations
• Performan encrypted database backup and restore
• Performtablespace point-in-time recovery
• Configurethe database for recoverability
• DescribeCloud Tooling for Backup and Recovery
• DescribeOracle Database backup methods and recovery operations that can beused to resolve database failure

Course Topics
Introduction

• OracleMaximum Availability Architecture
• Oracle Secure Backup
• BasicWorkshop Architecture
• Oraclebackup and recovery solutions
• CurriculumContext
• Categoriesof failures
• Benefitsof using Oracle Data Guard
• Assessyour recovery requirements

Getting Started

• Oracle DBA Tools for Backup and Recovery
• Connecting to Oracle Recovery Manager (RMAN)
• QuickStart: A Problem-Solution Approach
• CoreConcepts of the Oracle Database, critical for Backup and Recovery

Configuring for Recoverablility

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

Using the RMAN Recovery Catalog

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

Backup Strategies and Terminology

• AdditionalBackup Terminology
• Backing Up Read-Only Table spaces
• BackupSolutions Overview and Terminology
• DataWarehouse Backup and Recovery: Best Practices
• Balancing Backup and Restore Requirements

Performing Backups

• RMAN Backup Types
• Oracle-SuggestedBackup
• Reporting on Backups
• BlockChange Tracking
• FastIncrement al Backup
• Increment allyUpdated Backups
• Managing Backups

Improving Your Backups

• Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets andBackups of Backup Sets
• Creating and Managing Archival Backups
• Cataloging Additional Backup Files
• Compressing Backups
• Backup and Restore for Very Large Files
• Backing Up Recovery Files
• Backing Up the Control File to a Trace File
• Using a Media Manager

Using RMAN-Encrypted Backups

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

Diagnosing Failures

• Automatic Diagnostic Repository
• Handling Block Corruption
• Reducing Problem Diagnosis Time
• DataRecovery Advisor

Restore and Recovery Concepts

• CompleteRecovery (Overview)
• InstanceFailure and Instance/Crash Recovery
• Restoring and Recovering
• Point-in-TimeRecovery (Overview)
• Recoverywith the RESETLOGS Option
• MediaFailure

Performing Recovery, Part I

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

Performing Recovery, Part II

• Redo Log File Loss and Recovery
• Restoring RMAN Encrypted Backups
• Recoveryof Server Parameter File, Control File (One and All)
• Restoring the Database to a New Host
• DisasterRecovery
• Index,Read-Only Tablespace, and Tempfile Recovery
• PasswordAuthentication File Re-creation

RMAN and Oracle Secure Backup

• Configuring Oracle Secure Backup for RMAN
• RMAN Backup and Restore Operations
• RMANand OSB: Overview and Basic Process Flow
• Displaying OSB log files and transcripts for RMAN activities
• Starting with Oracle Secure Backup
• Oracle Secure Backup Jobs
• Oracle Secure Backup Overview and Interface Options

Using Flashback Technologies

• Using Flashback Technology to Query Data
• Flashback Drop and the Recycle Bin
• FlashbackTransaction (Query and Backout)
• FlashbackTechnology: Overview and Setup
• FlashbackTable
• FlashbackData Archive

Using Flashback Database

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

Transporting Data

• Transporting Data Across Platforms
• DatabaseTransport: Using Data Files
• Transporting Data with Backup Sets

Performing Point-in-Time Recovery

• Performing RMAN TS Point-in-time Recovery
• Whento use TSPITR
• Recovering Tables from Backups
• TSPITRArchitecture

Duplicating a Database

• Duplicating Database with push anpull techniques
• Understanding the RMAN Duplication Operation
• Choosing Database Duplication Techniques
• Creating a Backup-up Based Duplicate Database
• Using a Duplicate Database

RMAN Trouble shooting and Tuning

• Interpreting RMAN Message Output
• Tuning Principles
• RMAN Multiplexing
• Diagnosing Performance Bottlenecks
• Restore and Recovery Performance Best Practices

Cloud Tooling for Backup and Recovery

• Customize Backup Configuration
• BackupDestinations
• Installing the Backup Module
• OracleBackup Cloud Service
• On-DemandBackup and Recovery

Backup and Recovery Workshop

• WorkshopStructure and Approach
• Diagnosing the Failures
• BusinessRequirements for Database Availability and Procedures