Oracle 10g DBA (Weekend batch starts 22nd September 2012)

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

Oracle 10g Database Administration - I
`
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

Top

Oracle 10g Database Administration - II
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 Guaranteed Restore Points
Setup and Maintenance for Oracle Flashback Database

Performing Complete Restore and Recovery of Database

Database Restore and Recovery with RMAN: Overview
Basic Database Restore and Recovery Scenarios
Preparing and Planning Database Restore and Recovery
RMAN RESTORE: Restoring Lost Database Files from Backup

Performing Flashback and Database Point-in-Time Recovery

About Point-in-Time Recovery and Flashback Features
Oracle Flashback Query: Recovering at the Row Level
Oracle Flashback Table: Returning Individual Tables to Past States
Oracle Flashback Drop: Undo a DROP TABLE Operation
Reversing Database Changes with Flashback Database
Performing Database Point-In-Time Recovery