Oracle 10g Database Administration

• 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

Top