Oracle 9i DBA Fundamental II

Global Knowledge (UK) Inc.
Dublin,Maidenhead, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations. Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server.

This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations.

This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.

Learn How To

Use Oracle Recovery Manager to simplify backup and restore operations.
Configure your network so clients and tools can communicate with the Oracle database.
Protect your data from loss using appropriate strategies for backup and recovery

Course Outline
Networking Overview
Explaining solutions included with Oracle9i for managing complex networks
Describing Oracle networking add-on solutions

Basic Oracle Net Architecture

Explaining the key components of Oracle Net architecture
Explaining Oracle Net Services role in client-server connections
Describing how web client connections are established through Oracle networking products

Basic Oracle Net Services Server-Side Configuration

Identifying How the Listener Responds to Incoming Connections
Configuring the Listener using Oracle Net Manager
Controlling the Oracle Net Listener by Using the Listener Control Utility
Describing Dynamic Service Registration
Configuring the Listener for IIOP and HTTP Connections

Basic Oracle Net Services Client-Side Configuration

Describing the Difference Between Host Naming and Local Service Name Resolution
Using Oracle Net Configuration Assistant to Configure Host Naming Method, Local Naming Method, and Net Service Names
Performing Simple Connection Troubleshooting

Usage and Configuration of the Oracle Shared Server

Identifying the Components of the Oracle Shared Server
Describing the Oracle Shared Server Architecture
Configuring Shared Servers by Using Initialisation Parameters
Configuring Dispatchers by Using Initialisation Parameters
Identifying Useful Data Dictionary Views

Backup and Recovery Overview

Describing the Basics of Database Backup, Restore, and Recovery
Listing the Types of Failures that May Occur in an Oracle Environment
Defining a Backup and Recovery Strategy

Instance and Media Recovery Structures

Describing the Oracle Processes, Memory Structures, and Files Relating to Recovery Identifying the Importance of Checkpoints, Redo Log Files, and Archived Log Files
Describing Ways to Tune Instance Recovery

Configuration of the Database Archiving Mode

Noarchivelog and Archivelog Mode Configuration
Automatic and Manual Archiving of Redo Log Files
Multiple Archival Destinations and Processes

Oracle Recovery Manager (RMAN) Overview and Configuration

Identifying the Features and Components of RMAN
Describing the RMAN Repository and Control File Usage
Describing Channel Allocation
Describing Media Management Library Interface
Connecting to Recovery Manager
Configuring the RMAN Environment

User-Managed Backups

Describing User-Managed Backup and Recovery Operations
Performing Closed Database Backups
Performing Open Database Backups
Cleaning Up After a Failed Online Backup
Backing Up the Control File
Discussing Backup Issues Associated with Read-Only Tablespaces
Identifying the Backup Implications of Operations with NOLOGGING Options
Using DBVerify to Check for Block Corruption

RMAN Backups

Identifying RMAN Specific Backups
Using the RMAN BACKUP Command to Create Backup Sets, Backing Up the Control File,Backing Up the Archived Redo Log Files
Using the RMAN COPY Command to Create Image Copies

User-Managed Complete Recovery

Describing Media Recovery
Performing Recovery in Noarchivelog Mode
Performing Recovery in Archivelog Mode
Read-only Tablespace Recovery
Relocating and Recovering a Tablespace

RMAN Complete Recovery

Describing the Use of RMAN for Restoration and Recovery
Performing Recovery in Noarchivelog Mode
Performing Completing Recovery in Archivelog Mode
Restoring Data Files to a Different Location
Relocating and Recovering a Tablespace

User-Managed Incomplete Recovery

Describing the Steps of Incomplete Recovery
Identifying the Situations Which Require Incomplete Recovery
Performing an Incomplete Recovery
Recovering from the Loss of Current Online Redo Logs

RMAN Incomplete Recovery

Performing Incomplete Recovery Using UNTIL TIME
Performing Incomplete Recovery Using UNTIL SEQUENCE

RMAN Repository Maintenance

Performing Crosschecking of Backups and Copies
Updating the Repository When Backups Have Been Deleted
Changing the Availability Status of Backups and Copies
Making a Backup or Copy Exempt from the Retention Policy
Cataloging Backups Made with Operating System Commands

RMAN Catalog Creation and Usage

Describing the Contents of the Recovery Catalog
Listing the RMAN Features Which Require the Recovery Catalog
Creating the Recovery Catalog
Maintaining the Recovery Catalog by Using RMAN Commands
Using RMAN to Register, Resynchronise, and Reset a Database
Querying the Recovery Catalog to Generate Reports and Lists
Creating, Storing and Executing Scripts
Describing Methods for Backing Up and Recovering the Recovery Catalog

Transporting Data Between Databases

Export
Import
Guidelines for Using Export and Import

Backup and Recovery and Networking Workshop






Who Needs to Attend
Technical Support Professionals, Database Administrators, Network Administrators and System Administrators.






Suggested Prerequisites



Oracle 9i DBA Fundamental I
Introduction to Oracle 9i:SQL
...''

Phone:+00 353 (0) 1 613 0340 /+44 (0) 1628 594 700

School Address:

Global Knowledge Training Centre Dublin
27 Lower Mount Street
Dublin 2
Phone: +00 353 (0) 1 613 0340
Fax: +00 353 (0) 1 613 0341
Email: salesdesk.ie@globalknowledge.ie

Global Knowledge Training Centre Maidenhead
Cincom House
1 Grenfell Road
Maidenhead
SL6 1HN Berkshire
Phone: 0845 304 0044
Phone: +44 (0) 1628 594 700
Fax: +44 (0)1628 776 600
Email: salesdesk.uk@globalknowledge.co.uk

Jobs & Resumes: Dublin, Maidenhead
Houses & Roommates: Dublin, Maidenhead

Foundations of Novell Networking
Novell Network Management: Netware 6
Advanced Novell Network Management: Netware 6
ZENworks for Desktop 4
GroupWise 6.5 Administration
Novell Enterprise Linux Services
Upgrading to NetWare 6.5
NetWare 5.1 Advanced Administration
eDirectory Design and Implementation v3.0
Oracle 9i DBA Fundamental I
Oracle 9i Forms Developer: Build Internet Applications
Oracle 9i New Features for Administrators
Oracle 9i: Real Application Clusters
Oracle 9i for Advanced PL/SQL
Enterprise DBA Part 2: Performance Tuning Workshop
Develop PL/SQL Program Units
Oracle IDS Designer: First Class
Oracle 9i: Java Programming
Oracle 9iPerformance Tuning

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.