Retour en haut de la page

Oracle Database 10g - Backup and Recovery

3 jours - 21 heures

Objectifs

Manage the Oracle Secure Backup environment Monitor and tune Recovery Manager Perform tablespace point-in-time recovery Create a duplicate database Create and manage a recovery catalog database Perform an encrypted database backup and restore Plan effective backup and recovery procedures Use Recovery Manager to create backups and perform recovery operations Use Oracle Flashback technologies to recover from human error Install Oracle Secure Backup Perform an Oracle-suggested backup to tape Use Oracle Secure Backup to perform a file system backup Use Oracle Secure Backup to perform a file system restoration

Participants

Administrateurs de base de données Administrateurs de data warehouse

Prérequis

Cours pré-requis obligatoire(s): Oracle9i Database Administration Fundamentals II Oracle Database 10g: Administration Workshop I

Pédagogie

La pédagogie est basée sur le principe de la dynamique de groupe avec alternance d'apports théoriques, de phases de réflexion collectives et individuelles, d'exercices, d'études de cas et de mises en situations observées. Formation / Action participative et interactive : les participants sont acteurs de leur formation notamment lors des mises en situation car ils s'appuient sur leurs connaissances, les expériences et mettront en œuvre les nouveaux outils présentés au cours de la session.

Profil de l’intervenant

Consultant-formateur expert. Suivi des compétences techniques et pédagogiques assuré par nos services.

Moyens techniques

Encadrement complet des stagiaires durant la formation. Espace d’accueil, configuration technique des salles et matériel pédagogique dédié pour les formations en centre. Remise d’une documentation pédagogique papier ou numérique à échéance de la formation.

Méthodes d’évaluation des acquis

Exercices individuels et collectifs durant la formation. La feuille d’émargement signée par demi-journée ainsi que l’évaluation des acquis de fin de stage sont adressées avec la facture.

Programme

Introduction

Overview of backup methods

Overview of recovery methods

Backup and recovery strategies

Oracle Secure Backup Overview

Oracle Secure Backup: Tape Management and Integration with Oracle Products

Oracle Secure Backup Interface Options

Media Management Expiration Policies

Securing Data and Access to the Backup Domain

Install Oracle Secure Backup

Perform Pre-installation Tasks

Perform Installation Tasks

Configure the Administrative Server

Configure Oracle Secure Backup Users

Use RMAN and Oracle Secure Backup

RMAN Database Backup to Tape

Define Database Storage Selectors

Back Up the Flash Recovery Area to Tape

Perform Oracle-suggested Backup to Tape

Manage Database Tape Backups

Back Up File System Files With Oracle Secure Backup

Manage Media Families

Create Datasets

Create Backup Windows

Create Backup Schedules

Create Backup Triggers

Create On-Demand Backup Requests

Restore File System Backups with Oracle Secure Backup

Browse the Catalog for File System Backup Data

Restore File System Data

Create a Catalog-Based Restore Request

Submit a Restore Request

Manage Oracle Secure Backup Security

Manage User Access Control

Define an Oracle Secure Backup User

Leverage Oracle Security Technology

Administrative Server Certificate Authority (CA)

Create Encrypted Backups

Restore Encrypted Backups

Perform Encrypted Recovery

Manage the Administrative Domain

Managing Common Daemon Operations

Managing Policies and Defaults

Configuring Oracle Secure Backup Policies

Adding Clients, Media Servers, and Devices

Managing Devices and Volumes

Managing Jobs

Configuring for Recoverability

Specifying a Retention Policy

Configuring the Flash Recovery Area

Using RMAN to Create Backups

Configuring RMAN Persistent Settings

Configuring Backup Optimization

Enabling Fast Incremental Backup

Creating an Oracle-suggested Backup

Creating Duplex Backup Sets

Configuring Control File Auto-backups

Managing Backups

Using RMAN to Perform Recovery

Performing Complete Recovery

Performing Recovery Using Incrementally Updated Backups

Using the Flash Recovery Area for Fast Recovery

Restoring and Recovering the Database on a New Host

Restoring the Server Parameter File

Restoring the Control File from Auto-backup

Using Oracle Flashback Technologies

Performing Flashback Table

Flashing Back Dropped Tables

Performing Flashback Versions Query

Performing Flashback Transaction Query

Configuring Flashback Database

Performing Flashback Database

Using RMAN to Create a Duplicate Database

Creating an Initialization Parameter File for the Auxiliary Instance

Creating a Duplicate Database

Using Enterprise Manager to Create a Duplicate Database

Performing Tablespace Point-in-Time Recovery

Tablespace Point-in-time Recovery Architecture

Determining the Recovery Set Tablespaces

Performing Basic RMAN Tablespace Point-in-time Recovery

Troubleshooting Tablespace Point-in-time Recovery

Using the RMAN Recovery Catalog

Configuring the Recovery Catalog Database

Creating the Recovery Catalog Owner

Creating the Recovery Catalog

Registering a Database in the Recovery Catalog

Cataloging Additional Backup Files

Manually Re-synchronizing the Recovery Catalog

Creating and Executing Stored Scripts

Monitoring and Tuning RMAN

Monitoring RMAN Sessions

Monitoring RMAN Job Progress

Interpreting RMAN Message Output

Tuning RMAN Backup Performance

1216 log-536.pdf