Oracle 10g Database Administration

Ahana Systems & Solutions (P) Ltd.
Hanumanth nagar, Karnataka, India

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

Course Description:

'' Oracle 10g Database Administration

* Oracle 10g Database Administration - I
* Oracle 10g Database Administration - II

Oracle 10g Database Administration - I

Course Contents:

Basic Database Administration
* Overview of Administering an Oracle Database
* Types of Oracle Database Users
* Tasks of a Database Administration
* Database Architecture

Oracle Architecture
* Oracle Logical Storage Structures
* Oracle Logical Database Structures
* Oracle Physical Storage Structures
* Multiplexing Database Files
* Oracle Memory Structures

Creating an Oracle Database
* Deciding How to Create an Oracle Database
* Manually Creating an Oracle Database
* Understanding the CREATE DATABASE Statement
* Understanding Initialization Parameters
* Troubleshooting Database Creation
* Dropping a Database
* Managing Initialization Parameters Using a Server Parameter file

Starting Up and Shutting Down
* Starting Up a Database
* Altering Database Availability
* Shutting Down a Database
* Quiescing a Database
* Suspending and Resuming a Database

Managing Oracle Database Processes
* About Dedicated and Shared Server Processes
* Configuring Oracle Database for Shared Server
* About Oracle Database Background Processes

Managing Control Files
* Guidelines for Control Files
* Creating Control Files
* Troubleshooting After Creating Control Files
* Backing Up Control Files
* Recovering a Control File Using a Current Copy
* Dropping Control Files

Managing the Redo Log
* Basic working of Redo Log
* Planning the Redo Log
* Creating Redo Log Groups and Members
* Relocating and Renaming Redo Log Members
* Dropping Redo Log Groups and Members

Managing Archived Redo Logs
* What Is the Archived Redo Log?
* Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
* Controlling Archiving
* Specifying the Archive Destination
* Specifying the Mode of Log Transmission
* Managing Archive Destination Failure

Managing Tablespaces
* Guidelines for Managing Tablespaces
* Creating Tablespaces
* Altering Tablespace Availability
* Using Read-Only Tablespaces
* Renaming Tablespaces
* Dropping Tablespaces
* Managing the SYSAUX Tablespace
* Viewing Tablespace Information

Managing Datafiles and Tempfiles
* Guidelines for Managing Datafiles
* Creating Datafiles and Adding Datafiles to a Tablespace
* Changing Datafile Size
* Altering Datafile availability
* Renaming and Relocating Datafiles
* Dropping Datafiles
* Copying Files using the Database Server

Managing the Undo Tablespace
* What Is Undo?
* Introduction to Automatic Undo Management
* Setting the Undo Retention Period
* Sizing the Undo Tablespace
* Managing Undo Tablespaces

Using Oracle-Managed Files
* What Are Oracle-Managed Files?
* Enabling the Creation and Use of Oracle-Managed Files
* Creating Oracle-Managed Files



Oracle 10g Database Administration - II

Course Contents:

Using Automatic Storage Management
* What Is Automatic Storage Management?
* Overview of the Components of Automatic Storage Management
* Administering an Automatic Storage Management Instance
* Administering Automatic Storage Management Disk Groups
* Using Automatic Storage Management in the Database

Managing Schema Objects
* Creating Multiple Tables and views in a Single Operation
* Analyzing Tables, Indexes and Clusters
* Truncating Tables and Clusters
* Renaming Schema Objects

Managing Space for Schema Objects
* Managing Space in Data Blocks
* Managing Storage Parameters
* Managing Resumable Space Allocation

Managing Tables
* About Tables
* Guidelines for Managing Tables
* Creating Tables
* Loading Tables
* Automatically collecting Statistics on Tables
* Altering Tables
* Redefining Tables Online
* Using Flashback Drop and Managing the Recycle Bin
* Managing Index-Organized Tables
* Managing External tables

Managing Indexes
* About Indexes
* Gidelines for Managing Indexes
* Creating Indexes
* Altering Indexes
* Monitoring Space Usage of Indexes
* Dropping Indexes

Managing Partitioned Tables and Indexes
* About Partitioned Tables and Indexes
* Partitioning Methods
* Creating Partitioned Tables
* Maintaining Partitioned Tables
* Dropping Partitioned Tables

Managing Clusters
* About Clusters
* Guidelines for Managing Clusters
* Creating Clusters
* Altering clusters
* Dropping Clusters

Managing Users
* Create Database users
* Assign Roles & Privileges
* Sysdba & Sysoper privileges
* Create and assign profiles
* Set resource limits for profiles

Loading And Unloading Data
* Introduction to the Data Pump Architecture
* Benefits of Data Pump Technology
* Using Data Pump Export and Import
* Monitoring a Data Pump Job
* Creating External Tables for Data Population
* Defining External Table Properties

Manageability Infrastructure
* The Automatic Workload Repository (AWR)
* Active Session History (ASH)
* Server-Generated Alerts
* The Automated Tasks Feature
* The Management Advisory Framework

The Oracle Scheduler And The Database Resource Manager
* Simplifying Management Tasks Using the Scheduler
* Managing the Basic Scheduler Components
* Managing Advanced Scheduler Components
* Managing Scheduler Attributes

Backup And Recovery Enhancements
* Using the Flash Recovery Area
* Using Incremental Backups
* Enhanced RMAN Commands
* Miscellaneous Backup and Recovery Enhancements

FlashBack Technology Enhancements
* General Flashback Technology Considerations
* Flashback Drop
* Flashback Table
* Row Level Flashback Features

Oracle Net
* Overview of Oracle Net
* Connect Descriptors
* Listeners
* Using the Oracle Net configuration Assistant
* Configuring the Listener
* Using the Oracle Net Manager
* Starting the Listener Server Process
* Directory Naming with Oracle Internet Directory

Backup and Recovery Overview
* Backup and Recovery Basic Concepts
* The Database Recovery Process: Basic Concepts
* Forms of Data Recovery
* Backup and Recovery with RMAN
* Oracle Flashback Technology: Alternatives to Point-in-time Recovery

Setting Up and Configuring Backup and Recovery
* Using RMAN to Start Up and Shut Down Databases
* Setting Up a Database for RMAN Backup
* Setting Up a Flash Recovery Area for RMAN

Backing Up Databases Using RMAN
* Specifying Options Affecting Output of the RMAN BACKUP command
* Backing Up Database Files and Archived Logs with RMAN
* Using RMAN to Validate Database Files
* Listing RMAN Backups, Archived Logs and Database Incarnations
* Reporting on Backups and Database Schema

Data Protection with Restore Points and Flashback Database
* Restore Points and Flashback Database: Concepts
* Using Normal and Guar ...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

Ahana Systems & Solutions (P) Ltd.

105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore ï¿?560050

Jobs & Resumes: Hanumanth nagar
Houses & Roommates: Hanumanth nagar

Search other schools for Oracle 10g Database Administration training resources.

Oracle 10g RAC
Oracle DataGaurd
Oracle 11i Application DBA

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: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.