| BR10g - Oracle Database 10g: Backup and Recovery |
| |
| Objetivo |
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
|
| |
| Descrição |
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.
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.
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
|
| |
| Público
Alvo |
Administrador de Banco de Dados
Administrador de Data Warehouse
Data Warehouse Administrator
Database Administrators
|
| |
| Conteúdo
Programático |
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
|
| |
| Pré-Requisitos |
Oracle9i Database Administration Fundamentals I
Oracle Database 10g: Administration Workshop I Release 2
|
|
|
| |
| Carga
Horária |
18 horas |
| |
| Material
Didático |
Material didαtico oficial da Oracle |
| |
|
