Oracle Database 12c Backup and Recovery E-Learning Training

Bestel deze unieke E-Learning Oracle Database 12c Backup and Recovery cursus online!
✔️ 1 jaar 24/7 toegang tot uitgebreide interactieve video's, spraakopdrachten en praktische oefeningen.
✔️ Voortgangsbewaking door middel van rapporten en tests per onderwerp om direct je kennis te toetsen.
✔️ Inclusief certificaat van deelname na afronding van de cursus.

Waarom kiezen voor deze opleiding?

Back-up en herstel zijn cruciale onderdelen van databasebeheer, en Oracle Database 12c biedt krachtige tools en technieken om deze processen te optimaliseren. Deze training biedt een uitgebreide en praktische benadering van back-up- en herstelmethoden, zodat je klaar bent om je databaseomgeving effectief te beheren en beschermen.

Wat je zult leren:

• RMAN in detail: Hoe je Recovery Manager (RMAN) gebruikt voor verschillende soorten back-ups en herstelbewerkingen.
• Probleemoplossing: Identificeer en los problemen op die kunnen optreden tijdens back-up- en herstelprocessen.
• Afstemming van RMAN: Optimaliseer RMAN-bewerkingen voor betere prestaties en efficiëntie.
• Database duplicatie en transport: Leer hoe je databases kunt dupliceren en transporteren met behulp van Oracle Database 12c.
• Oracle Secure Backup: Ontdek hoe je Oracle Secure Backup kunt gebruiken om je back-ups beter te beveiligen en te beheren.

Wie zou moeten deelnemen?

Deze cursus is speciaal ontworpen voor:

• Databasebeheerders (DBA's) die verantwoordelijk zijn voor het onderhouden en beveiligen van Oracle Database 12c omgevingen.
• IT-professionals die hun vaardigheden in databasebeheer willen uitbreiden.
• Systeembeheerders die willen leren hoe ze efficiënte back-up- en herstelstrategieën kunnen implementeren.
• Oracle-certificeringskandidaten die zich voorbereiden op certificering in Oracle Database 12c beheer.
• Bedrijfseigenaren en managers die willen begrijpen hoe ze hun bedrijfsgegevens beter kunnen beschermen tegen verlies of schade.

Cursusinhoud

Backup and Recovery Solutions

Course: 28 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

The Oracle Database Architecture

Course: 43 Minutes

• The Oracle Database Server Architecture
• Process Architecture
• The Grid Infrastructure for a Stand-alone Server
• Exploring the Oracle Database Architecture
• Oracle Restart and DBA Tools
• Backing up a Database Using RMAN in NOARCHIVELOG Mode
• Performing Recovery of a Database in NOARCHIVELOG Mode

Configuring RMAN and Files for Recovery

Course: 36 Minutes

• Configuring Persistent RMAN Settings
• Setting the Retention Policy in RMAN
• Using the Fast Recovery Area
• Configuring the Fast Recovery Area
• Sizing and Managing the Fast Recovery Area
• Multiplexing Control Files
• Multiplexing Redo Log Files
• Creating Archived Redo Log Files

RMAN Recovery Catalog

Course: 38 Minutes

• Overview of the RMAN Recovery Catalog
• Creating the Recovery Catalog to Store Repository Data
• Managing Target Databases in the RMAN Recovery Catalog
• Configuring Cloud Control to Use RMAN Catalog
• RMAN Recovery Catalog Resynchronization
• Using RMAN Stored Scripts
• Backing up the RMAN Recovery Catalog
• Virtual Private RMAN Catalogs

Practice: Configuring for Recoverability

Course: 5 Minutes

• Exercise: Configure RMAN and the Recovery Catalog

Backup Strategies and Terminology

Course: 34 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

Performing Backups

Course: 37 Minutes

• Overview of the RMAN Backup Types
• Creating Incremental, Updated, and Fast Backups
• Maintaining and Monitoring Block Change Tracking
• Oracle-Suggested Backups
• Reporting on Backups Using RMAN and Dynamic Views
• Managing Backups Using Cross-Checking and Deleting
• Creating an Incremental Backup Strategy

Improving Backups

Course: 25 Minutes

• Backup Compression
• Use Media Manager
• Backup and Restore Very Large Files
• Proxy, Duplexed, and Backup Sets in Oracle Database 12c
• Creating and Managing Archival Backups
• Backing up Recovery, Control, and Other Database Files

RMAN-Encrypted Backups

Course: 15 Minutes

• RMAN-Encrypted Backups Overview
• Using Transparent-Mode Encryption
• Using RMAN Password and Dual-Mode Encryption
• Restoring an Encrypted Backup

Practice: Performing and Managing Backups

Course: 5 Minutes

• Exercise: Performing Backups using RMAN

Diagnosing Failures

Course: 51 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

Practice: Diagnosing and Repairing Failures

Course: 5 Minutes

• Exercise: Diagnose and Repair Database Failures

Restore and Recovery Concepts

Course: 20 Minutes

• File Loss and Data Repair
• Overview of the Restoring and Recovering Commands
• Understanding Instance Recovery in Oracle Database 12c
• Tuning Instance Recovery and Using MTTR
• Complete and Incomplete Recovery

Practice: Restoring and Recovering Concepts

Course: 5 Minutes

• Exercise: Identify Restore and Recovery Concepts

Performing Recovery

Course: 46 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

Performing Advanced Recovery

Course: 54 Minutes

• Recovering a SPFILE
• Recovering Control Files
• Restoring and Recovering from the Loss of Control Files
• Recovering from the Loss of Redo Log Files
• Recovering from the Loss of Redo Log Groups
• Restoring the Password File
• Recovering Tablespaces and Tempfiles
• Recover and Restore a 12c Database to a New Host
• Performing Disaster Recovery
• Restore Encrypted Backups

Practice: Performing Database Recovery

Course: 1 Minute

• Exercise: Perform Recovery of Databases

Oracle Secure Backup

Course: 27 Minutes

• RMAN and Oracle Secure Backup Integration Overview
• Installing Oracle Secure Backup
• Configuring Oracle Secure Backup for RMAN
• Oracle Secure Backup Jobs and the Obtool Commands
• Configuring OSB and Performing a Backup

Practice: Installing and Configuring OSB

Course: 1 Minute

• Exercise: Install and Configure OSB

Flashback Query, Table, and Transaction Query

Course: 46 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

Flashback Data Archives and Temporal Data

Course: 25 Minutes

• Creating Temporal History and Enabling Archiving
• Identifying the Flashback Data Archive Process
• Understanding Transparent and Full Schema Evolution
• Using Temporal Validity and History in a Database Table
• Filtering on Valid-Time Columns in a Database Table

Use Flashback Database

Course: 32 Minutes

• Understanding the Flashback Database Feature
• Configuring Flashback Database
• Flashing Back a Database Using Flashback Database
• Understand the Flashback Database Considerations
• Monitoring Flashback Database Information
• Using Restore Points with Flashback Database
• Best Practices for Using the Flashback Database Feature

Practice: Performing Oracle Flashback

Course: 5 Minutes

• Exercise: Use Oracle Flashback Technologies

Transporting Data

Course: 35 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 Transportation
• Performing Database Transportation with Backup Sets
• Performing Tablespace Transportation

Practice: Performing Data Transport

Course: 7 Minutes

• Exercise: Transport Data, Databases, and Tablespaces

Tablespace Point-in-Time Recovery

Course: 24 Minutes

• Overview of Point-in-Time Recovery
• Overview of the TSPITR Architecture
• Preparing to Perform TSPITR
• Performing Fully Automated TSPITR
• Performing TSPITR Using an Auxiliary Instance
• Troubleshooting RMAN TSPITR

Table Recovery

Course: 16 Minutes

• Overview of Table Recovery from Backups
• The Process of How to Perform Table Recovery
• Recovering a Table from a Backup

Practice: Performing TSPITR and Table Recovery

Course: 7 Minutes

• Exercise: Performing TSPITR and Table Recovery

Duplicating Databases

Course: 49 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

Practice: Performing Database Duplication

Course: 5 Minutes

• Exercise: Duplicating Oracle 12c Databases

Troubleshooting and Tuning RMAN

Course: 44 Minutes

• Interpreting RMAN Messages and Error Stacks
• Understand How RMAN Commands are Processed
• Use SBTTEST and Identify RMAN Problems
• Diagnose Performance Bottlenecks Read Operations
• Diagnose Performance Bottlenecks Write Operations
• Use Dynamic Views and Monitoring RMAN Jobs
• Asynchronous and Synchronous I/O Bottlenecks in RMAN
• Understand the Steps to Tune RMAN Backup Performance
• Parallelization of Backup Sets for Performance
• Set the LARGE_POOL_SIZE for Performance
• Configure RMAN Multiplexing to Improve Performance
• Best Practices for Restore and Recovery Performance

Practice: Troubleshooting and Tuning RMAN

Course: 5 Minutes

• Exercise: Troubleshoot and Tune RMAN Operations

Ga aan de slag met Oracle Database 12c Backup and Recovery!

✔️ Behaal expertise in databasebeheer met praktische oefeningen en diepgaande video's.
✔️ Test en verbeter je kennis direct met voortgangsrapporten en tests per onderwerp.
✔️ Behaal een certificaat van deelname en versterk je professionele profiel.

Bestel nu jouw cursus en zorg ervoor dat je voorbereid bent op elke uitdaging met Oracle Database 12c!