Skip Headers
Oracle® Database 2 Day DBA
10g Release 2 (10.2)

Part Number B14196-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to next page
Next
View PDF

Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

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 Choices
Advanced Installation Choices
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
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
Online Help
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
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
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
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
Tablespaces
Some Tablespaces in the Database
Temporary Tablespace Groups
Datafiles
Viewing Datafile Information
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
Database Administrative Accounts
SYS
SYSTEM
Administrative Privileges
Administering Roles
About Privileges and Roles
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 Schemas and Common Schema Objects
Exploring Your Database's Schema Objects
Managing Database Objects
Managing Tables
Viewing Tables
Viewing Table Data
Creating Tables
Types of Table
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
Index Types
Creating an Index: Example
Dropping Indexes
Managing 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
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
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
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 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