Oracle 9i DBA Part 1 (O910) Training Course

Training Course Objectives

This practical foundation course is an essential toolkit for all Database Admin-istrators covering the practical skills needed by the DBA to perform the Oracle 9i database administration function within their enterprise.

The enhancements and changes that have been introduced in 9i release 2 will be discussed during this course.

Who Should Attend

• Oracle Database Administrators
• Oracle Technicians
• Oracle Support Engineers
• Oracle Developers

Training Course Prerequisites

• PC Fundamentals
• Oracle 9i SQL (O010)
• Oracle 9i PL/SQL (O020)
• View Learning Path

Training Course Duration

5 Days

Training Course Contents

Basic Concepts

• The DBA Role
• Basic ORACLE Architecture
• Logical /Physical Structures
• Some Administration Terminology
• Basic Steps to set up a new database
• Database Administrator Tools
• Parameter Files (Text & Binary)

Start & Stop a Database

• Steps to Start the Database
• Altering Database Availability
• Steps to Shutdown the Database

Managing Database Storage

• Managing Tables, Data Storage
• Setting Storage Parameters
• Managing Tablespaces and Data Files
• Creating Additional Tablespaces
• Adding Data Files to a Tablespace
• Tablespace Online / Offline
• Locally Managed Tablespaces
• Multiple Block sizes

Default Temporary Tablespaces

• Renaming and Relocating Data Files
• Dropping Tablespaces and Data Files

Managing Rollback Segments

• Managing Rollback Segments
• Assignments to Rollback Segments
• De-allocation of Rollback Segment Extents
• Types of Rollback Segments
• Acquiring of Rollback Segments
• Rollback Segment States
• Creating Rollback Segments
• Changing Storage Parameters
• Bringing Rollbacks Segments Online
• Taking Rollback Segments Offline
• Dropping a Rollback Segment

Automatic Undo Management

• Setting up Automatic Undo Management
• Monitoring Undo Segments
• Undo Tablespace & Sizing
• General Implications

Redo Logs and Control Files

• Managing Redo Logs
• Types of Redo Log
• Archiving Modes
• Log Switches and Checkpoints
• Creating Online Redo Log Groups
• Creating Log Group Members
• Renaming / Relocating Redo Log Members
• Dropping Redo Log Groups / Members
• Archiving Redo Logs
• Specifying Archived Log Destinations
• Manual Archiving of Redo Logs
• Control Files
• Creating/Dropping Control Files

Database Security

• Key Concepts
• Users
• Internal User
• Connecting as SYSDBA/SYSOPER
• Password Management
• Password Dictionary Structures
• Security Schemas
• Privileges / Roles / Profiles
• Security Guidelines
• Dropping Users
• Profile Management
• Creating / Altering/ Dropping Roles

Enable & Disable Roles

• Grant / Revoke System Privileges and Roles
• Grant / Revoke Object Privileges

Backup and Recovery Procedures

• Basic Concepts
• Backup Guidelines
• Performing Full / Partial Back-ups
• Control File Backups in ARCHIVELOG mode
• Online Backup
• Recovery Mechanisms
• Oracle Online Recovery
• Restoring a Full Backup
• Closed Database Recovery
• Open Database - Offline Tablespaces Recovery
• Incomplete Media Recovery
• Applying Redo Logs
• Types of failure
• Appropriate Recovery Procedures
• Restoring Damaged Data Files
• Restoring Archived Redo Log Files

UTILITIES: EXPORT and IMPORT

• Introduction to Utilities
• EXP: The Runtime EXPORT Command
• EXP Operation Notes
• Restrictions on Export
• IMP: The Runtime IMPORT Command
• Privileges Required for IMPORT
• IMP Parameters & Operation Notes

SQL Loader

• Conventional path
• Types of file
• The control file

Enterprise Manager

• Overview
• OEM Standalone
• Management Server

Creating the Database

• Steps to create an ORACLE Database
• Examples of Creating a Database
• After Database Creation

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.