SUMMARY:   The course is designed for a technical person who is new to database administration and will enable the delegate to create and maintain backups of Oracle databases and to identify and action appropriate recovery. Oracle product versions covered include: Oracle 7, Oracle 8/8i, Oracle 9i, Oracle 10g (includes Flashback Facilities). AUDIENCE:   The course is suitable for new database administrators, system administrators and support staff. PREREQUISITES:   Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL. DURATION:   4 days OBJECTIVES:   At the end of the course the delegate should be able to : Understand the Oracle architecture. Design a back-up strategy. Produce appropriate Backups. Identify different database failures and take corrective action. Restore and recover Damaged or destroyed databases with minimal data loss. COURSE CONTENT:   Overview of Available Back-up Types Physical and Logical Backups Whole, Complete and Incomplete Backups Configuring Archive Log Mode Implementing Archive Log Mode Specifying Multiple Local or Remote Log Destinations Designing a Back-up Strategy 24 hour Operations Mirroring and Multiplexing Designing a Backup Schedule Testing and Verifying Backups Backing up the Database Offline and Online Backups Backing up Datafiles Backing up Controlfiles Backing up Redo and Archive Logs Recovering a Database Complete Recovery Incomplete Recovery Database, Tablespace and Datafile Recoveries Recovery from Instance Failure Recovery from Media Failure Recovery from User Error Importing and Exporting Data Using Export and Import Utilities Backup Using Export Transportable Tablespaces Point in Time Tablespace Recovery Using Export and Import Overview of RMAN interface The Components of Recovery Manager The Facilities and Capabilities of Recovery Manager Added Benefits of Using a Repository Database Using the RMAN Interface to Backup and Recover Backup Using RMAN Without a Repository Database Recovery Using RMAN Without a Repository Database Backup Using RMAN With a Repository Database Recovery Using RMAN With a Repository Database Physical Image Backups Using Backup Sets Parallel Backup and Recovery (Tape Streaming) Reporting and Querying the Repository Database Disaster Recovery Disaster Recovery Planning Creating a Standby Database Maintaining a Standby Database Recovery and Managed Recovery Modes SW/07