Oracle Database 12c Backup and Recovery

Oracle Database 12c Backup and Recovery. 

In dit leertraject wordt besproken en gedemonstreerd hoe back-up- en hersteltechnieken in Oracle Database 12c kunnen worden uitgevoerd. Dit omvat het gebruik van RMAN om de verschillende soorten back-ups en herstelbewerkingen uit te voeren, evenals het oplossen van problemen en het afstemmen van RMAN-bewerkingen. Ook wordt ingegaan op het dupliceren en transporteren van databases en het gebruik van Oracle Secure Backup.

1 jaar 24/7 toegang tot rijke interactieve video's, spraak, oefenopdrachten, voortgangsbewaking door middel van rapporten en tests per onderwerp om de kennis direct te testen. Na afloop van de cursus ontvang je een certificaat van deelname.

Cursusinhoud

Oracle Database 12c - Backup and Recovery: Configuring for Recoverability

Course: 2 Hours, 29 Minutes

• Course Introduction
• Overview of Innovation and Cloud Computing
• Assessing Recovery Requirements
• Identifying the Categories of Failures
• Backup and Recovery Solutions
• Recovery Solutions Architectures
• RMAN, Secure Backup, and Data Guard Overview

Oracle Database 12c - Backup and Recovery: Performing and Managing Backups

Course: 1 Hour, 56 Minutes

• Course Introduction
• Backup and Restore Requirements
• Backup Strategies
• Backup and Recovery Best Practices for Data Warehousing
• Creating Backup Sets and Image Copies
• Creating a Whole Database Backup
• Creating a Backup Schedule in Oracle Database 12c

Oracle Database 12c - Backup and Recovery: Failure and Recovery Concepts

Course: 1 Hour, 21 Minutes

• Course Introduction
• Automatic Diagnostic Workflow
• Using ADRCI and V$DIAG_INFO View for ADR Information
• Interpreting RMAN Error Messages
• Using Data Recovery Advisor in EM Cloud Control
• Using Data Recovery Advisor RMAN Command-Line Interface
• Using Data Recovery Advisor Views
• Diagnose and Repair a Database Failure Using RMAN
• Handling Block Corruption
• Setting Parameters to Detect Block Corruption
• Repairing Block Corruption Using RMAN
• Performing Block Media Recovery
• Overview of the Automatic Block Repair Feature

Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup

Course: 2 Hours, 7 Minutes

• Course Introduction
• Ensuring Backups Are Available to Perform a Restore
• Restoring a Database in NOARCHIVELOG Mode
• Performing Complete Recovery
• Recovering from the Loss of a Data File
• Restoring ASM Disk Groups
• Recovering Image Copies
• Performing Point-in-Time Recovery
  Performing Incomplete Recovery after a Failure

Oracle Database 12c - Backup and Recovery: Using Flashback Technologies

Course: 1 Hour, 47 Minutes

• Course Introduction
• Understanding the Flashback Technologies Available
• Configuring an Oracle 12c Database to Support Flashback
• Using the Flashback Query and Version Query Features
• Understanding the Flashback Table Feature
• Using the Flashback Table Feature
• Understanding the Flashback Transaction Query Feature
• Using the Flashback Transaction Query Feature
• Understanding Flashback Drop and the Recycle Bin
• Restoring a Dropped Table Using Flashback Drop

Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR

Course: 1 Hour, 28 Minutes

• Course Introduction
• Overview of Transporting Data
• Identifying the Endian Format for Conversion
• Transporting Data with Backup Sets and Data Files
• Identifying the Procedure to Transport a Database
• Performing Database Transportation6
• Performing Database Transportation with Backup Sets
• Performing Tablespace Transportation

Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN

Course: 1 Hour, 43 Minutes

• Course Introduction
• The Different Techniques to Duplicate a Database
• The Push and Pull Methods of Duplicating a Database
• Techniques for Duplicating a Database from Backup
• Create the Parameter File for the Auxiliary Instance
• Use Set Newname to Specify New Names for Data Files
• Starting the Auxiliary Instance and Allocating Channels
• Understand the RMAN Duplication Operation
• Understand the RMAN Duplicate Command Options
• Duplicating a Database