IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
ORACLE 9i DBA Part II

Duration: 5 days

Course Overview
This 5-day course covers a range of topics such as configuring network parameters, using partitioning, using RMAN and migration. Delegates will complete hands-on workshops in which they will connect database clients to the Oracle database server, performance tune databases based on different business requirements and recover failed databases based on a number of different scenarios.

Course Objectives


By the end of the course attendees will:

• Define networking requirements and solutions
• Configure the network environment for a client-server system
• Perform backup and recovery without RMAN
• Perform incomplete recoveries
• Perform backup and recovery with RMAN
• Manage the RMAN Repository
• Describe the database utilities
• Develop network configuration and recovery techniques through various workshop scenarios
• Transport data between databases

Prerequisites


Ideally delegates will have attended the Fundamentals of ORACLE 9i DBA Part I course.

Course Content


Networking Overview
• Managing Complex Networks
• Oracle Networking Add-On Solutions

Oracle Net Architecture
• Oracle Net Architecture
• Where Oracle Net fits in to Client-Server Connections
• Describing How Web Client Connections are Established

Oracle Net Services
• How Listeners Work
• Configuring the Listener using Oracle Net Manager
• Using the Listener Control Utility
• Configuring the Listener for IIOP and HTTP
• Configuring the Oracle Net Services Client
• Using the Oracle Net Configuration Assistant

Oracle Shared Server
• What is Oracle Shared Server?
• When to Use Oracle Shared Server?
• Oracle Shared Server Architecture
• Using Initialisation Parameters to Configure Shared Servers
• Using Initialisation Parameters to Configure Dispatchers

Backup and Recovery Without RMAN
• The Basics of Backup, Recovery and Restore
• Failure Types
• Defining Your Backup and Recovery Strategy
• The Importance of Checkpoints, Redo Log Files and Archived Log Files
• Configuring Archive Log Mode
• Automatic and Manual Archiving of Redo Log Files
• Multiple Archive Destinations and Processes

User-Managed Backups
• Options Available
• Closed Database Backup
• Open Database Backup
• What to do if a Backup Fails
• Control File Backup
• Backup Issues Associated with Read-Only Tablespaces
• NOLOGGING Option Implications
• Checking for Block Corruption

User-Managed Complete Recovery
• What is Media Recovery?
• Recovery in NOARCHIVELOG Mode
• Recovery in ARCHIVELOG Mode
• Recovery of a Read-Only Tablespace
• Relocating and Recovering a Tablespace

User-Managed Incomplete Recovery
• What is Incomplete Recovery?
• When Incomplete Recovery if Necessary
• Incomplete Recovery Step-by-Step
• Performing an Incomplete Recovery
• Recovering from the Loss of Current Online Redo Logs
• Recovery of Database With Out of Synch Redo Log Files

Backup and Recovery With RMAN
• What is RMAN?
• RMAN Terminology
• Prerequisites of Your Target Database
• To Catalogue or Not To Catalogue?
• RMAN Command Set
• Connecting to RMAN

Executing RMAN Commands
• Executing from the Command Prompt
• Executing from a File
• Using Scripts

Implementing an RMAN Catalogue
• Advantages and Disadvantages
• Catalogue Issues
• Creating a Catalogue
• Registering a Target Database

Storing RMAN Scripts in the Catalogue
• Storing a Script
• Executing a Script
• Viewing a Script
• Deleting a Stored Script

RMAN Backups
• Full Database Offline Backup
• Full Database Online Backup
• Tablespace Backup
• Data File Backup
• Control File Backup
• Archived Redo Log Files Backup
• Incremental Backups
• Backup Tips

RMAN Recovery
• Recovering Every Data File
• Recovering Specific Data Files/Tablespaces
• Recovering Read-Only Tablespaces
• Point-In-Time Recovery
• Recovering Control Files
• Recovering Archived Redo Log Files

Transporting Data Between Databases
• Export Utility
• Import Utility
• Guidelines for Using Export and Import

Enhanced Features
• Advanced Queuing
• XML in the Database
• Migration Utilities
• Oracle Label Security
• Standby Database
• Oracle Workspace Manager

Enter your email address to register for our newsletter: