Loading...

Oracle 9i DBA Part 1

Course code: O910

5 days

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.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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.

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
Contact us for more information