Back to Search Results

Training Course Summary:

Delegates:

This course is for Database Administrators, Systems Administrators and Network Managers who need to plan and implement database backup and recovery strategies for an Oracle9i database and who are also required to configure Oracle databases in a network environment.

Objectives:

By the end of this course, the delegate will have been given practical experience in using the various Oracle backup and recovery commands. He/she will gain experience of different failure and restore situations. The delegate will also have had practical experience in configuring Net Architecture, the Oracle Shared Server and the Listener. Experience of troubleshooting simple network problems will also have been gained. This course covers the main backup and recovery and networking topics for the Oracle9i Database: Fundamentals II examination (IZ0-032).


Topics Covered:

Backup and Recovery Strategies
Disaster Recovery Plan
Failure Scenarios
Oracle Recovery Structures and Processes
Using ARCHIVELOG and NOARCHIVELOG Modes
Physical Backups
Complete Database Recovery
Incomplete Recovery with Archiving
Additional Recovery Issues
The Export and Import Utilities
Loading Data with SQL*Loader
Troubleshooting Utilities
Recovery Manager Overview
Creating and Maintaining a Recovery Catalog
Backing up and Restoring with RMAN
Data Guard
Oracle Networking Overview
Configuring the Oracle Network
Oracle Net Architecture
Net Configuration
Oracle Net Manager
Oracle Net Configuration Assistant
Net Server Side Configuration
Net Client Side Configuration
Listener Configuration using Oracle Net Manager
Configuration of Net Service Names
Configuration of the Oracle Shared Server
Overview of Oracle Internet Directory
Troubleshooting the Network Environment
Network Environment Security

Requirements:

A working knowledge of SQL*Plus and an understanding of Oracle database administration is required. This can be obtained by attendance on the Pre-Requisite courses. A good working knowledge of operating system commands is also required.


Note:

Before taking any exam, ensure you have the recommended experience.

Pre-Requisites Courses:

SQL*Plus

DBA Part I - Architecture & Administration


Follow-On Courses:

DBA Performance & Tuning