This course introduces participants
to the critical task of planning and implementing database
backup and recovery strategies. The class addresses backup
and recovery techniques and examines various backup, failure,
restore, and recovery scenarios. In hands-on exercises participants
examine backup methodologies based on business requirements
in a mission critical enterprise. Participants utilize multiple
strategies and Oracle tools such as Recovery Manager to
perform backups, and restore and recovery operations. This
class includes a one-day interactive workshop that provides
participants with the opportunity to walk through numerous
real-world backup, restore and recovery case studies. Participants
have the opportunity to apply some of the more advanced
techniques within a workshop environment.
This course is designed to prepare
you for the corresponding Oracle Certified Professional
exam: Exam #1Z0-025.
Understanding of basic Operating
System commands (e.g. move, copy, delete files)
Oracle8i Database
Architecture and Administration
Introduction
to Oracle: SQL and PL/SQL
Configure a standby database to minimize
primary database down-time
Develop confidence of recovery techniques through various
workshop scenarios
Diagnose and troubleshoot database problems and failures
Implement different types of backup methods using the various
Oracle database tools (e.g. physical backups with and without
RMAN, and logical backups)
List the Oracle architecture components related to backup
and recovery operations
List the key issues involved when defining an effective
backup and recovery strategy
List the components of the recovery manager architecture
List the different Oracle backup methods and use appropriate
restore and recovery operations to resolve database failure
(complete and incomplete recovery)
Defining business, operational, and
technical requirements for a Backup and Recovery Strategy
Understanding the importance of obtaining management concurrence
for a Backup and Recovery Plan
Identifying the components of a Disaster Recovery Plan
Listing advantages and disadvantages of possible database
configurations that support Recoverability
Discussing the importance of testing a Backup and Recovery
Strategy
Describing the Oracle Processes,
File Structures, and Memory Components
Observing the importance of Checkpoints, Redo Logs, and
Archives
Multiplexing Control Files and Redo Logs
Describing Bounded Recovery Time
Listing the types of failure that may occur in an Oracle
Database Environment
Describing the structures for Instance and Media Recovery
Describing the concept of Deferred Transaction Recovery
Parallelism on Demand
Configuring a database in Noarchivelog
Mode
Configuring a database in Archivelog Mode
Configuring Multiple Archival (of Redo Log) Processes
Remote Archival of Redo Logs
Performing Manual Archive of Log Files
Enabling/Disabling Automatic Archiving
Configuring multiple Archival Destinations and Processes
