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 - SQL STAR)
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.
- Diagnoseand 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 carryit 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
- UsingOracle Enterprise Manager Cloud Control 13c Ed 1
Audience
- Database Administrators
- Support Engineer
- Technical Consultant
- Technical Administrator
- Data Warehouse Administrator
- Data Warehouse Administrator
Course Objectives- Use Oracle 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
- Configure the 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
- OracleSecure Backup
- BasicWorkshop Architecture
- Oraclebackup and recovery solutions
- CurriculumContext
- Categoriesof failures
- Benefitsof using Oracle Data Guard
- Assessyour recovery requirements
Getting
Started- OracleDBA 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- ControlFile
- RMANcommands
- Using the Fast Recovery Area (FRA)
- ArchivingLogs
- Configuring and managing persistent settings
- RedoLog File
Using
the RMAN Recovery Catalog- Creating and Configuring the Recovery Catalog
- UsingRMAN 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 Tablespaces
- BackupSolutions Overview and Terminology
- Data Warehouse Backup and Recovery: Best Practices
- BalancingBackup and Restore Requirements
Performing
Backups- RMANBackup Types
- Oracle-SuggestedBackup
- Reportingon Backups
- BlockChange Tracking
- FastIncremental Backup
- IncrementallyUpdated Backups
- Managing Backups
Improving
Your Backups- CreatingRMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets andBackups of Backup Sets
- Creating and Managing Archival Backups
- CatalogingAdditional Backup Files
- CompressingBackups
- Backupand 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
- CreatingRMAN-Encrypted Backups
Diagnosing
Failures- AutomaticDiagnostic Repository
- HandlingBlock 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- RMANRecoveryin NOARCHIVELOG Mode
- Performing Point-in-Time (PITR) or Incomplete Recovery
- Recoverywith Image Files
- Performing Complete Recovery (of critical and noncritical data files)
- RestoringASM Disk Groups
Performing
Recovery, Part II- RedoLog File Loss and Recovery
- RestoringRMAN 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- ConfiguringOracle Secure Backup for RMAN
- RMANBackup and Restore Operations
- RMANand OSB: Overview and Basic Process Flow
- DisplayingOSB log files and transcripts for RMAN activities
- Startingwith Oracle Secure Backup
- OracleSecure Backup Jobs
- OracleSecure Backup Overview and Interface Options
Using
Flashback Technologies- Using Flashback Technology to Query Data
- FlashbackDrop and the Recycle Bin
- FlashbackTransaction (Query and Backout)
- FlashbackTechnology: Overview and Setup
- FlashbackTable
- FlashbackData Archive
Using
Flashback Database- Configuring Flashback Database
- FlashbackDatabase Architecture
- BestPractices for Flashback Database
- Performing Flashback Database
Transporting Data- Transporting Data Across Platforms
- Database Transport: 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 Troubleshooting and Tuning- InterpretingRMAN Message Output
- Tuning Principles
- RMANMultiplexing
- Diagnosing Performance Bottlenecks
- Restoreand Recovery Performance Best Practices
Cloud
Tooling for Backup and Recovery- CustomizeBackup Configuration
- BackupDestinations
- Installing the Backup Module
- OracleBackup Cloud Service
- On-DemandBackup and Recovery
Backup
and Recovery Workshop- WorkshopStructure and Approach
- Diagnosing the Failures
- Business Requirements for Database Availability and Procedures