Axigma

Fechas y Registro

Fecha:

18 de enero del 2010 al 20 de enero del 2010

Horario

de 9 a 17 hs.

Duración del curso

3 días

Lugar

Buenos Aires, Argentina

Para más información:

eva.lupi@axigmatechnologies.com

Database 10g: Backup & Recovery

Course Objectives

  • 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
  • Perform an encrypted database backup and restore
  • 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

Learn To

  • Develop an effective backup and recovery strategy
  • Perform backup and recovery operations using RMAN
  • Install and configure Oracle Secure Backup for tape backup
  • Use Oracle Secure Backup to back up database and file system files

Audience

  • Data Warehouse Administrator
  • Database Administrators

Required Prerequisites

Course Topics

Introduction

  • Overview of backup methods
  • Overview of recovery methods
  • Backup and recovery strategies

Configuring for Recoverability

  • Configuring ARCHIVELOG mode
  • 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

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