Back to Search Results

Training Course Summary:

This course is designed for Network Administrators, Database Administrators, Technical Support Analysts and System Administrators and gives delegates a firm foundation in fundamental database administration tasks, loading and transporting for databases and the utilities used to perform these activities. The course also includes an introduction to networking concepts and configuration parameters and how to solve common network problems. Delegates will configure network parameters so that database clients and tools can communicate with the Oracle database server. This course addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Delegates examine backup methodologies based on business requirements in a mission critical enterprise. Delegates use multiple strategies and Oracle Recovery Manager to perform backups and restore and recovery operations. Two interactive workshops are included in this course to provide delegates with the opportunity to walk through numerous real-world networking, backup and recovery case studies.

Course objectives

On completing this course, delegates will be able to:
Define networking requirements and the solutions provided by Oracle to implement these requirements
Configure the network environment for an Oracle client-server system
List the Oracle architecture components related to backup and recovery operations
List the different backup methods and recovery operations that can be used to resolve database failure
Perform backups both with and without RMAN
Describe the database utilities
Develop network configuration and recovery techniques through various workshop scenarios

Course outline

Networking Overview
Basic Oracle Net Architecture
Basic Oracle Net Server-Side Configuration
Basic Oracle Client-side Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structure
Configuration of the Database Archiving Mode
Oracle Recovery Manager Architecture
User-Managed Backups
RMAN Backups
User Managed Complete Recovery
RMAN Complete Recovery
User Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Repository Maintenance
RMAN Catalog Creation and Usage
Transporting Data between Databases
Loading Data into a Database
Backup and Recovery and Networking Workshop

Pre-Requisites:

Delegates must have an understanding of basic operating system commands (eg move, copy, delete files). Delegates must also have attended course O9iDBAI (Oracle 9i DBA Fundamentals I).