Conte nts

List of Examples

List of Figures

List of Tables

Title and Copyright Informati on

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Structure

Related Documents

Conventions< /dd>

What's New in Administration?

Oracle Database 10g New Features for Real Application Clusters Administration< /dd>

1 Introduction to Ad ministration

Introduction to Administering Real Application Clusters

< dd>Administering Real Application Clusters

Database Instance M anagement and Database Administration in RAC

Storage Management in Real Application Cluster s

Administering Services in Real Application Clusters

Additional Real Application Clusters Administrative Topics

Overview of Using Enterpris e Manager with Real Application Clusters

2 Administering Database Instances in Cluster Databases

Database Component Overview

Overview of Real Application Clusters Management Tools

Overview of Administering Real Application Clusters with Enterpise Mana ger

Overview of Administering Real Application Clusters with SQL*Plus

Overview of Administering Real Application Clusters with SRVCTL

Starting and Stopping Instances and Real Application Clusters Databases

Starting up and Shutting down with Enterprise Manager

Starting up and Shutti ng down with SQL*Plus

Starting up and Shutting down with SRVCTL

Overview of Initialization Parameter Files in Real Application Clusters

Setting Server Parameter File Parameter Values for Real Application Clusters

Specifying Comments in Server Parameter Files

Exp orting the Server Parameter File for Backward Compatibility

Initialization Pa rameter Use in Real Application Clusters

Parameters that Must Have Identical Settings on All Instances

Parameters That Must Have Unique Settings on All Instances

Summary of Parameter Use in Real Application Clusters Databases

Backing Up the Server Parameter File

3 Administering Storage

Overview of Storage in Oracle Real Application Clusters

Automatic Storage Mana gement

Automatic Storage Management Components in RAC

Modifying Disk Group Configurations for ASM in RAC

Administering ASM Instance s and ASM Disk Groups with Enterprise Manager in RAC

Administering ASM Instances with SR VCTL in RAC

Datafile Access in Real Application Clusters

Redo Log File Storage in Real Application Clusters

Automatic Undo Manageme nt in Real Application Clusters

Switching Undo Tablespaces for Instances in Real Applica tion Clusters

Managing the Oracle Cluster Registry in Real Application Clusters

Managing Oracle Cluster Registry Backup Files in Real Application Clusters

Restoring the Oracle Cluster Registry from Automatically Generated OCR Backups

Restoring the Oracle Cluster Registry on UNIX-Based Systems

Rest oring the Oracle Cluster Registry on Windows-Based Systems

Managing the Oracle Cluster Registry with OCR Exports

Importing Oracle Cluster Registry Content o n UNIX-Based Systems

Importing Oracle Cluster Registry Content on Windows-Based Systems< /a>

The ocrconfig Tool Command Syntax and Options

Implementing the Oracle Hardware Assisted Resilient Data Initiative for the OCR

Upgrading and Downgrading the OCR Configuration in Real Application Clusters

HARD-Compatible OCR Blocks in Oracle9i

Importing and Ex porting Cluster Database Configuration Information with SRVCONFIG

4 Administering Services

Services and High Availability in Real Application Clusters

Adding and Modifying Servic es

Using the DBCA to Add and Modify Services

Automatic Restarts after Failures

Administering Services with Enterp rise Manager and SRVCTL

Administering Services in Real Application Clusters wit h Enterprise Manager

Administering Services in Real Application Clusters with SRVCTL

Starting and Stopping Services with SRVCTL

Enabling and Disabling Services with SRVCTL

Relocating Services with SRVCTL

Obtaining the Statuses of Services with SRVCTL

5 Adding and Deleting Nodes and Instances

Overview of Node Addition Procedures

Step 1: Connecting New Nodes to the Cluster

Making Physical Connections

Installing Operating System

Creating Oracle User s

Checking the Installation

Step 2: Extending Clusterware and Oracle Software to New Nodes

Adding Nodes at the Ven dor Clusterware Layer (UNIX only)

Adding Nodes at the Oracle Clusterware Layer (UNIX and Windows)

Step 3: Preparing Storage for RAC on New Nodes

Raw Device Storage Preparation for New Nodes

Con figure Raw Storage on UNIX-Based Systems

Configure Raw Partitions on Windows-Based System s

Step 4: Adding Nodes at the Oracle RAC Database Layer

Step 5: Adding Database Instances to New Nodes

Adding Node s that Already Have Clusterware and Oracle Software to a Cluster

Deleting Instances from Real Application Clusters Databases

Deleting Nodes from Oracle Clusters on UNIX-Based Sys tems

Deleting Nodes from Oracle Clusters on Windows-Based Platforms

6 Configuring Recovery Manager and A rchiving

Overview of Configuring RMAN for Real Application Clusters

Configuring the RMAN Snapshot Control File Location

Configuring the RMAN Control File Autobackup Feature

Managing Archived Redo Logs Using RMAN in Real Application Clusters

Archived Redo Log File and Destination Conventions in RAC

RMAN Archiving Configuration Scenarios

Cluster File System Archiving Scheme

Initialization Parameter Setting s for the Cluster File System Archiving Scheme

Location of Archived Logs for the Cluster File System Archiving Scheme

Non-Cluster File System Local Archiving Scheme

Advantages and Disadvantages for Non-Cluster File System Local Archiving

Initialization Parameter Settings for Non-Cluster File System Local Archiving

Location of Archived Logs for Non-Cluster File System Local Archiving

File System Configuration for Non-Cluster File System Local Archiving

Changing the Archiving Mode in Real Application Clusters

Monitori ng the Archiver Processes

7 Managing Backup and Recovery

Instance Recovery in Real Application Clusters

Single Node Failure in Real Application Clusters

Multiple-Node Failures in Real Application Clusters

Us ing RMAN to Create Backups in Real Application Clusters

Using RMAN to Restore the Server Parameter File (SPFILE)

RMAN and Oracle Net in Real Application Clusters

Channel Connections to Cluster Instances

Node Affinity Awaren ess of Fast Connections

Readability of Files To Be Backed Up

Deleting Archived Redo Logs After a Successful Backup

Distribution of Bac kups

Autolocation for Backup and Restore Commands

RMAN Backup Scenarios for Real Application Clusters

Cluster File System Backup Scheme

Backing Up to One Local Drive in the Cluster File System Archiving Scheme

Backing Up to Multiple Drives in the Cluster File System Archiving Schem e

Non-Cluster File System Backup Scheme

Backing Up to Multiple Drives in a Non-Cluster File System Backup Scheme

Media Recovery in Real Application Clusters

RMAN Restore Scenarios for Real Application Clusters

Cluster File System Restore Scheme

Restore and Recovery of Nondistributed Backups

Resto re and Recovery of Distributed Backups in a Cluster File System Scheme

Non-Clus ter File System Restore Scheme

Restore and Recovery of Distributed Backups in a Non-Cluster File System Archiving Scheme

RMAN Recovery Through Reset logs in Real Application Clusters

Parallel Recovery in Real Application Clusters

Parallel Recovery with RMAN

Parallel Recove ry with SQL*Plus

Using a Flash Recovery Area in Real Application Clusters

8 Administrative O ptions

Optional Enterprise Manager Tasks in Real Application Clusters

Using Enterprise Manager to Discover Nodes and Instances

Enterprise Manager Pages for Real Application Clusters

Databases Su mmary Page

Cluster Database Home Page

Clu ster Database Instances Pages

The Databases Overview Page for Real Application Clusters

The Cluster Home Page for Real Application Clusters

Instance Pages for Real Application Clusters

Real Application Clu sters Administration Procedures for Enterprise Manager

Administering Enterpri se Manager Jobs in Real Application Clusters

Creating Enterprise Manager Jobs in Real Application Clusters

Administering Alerts in Real Application Cluste rs with Enterprise Manager

Performing Scheduled Maintenance Using Defined Blackouts in Enterprise Manager

Additional Information About SQL*Plus in Real Application Clusters

How SQL*Plus Commands Affect Instances

Verifying that Instances are Running

Quiescing Real Applicat ion Clusters Databases

Quiesced State and Cold Backups

Administering System and Network Interfaces with the OIFCFG (Oracle Interface Configuration) Tool

Defining Network Interfaces with OIFCFG

Syntax and Commands for the OIFCFG Command-Line Tool

A Troubleshooting

Monitoring Trace Files in Real Application Clusters

Where to Find Files for Analyzing Errors

Using Log Files in Real Application Clusters

Clusterware Log Files

Enabling Addi tional Tracing for Real Application Clusters High Availability

Using Instan ce-Specific Alert Files in Real Application Clusters

Resolving Pending Shut down Issues

B Server Control (SRVCTL) Reference

Overview of SRVCTL for A dministering Real Application Clusters

Guidelines for Using SRVCTL in Real Application Clusters

Obtaining Command Line Help for SRVCTL

SRVCTL Command Syntax and Options

SRVCTL Cluster Database Configuration Tasks

SRVCTL General Cluster Database Administration Tasks

SRVCTL Node-Level Tasks

SRVCTL Comma nd Reference

SRVCTL Commands

SRVCTL Commands Summary

SRVCTL Objects Summary

srvctl add

srvctl add database

srvctl add instance

srvctl add service

srvctl add nodeapps

srvctl add asm

srvctl config

srvctl config database

srvctl config service

srvctl config nodeapps

srvctl config asm

srvctl enable

srvctl enable database

srvctl enable instance

srvctl enable service

srvctl enable asm

srvctl disable

srvctl disable database

srvctl disable ins tance

srvctl disable service

srvctl disable asm

srvctl start

srvctl start database

srvctl start instance

srvctl start service

srvctl start nodeapps

srvctl start asm

srvctl stop

srvctl stop database

srvctl stop instance< /a>

srvctl stop service

srvctl stop nod eapps

srvctl stop asm

srv ctl modify

srvctl modify database

srvctl modify instance

srvctl modify service

srvctl modify nodeapps

srvctl relocate

srvctl relocate service

srvctl status

srvctl status database

srvctl status instance

srvctl status service

srvctl status nodeapps

srvctl status asm

srvctl getenv

srvctl getenv database

srvctl getenv instance

srvctl getenv serv ice

srvctl getenv nodeapps

srvctl setenv and unsetenv

srvctl setenv database

srvctl setenv instance

srvctl setenv service

srvctl setenv nodeapps

srvctl unsetenv database

srvctl unsetenv instance

srvctl un setenv service

srvctl unsetenv nodeapps

srvctl remove

srvctl remove database

srvctl remove instance

srvctl remove service

srvctl remove nodeapps

srvctl remove asm

C Oracle Real Application Clusters Tools Messages

Overview of Real Applic ation Clusters-Specific Messages

Prefixes and Message Codes for RAC-Specific Messages

Types of Real Application Clusters Messages and Related Files

PRKA—Cluster Node Applications Messages

PRKC—Cluster Command Messages

PRKD — Global Services Daemon Messages< /dd>

PRKE — Global Services Daemon Controller Utility Messages

PRKH—Server Manager (SRVM) Messages

PRKN— Server Mana ger (SRVM) System Library Messages

PRKO—Server Control (SRVCTL) Utility Messages

PRKP—Cluster Database Management Messages

PRKR—Cluster Registry Messages

PRKS—Automatic Storage Management Messages

PRKU—Command Line Parser Utility Messages

PRKV — Virtual IP Configuration Assistant Messages

Index