Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Structure
• Related Documentation
• Conventions

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
    • Advanced Installation
• Installing Oracle Software and Database
• Using DBCA to Create and Configure a Database
• • Starting DBCA
  • 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
    • Database 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
  • • Pre-Upgrade Checks
    • Automated Upgrade Tasks
    • 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 Control
• • Database Management Features
  • Online Help
  • Navigational Features
• Starting and Stopping the Oracle Enterprise Manager Console
• • Starting dbconsole in Windows
• Accessing the Oracle Enterprise Manager Database Control
• Granting Database Control Administrative Privileges
• Setting Up Enterprise Manager Preferences
• • Defining Blackout 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
  • Naming Methods
  • • Local Naming
    • 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
  • • About Database Administration Privileges
    • Server and Client Processes
    • Network Connections
• Shutting Down and Restarting the Instance and Database with Enterprise Manager
• • 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
• • Control Files
  • • 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
  • Datafiles
  • • Viewing Datafile Information
  • Tablespaces
  • • Locally-Managed vs. Dictionary-Managed Tablespaces
    • Tablespace Type
    • Tablespace Status
    • Auto-Extend Tablespace
    • Some Tablespaces in the Database
  • Other Storage Structures
  • • Initialization Parameter File
    • Password File
    • Backup Files
• 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
• • Sample Schemas
• Administering Roles
• • About Privileges and Roles
  • About Administrative Accounts
  • • SYS
    • SYSTEM
    • Administrative Privileges
  • Viewing Roles
  • Creating Roles
  • Modifying Roles
  • Dropping Roles
• Administering Profiles
• Administering Database Users
• • Creating Users
  • Using a Shortcut to Create Users
  • Editing Users
  • • Changing the Tablespace Quota for a User
    • Unlocking Accounts and Resetting Passwords
    • Granting Roles
    • Revoking Roles
  • Dropping Users
• Users: Oracle by Example Series

8 Managing Schema Objects

• Overview of Schema Objects
• • Exploring Database Schema Objects
  • Naming Schema Objects
• Managing Tables
• • About Tables
  • • Types of Table
    • Column Attributes
    • Table-Level Constraints
    • Storage Attributes
    • Other Table Creation Considerations
  • Viewing Tables
  • Viewing Table Data
  • Creating Tables
  • • 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
  • Loading Data Into Tables
  • Dropping a Table
• Managing Indexes
• • About Indexes
  • • Indexes and Performance
    • Index Types
  • Viewing Indexes
  • Creating Indexes
  • Dropping Indexes
• Managing Views
• • About Views
  • Displaying Views
  • Creating a View: Example
  • Dropping Views
• 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
• Working with Other Schema Objects
• 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
    • Media Recovery
    • 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
    • Incrementally Updated Backups: Rolling Forward Image Copies 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
• • Alerts
  • 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 Direct Alert 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 Credentials
  • Staging the Patch Release
  • Installing the Patch Release
• 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 Real Application Clusters and Single-Instance Oracle Databases
• Monitoring Oracle Real Application Clusters with Enterprise Manager
• • Overview of the Cluster Database Home Page
  • Viewing Real Application Clusters Database Targets
  • Navigating to Oracle Enterprise Manager Cluster-Related Pages
  • Viewing and Modifying Real Application Clusters Initialization Parameters
• Starting and Stopping Real Application Clusters Databases and Database Instances
• • Starting and Stopping Real Application Clusters Databases
  • Starting and Stopping Individual Instances in Real Application Clusters Databases
• Managing Real Application Clusters Backup and Recovery
• • Redo Log Groups and Redo Threads in Real Application Cluster Databases
  • Backing Up Real Application Clusters Databases
  • Overview of Restore and Recovery Operations for a Real Application Clusters Database
  • Using a Flash Recovery Area with a Real Application Clusters Database
• Real Application Clusters: Oracle by Example Series

Index