Enterprise DBA Part 1B: Backup & Recovery Workshop

Aims and Objectives
Defining an effective backup and recovery strategy.
Oracle architecture components related to backup and recovery operations.
Diagnose and troubleshoot database problems and failures.
Recognise Recovery Manager architecture.
Implement different types of backup methods using the various Oracle database tools.
Configure a standby database to minimise primary database down-time.

Target Audiences
This course is intended for Network Administrators, Database Administrators, Technical Support Professionals and System Administrators, Application Developers and MIS Managers who are responsible for managing an Oracle8 or 8i Database.

Prerequisites
Delegates must have an understanding of basic operating system file and directory commands.
They should have attended DBA1A (Enterprise DBA Part 1A : Architecture and Administration).

Course Content
Module 1: Backup & Recovery Considerations
Module 2: Oracle Recovery Structures and Processes
Module 3: Oracle Backup & Recovery Configuration
Module 4: Physical Backup without RMAN
Module 5: Complete Recovery of an Oracle Database
Module 6: Incomplete Recovery of an Oracle Database with Archiving
Module 7: Oracle Export/Import Utilities
Module 8: Additional Recovery Issues
Module 9: Oracle Utilities for Troubleshooting
Module 10: Oracle Recovery Manager Architecture
Module 11: Oracle Recovery Catalog Maintenance
Module 12: Physical Backups Using RMAN
Module 13: Restore and Recover Using RMAN
Module 14: Oracle Standby Database