Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documentation

1 Introduction

About this Book

What this Book is Not

How to Use this Book with Related Material

The Oracle Database

Common Oracle DBA Tasks

Tools for Administering the Database

2 Installing Oracle and Building the Database

Overview of Installation

Checking Prerequisites

Installation Choices

Basic Installation Choices

Advanced Installation Choices

Installing Oracle Software and Database

Using DBCA to Create and Configure a Database

Creating a Database with DBCA

Database Templates

Database Identification

Management Options

Database Credentials

Storage Options

Database File Locations

Recovery Configuration

Database Content

Initialization Parameters

Database Storage

Creation Options

Configuring Database Options with DBCA

Deleting a Database with DBCA

Managing Templates with DBCA

Advantages of Using Templates

Types of Templates

DBCA Templates Provided by Oracle

Creating Templates Using DBCA

Deleting DBCA Templates

Configuring Automatic Storage Management with DBCA

Upgrading a Database

Overview of the Database Upgrade Assistant

Before the Upgrade

During the Upgrade

Support for Real Application Clusters

Support for Automatic Storage Management

Support for Silent Mode

Oracle Database Version Restrictions

Starting the Database Upgrade Assistant

Upgrading the Database Using the Database Upgrade Assistant

Installation: Oracle by Example Series

3 Getting Started with Oracle Enterprise Manager

Introduction to the Oracle Enterprise Manager

Database Management Features

Navigational Features

Starting and Stopping the Oracle Enterprise Manager Console

Starting dbconsole in Windows

Accessing the Oracle Enterprise Manager

Granting Database Control Administrative Privileges

Setting Up Enterprise Manager Preferences

Defining Blackout Time Periods

Setting Preferred Credentials

SQL Statements and Other Management Tools: SQL*Plus and iSQL*Plus

Starting SQL*Plus

Starting iSQL*Plus

Managing Your Database: A Roadmap

Getting Started: Oracle by Example Series

4 Configuring the Network Environment

Understanding Network Configuration

Oracle Net Listener Configuration

Client Configuration

Connection Requests

Directory Naming

Easy Connect Naming

External Naming

Tools for Network Configuration

Oracle Net Configuration Assistant

Enterprise Manager

Oracle Net Manager

Viewing Listener Configuration

Starting and Shutting Down the Listener

Configuring Oracle Networking on Client Machines

Networking: Oracle by Example Series

5 Managing the Oracle Instance

Overview of an Instance and Instance Management

About Initialization Parameters

Instance Memory Structure

The System Global Area (SGA)

Program Global Area (PGA)

Oracle Background Processes

Accessing the Database

How the Oracle Instance and Database are Started

Server and Client Processes

Network Connections

Shutting Down and Restarting the Instance and Database

Starting and Shutting Down the Database Instance on Windows

Viewing and Modifying Initialization Parameters

Managing Memory Parameters

Modifying Memory Parameters

Instances: Oracle by Example Series

6 Managing Database Storage Structures

Exploring the Storage Structure of Your Database

Displaying Control File Information

Online Redo Log Files

Displaying Redo Log File Information

Multiplexing the Redo Log

Archive Log Files

Displaying Archive Log File Information

Rollback Segments

Displaying Rollback Segment Information

Some Tablespaces in the Database

Temporary Tablespace Groups

Viewing Datafile Information

Other Storage Structures

Initialization Parameter File

Performing Common Database Storage Tasks

Viewing Tablespaces in Your Database

Creating a Tablespace

Modifying a Tablespace

Dropping a Tablespace

Reclaiming Wasted Space

Viewing Segment Advisor Recommendations

Running the Segment Advisor Manually

Managing Undo for Your Database

About Undo Data

Undo Tablespace Size and Retention Time

Automatic Undo Management

Managing Undo with Enterprise Manager

Using the Undo Advisor

Gaining Advice from Undo Advisor

Extending the Undo Tablespace

Setting Minimum Undo Retention Time

Making Changes to the Database Storage Structure

Storage: Oracle by Example Series

7 Administering Users and Security

Overview of Users and Security

Database Administrative Accounts

Administrative Privileges

Administering Roles

About Privileges and Roles

Modifying Roles

Administering Profiles

Administering Database Users

Using a Shortcut to Create Users

Changing the Tablespace Quota for a User

Unlocking Accounts and Resetting Passwords

Users: Oracle by Example Series

8 Managing Schema Objects

Overview of Schemas and Common Schema Objects

Exploring Your Database's Schema Objects

Managing Database Objects

Managing Tables

Viewing Table Data

Creating Tables

Column Attributes

Table-Level Constraints

Other Table Creation Considerations

Estimating the Size of New Tables

Creating a Table: Example

Modifying Table Attributes

Adding a Column

Dropping a Column

Creating a New Table Constraint

Modifying an Existing Constraint

Dropping a Constraint

Dropping a Table

Managing Indexes

Viewing Indexes

Creating Indexes

Creating an Index: Example

Dropping Indexes

Displaying Views

Creating a View: Example

Managing Database-Resident Program Units

Managing Packages

Viewing Packages

Creating Packages

Editing Packages

Dropping Packages

Managing Package Bodies

Viewing Package Bodies

Managing Standalone Subprograms

Managing Triggers

Other Schema Objects

Loading Data Into Tables

Schemas: Oracle by Example Series

9 Performing Backup and Recovery

Overview of Database Backup and Recovery

Oracle Backup, Restore, and Recovery Concepts

Consistent and Inconsistent Backups

The Flash Recovery Area

The RMAN Repository

Configuring Your Database for Basic Backup and Recovery

Planning Space Usage and Location for the Flash Recovery Area

Retention Policy and the Flash Recovery Area

Sizing the Flash Recovery Area

Credentials for Performing Oracle Enterprise Manager Backup and Recovery

Preferred Credentials for Backup and Recovery

Configuring the Flash Recovery Area

Configuring ARCHIVELOG Mode For the Database

Configuring Backup Settings

Understanding Backup Device Settings for Disk

Configuring Backup Policy Settings

Backing Up Your Database

Database Backup Concepts

Full Backups of Datafiles

Incremental Backups of Datafiles

Using Tags to Identify Backups

Performing and Scheduling Backups with Enterprise Manager

Performing a Whole Database Backup with Oracle Enterprise Manager

Using the Oracle-Suggested Backup Strategy

Scheduling Other Backup Tasks

Validating Backups and Testing Your Backup Strategy

Performing Restore and Recovery Operations

Recovering a Whole Database from Backup

Recovering from a Lost SPFILE or Control File

Validating the Restore of Datafiles from RMAN Backup

Returning a Table to a Past State: Flashback Table

Enabling Row Movement on a Table

Performing Flashback Table

Recovering Dropped Tables: Flashback Drop

Managing Your Backups

Backup Management: Concepts

Using the Manage Current Backups Page

Searching for Backups on the Manage Current Backups Page

Managing Current Backups: Backup Sets

Managing Current Backups: Image Copies

Validating the Contents of Backup Sets or Image Copies

Crosschecking Backups

Deleting Expired Backups

Marking Backups as Available or Unavailable

Deleting Obsolete Backups

Displaying Backup Reports

Backup and Recovery: Oracle by Example Series

10 Monitoring and Tuning the Database

Proactive Database Monitoring

Performance Self-Diagnostics: Automatic Database Diagnostics Monitor

Monitoring General Database State and Workload

Managing Alerts

Viewing Metrics and Thresholds

Setting Metric Thresholds

Responding to Alerts

Clearing Alerts

Setting up Notification

Diagnosing Performance Problems

Viewing Performance Analysis

Responding to Performance Findings

Modifying Default ADDM Behavior

Running ADDM Manually

Using Advisors to Optimize Database Performance

About Performance Advisors

Using the SQL Tuning Advisor

Using the SQL Access Advisor

Using the Memory Advisor

Setting New SGA or PGA Targets

Determining Performance Impact for Altering your SGA or PGA

Monitoring and Tuning: Oracle by Example Series

11 Managing Oracle Software

About Software Management and Patch Releases

Applying a Patch Release

Determining your Oracle Software Environment

Determining the Oracle Database Version

Determining the Location of your Oracle Home

Determining Your Hardware Configuration

Setting your Oracle MetaLink Login Credentials

Staging the Patch Release

Installing the Patch Release

Installing the Patch Release: General Steps

Managing Oracle Software: Oracle by Example Series

A Automatic Storage Management

What is Automatic Storage Management?

Overview of Disks, Disk Groups, and Failure Groups

Installing Automatic Storage Management

Accessing the Automatic Storage Management Home Page

Accessing the ASM Home Page on a Single Instance System

Accessing the ASM Home Page On a Real Application Clusters System

Starting Up and Shutting Down the ASM Instance

Monitoring Disk Group Space Usage

Creating a Disk Group

Dropping a Disk Group

Adding Disks to a Disk Group

Dropping Disks from a Disk Group

Backing Up ASM-Managed Files

Automatic Storage Management: Oracle by Example Series

B Overview of Real Application Clusters

What is Real Application Clusters?

Real Application Clusters Database Configuration Scenario

Differences in Administering RAC and Single-Instance Databases

Monitoring RAC with Enterprise Manager

Overview of the Cluster Database Home Page

Viewing RAC Database Targets

Navigating to Oracle Enterprise Manager Cluster-Related Pages

Viewing and Modifying RAC Database Initialization Parameters

Starting and Stopping the RAC Database and Database Instances

Starting and Stopping RAC Databases

Starting and Stopping Individual Instances in a RAC Database

Managing RAC Backup and Recovery

Redo Log Groups and Redo Threads in Real Application Cluster Databases

Backing Up RAC Databases

Overview of Restore and Recovery Operations for a RAC Database

Using a Flash Recovery Area with a RAC Database

Real Application Clusters: Oracle by Example Series

Index