What's New

The Wait for Visual Studio 2008 is Over!

One may picture, too, the sudden shifting of the attention, the swiftly spreading coils and bellyings of that blackness advancing headlong,...

Oracle9i Database Administration Fundamentals II

Oracle9i DBA Fundamentals II
Course ID: D11297_TCC | Duration: 5 Days
Class times are from 9 A.M. to 5 P.M.
Description:
This course gives the Oracle database administrator (DBA) a firm foundation in fundamental
database administrative tasks. Students learn about loading and transporting for 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.
Audience:
? Database Administrators
? Technical Support Professionals
? System Administrators
Required Prerequisites:
? Oracle9i DBA Fundamentals I
Suggested Prerequisites:
? Introduction to SQL (5 days)
Course Objectives:
? 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 Oracle backup methods and recovery operations that can be used to
resolve database failure
? Perform database and datafile backups with and without Recovery Manager (RMAN)
? Describe the database utilities (SQL*Loader, Export, and Import) and the situations
where they can be used
? Develop network configuration and recovery techniques through various workshop
scenarios
Course Topics:
Loading Data in the Database
SQL*Loader
Conventional and Direct Loads
Uses of SQL*Loader
Direct Inserts
Guidelines for Using SQL*Loader and Direct Inserts
Transp orting Data Between Databases
? Export
? Import
? Guidelines for Using Export and Import
Networking Overview
Network Environment Challenges
Network Configurations
Oracle’s Solutions
Basic Oracle Net Architecture
Defining the Procedure by which Oracle Net Establishes a Server Connection
? Identifying the Key Components of Oracle Net Architecture and their Interaction
? Basic Oracle Net Services Server-Side Configuration
? Identifying How the Listener Responds to Incoming Connections
? Describing the LISTENER.ORA File and Parameters
? Configuring the Listener using Oracle Net Configuration Assistant
? Starting and Stopping the Oracle Net Listener using the Listener Control Utility
? Describing Automatic Instance Registration
? Configuring the Database for IIOP and HTTP Connections
Backup and Recovery Overview
? Describing the Concepts of Database Backups, Restorations, and Recovery
? Defining a Backup and Recovery Strategy
? Listing the types of failure that may occur in an Oracle environment
? Instance and Media Recovery Structures
? Describing the Structures for Instance and Media Recovery
? Observing the Importance of Checkpoints, Redo Logs, and Archived Log Files
? Describing Bounded Recovery Time and Incremental Checkpoints
? Describing the Concept of Deferred Transaction Recovery
Database Configuration for Backup and Recovery
Noarchivelog Mode Configuration and Archivelog Mode Configuration
Bounded Recovery Time
Automatic and Manual Archiving of Log Files
Multiple Archival Destinations and Processes
Remote archival of redo logs
Suggested Next Courses:
Please check with your Education Representative to determine the appropriate follow up
course.
Related Courses:
? Oracle 8i Backup and Recovery: Troubleshooting and Recovery
? Oracle9i New Features: Backup, Recovery, and Performance Tuning Enhancements
? Oracle 8i Backup and Recovery: Strategies and Backups

AttachmentSize
Oracle 9i DBA Fundamental II.pdf20.23 KB
Code: 
9i DBA2
Duration: 
5
Price: 
6000000
Schedule: 
Available Upon Request