Oracle Database 10g DBA Backup & Recovery

Database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle10g databases.

Course Content

Plan a backup and recovery strategy
Alter a database to (NO)ARCHIVELOG modes
Create and manage a recovery catalog database
Use Recovery Manager to perform backups
Use Recovery Manager to perform recoveries
Monitor and Tune Recovery Manager
Perform tablespace point-in-time recovery
Create a duplicate database
Use Flashback technology to recover from errors
Install Oracle Secure Backup
Perform Oracle Secure Backup to tape of database files
Perform file system backups with Oracle Secure Backup
Perform file system restores with Oracle Secure Backup
Perform encrypted database backup and restores
Manage the Oracle Secure Backup environment

Skills

By the end of the course, delegates will be able to:
Plan and implement a backup and recovery strategy using Recovery Manager and Oracle Secure Backup
Perform backup and recovery operations using RMAN and Enterprise Manager
Use Flashback features to recover from human error
Use Oracle Secure Backup to backup and restore from tape

Prerequisites

A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses.

Pre-Requisite Courses:

SQL

Oracle Database 10g DBA - Part I