Delegates: |
|
Database administrators, data warehouse administrators and technical support staff
who are required to plan and implement database backup and recovery strategies for
Oracle10g databases.
|
Objectives: |
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
|
Topics Covered: |
- 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
- Overview of file system backups and restores with Oracle Secure Backup
|
Requirements:
|
|
A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses.
|