Oracle - Oracle Database 10g: Backup and Recovery

KURSZIEL
Oracle - Oracle Database 10g: Backup and Recovery:

Data Warehouse Administrator

_x000D_

Data Warehouse-Administrator

_x000D_

Database Administrators

_x000D_

Datenbankadministratoren

_x000D_

_x000D_

Kursziele_x000D_

Plan effective backup and recovery procedures

_x000D_

Use Recovery Manager to create backups and perform recovery operations

_x000D_

Use Oracle Flashback technologies to recover from human error

_x000D_

Install Oracle Secure Backup

_x000D_

Perform an Oracle-suggested backup to tape

_x000D_

Use Oracle Secure Backup to perform a file system backup

_x000D_

Use Oracle Secure Backup to perform a file system restoration

_x000D_

Perform an encrypted database backup and restore

_x000D_

Manage the Oracle Secure Backup environment

_x000D_

Monitor and tune Recovery Manager

_x000D_

Perform tablespace point-in-time recovery

_x000D_

Create a duplicate database

_x000D_

Create and manage a recovery catalog database

ZIELGRUPPE

Data Warehouse Administrator

_x000D_

Data Warehouse-Administrator

_x000D_

Database Administrators

_x000D_

Datenbankadministratoren

_x000D_

_x000D_

Kursziele_x000D_

Plan effective backup and recovery procedures

_x000D_

Use Recovery Manager to create backups and perform recovery operations

_x000D_

Use Oracle Flashback technologies to recover from human error

_x000D_

Install Oracle Secure Backup

_x000D_

Perform an Oracle-suggested backup to tape

_x000D_

Use Oracle Secure Backup to perform a file system backup

_x000D_

Use Oracle Secure Backup to perform a file system restoration

_x000D_

Perform an encrypted database backup and restore

_x000D_

Manage the Oracle Secure Backup environment

_x000D_

Monitor and tune Recovery Manager

_x000D_

Perform tablespace point-in-time recovery

_x000D_

Create a duplicate database

_x000D_

Create and manage a recovery catalog database

KURSINHALT
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error._x000D_

_x000D_

This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files. _x000D_

_x000D_

Learn To:_x000D_

Develop an effective backup and recovery strategy

_x000D_

Perform backup and recovery operations using RMAN

_x000D_

Install and configure Oracle Secure Backup for tape backup

_x000D_

Use Oracle Secure Backup to back up database and file system files

_x000D_

_x000D_

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

_x000D_

VORRAUSSETZUNG
Erforderliche Vorkenntnisse:_x000D_

Oracle9i Datenbankadministration Tier 1

_x000D_

Oracle9i Datenbankadministration Teil 2

_x000D_

Oracle Database 10g: Administration Workshop I Release 2

_x000D_