Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

What's New in Administration?

Oracle Database 10g New Features for Real Application Clusters Administration

1 Introduction to Administration

Introduction to Administering Real Application Clusters

Administering Real Application Clusters

Database Instance Management and Database Administration in RAC

Storage Management in Real Application Clusters

Administering Services in Real Application Clusters

Additional Real Application Clusters Administrative Topics

Overview of Using Enterprise 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 Manager

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 Shutting 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

Exporting the Server Parameter File for Backward Compatibility

Initialization Parameter 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 Management

Automatic Storage Management Components in RAC

Modifying Disk Group Configurations for ASM in RAC

Administering ASM Instances and ASM Disk Groups with Enterprise Manager in RAC

Administering ASM Instances with SRVCTL in RAC

Datafile Access in Real Application Clusters

Redo Log File Storage in Real Application Clusters

Automatic Undo Management in Real Application Clusters

Switching Undo Tablespaces for Instances in Real Application 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

Restoring the Oracle Cluster Registry on Windows-Based Systems

Managing the Oracle Cluster Registry with OCR Exports

Importing Oracle Cluster Registry Content on UNIX-Based Systems

Importing Oracle Cluster Registry Content on Windows-Based Systems

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 Exporting Cluster Database Configuration Information with SRVCONFIG

4 Administering Services

Services and High Availability in Real Application Clusters

Adding and Modifying Services

Using the DBCA to Add and Modify Services

Automatic Restarts after Failures

Administering Services with Enterprise Manager and SRVCTL

Administering Services in Real Application Clusters with 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 Users

Checking the Installation

Step 2: Extending Clusterware and Oracle Software to New Nodes

Adding Nodes at the Vendor 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

Configure Raw Storage on UNIX-Based Systems

Configure Raw Partitions on Windows-Based Systems

Step 4: Adding Nodes at the Oracle RAC Database Layer

Step 5: Adding Database Instances to New Nodes

Adding Nodes 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 Systems

Deleting Nodes from Oracle Clusters on Windows-Based Platforms

6 Configuring Recovery Manager and Archiving

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 Settings 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

Monitoring 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

Using 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 Awareness of Fast Connections

Readability of Files To Be Backed Up

Deleting Archived Redo Logs After a Successful Backup

Distribution of Backups

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 Scheme

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

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

Non-Cluster File System Restore Scheme

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

RMAN Recovery Through Resetlogs in Real Application Clusters

Parallel Recovery in Real Application Clusters

Parallel Recovery with RMAN

Parallel Recovery with SQL*Plus

Using a Flash Recovery Area in Real Application Clusters

8 Administrative Options

Optional Enterprise Manager Tasks in Real Application Clusters

Using Enterprise Manager to Discover Nodes and Instances

Enterprise Manager Pages for Real Application Clusters

Databases Summary Page

Cluster Database Home Page

Cluster 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 Clusters Administration Procedures for Enterprise Manager

Administering Enterprise Manager Jobs in Real Application Clusters

Creating Enterprise Manager Jobs in Real Application Clusters

Administering Alerts in Real Application Clusters 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 Application 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 Additional Tracing for Real Application Clusters High Availability

Using Instance-Specific Alert Files in Real Application Clusters

Resolving Pending Shutdown Issues

B Server Control (SRVCTL) Reference

Overview of SRVCTL for Administering 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 Command Reference

SRVCTL Commands

SRVCTL Commands Summary

SRVCTL Objects Summary

srvctl add database

srvctl add instance

srvctl add service

srvctl add nodeapps

srvctl config database

srvctl config service

srvctl config nodeapps

srvctl config asm

srvctl enable database

srvctl enable instance

srvctl enable service

srvctl enable asm

srvctl disable database

srvctl disable instance

srvctl disable service

srvctl disable asm

srvctl start database

srvctl start instance

srvctl start service

srvctl start nodeapps

srvctl start asm

srvctl stop database

srvctl stop instance

srvctl stop service

srvctl stop nodeapps

srvctl stop asm

srvctl modify database

srvctl modify instance

srvctl modify service

srvctl modify nodeapps

srvctl relocate

srvctl relocate service

srvctl status database

srvctl status instance

srvctl status service

srvctl status nodeapps

srvctl status asm

srvctl getenv database

srvctl getenv instance

srvctl getenv service

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 unsetenv service

srvctl unsetenv nodeapps

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 Application 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

PRKE — Global Services Daemon Controller Utility Messages

PRKH—Server Manager (SRVM) Messages

PRKN— Server Manager (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