Index

A B C D E F G H I J L M N O P Q R S T U V W

A

Additional Real Application Clusters documentation, 1.1

administering instances

with Server Management, 8.1

affinity

awareness, 7.1.7

alert log

managing, A.1

alert logs, A.3

ALTER DATABASE statement

CLOSE clause, 8.6.1

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 8.6.1

ALTER SYSTEM ARCHIVE LOG statement, 8.6.1

INSTANCE option, 8.6.1

ALTER SYSTEM CHECKPOINT LOCAL statement, 8.6.1

ALTER SYSTEM CHECKPOINT statement

global versus local, 8.6.1

specifying an instance, 8.6.1

ALTER SYSTEM SET CHECKPOINT LOCAL statement, 8.6.1

ALTER SYSTEM SWITCH LOGFILE statement, 8.6.1, 8.6.1

ARCHIVE LOG command, 8.6.1

archive logs

file format and destination, 6.5

file naming, 6.4

archiving redo log files

identified in control file, 3.1.7

log sequence number, 6.5

ASM

see Automatic Storage Management

asm

as SRVCTL noun, B.7.2

Automatic Storage Management, 3.1

Automatic Storage Management instance, 3.1.2

B

background processes

SMON, 2.3, 7.1.1

background thread trace files, A.1.1

BACKGROUND_DUMP_DEST parameter, A.1.1, A.3

backups

server parameter file, 2.7

blocks

associated with instance, 7.1.1

buffer cache

instance recovery, 7.1.1

C

Cluster Database Management Error Messages (PRKP), C.9, C.9

cluster file system

storage in Real Application Clusters, 3.1

Cluster Manager (CSS)

log files, A.2.1

Cluster Ready Services (CRS), 3.1.10

comments

specifying in server parameter file, 2.4.1.1

committed data

instance failure, 7.1.1

configuration problems

reinitializing the OCR, 3.1.11

CONNECT command, 2.2.2, 8.6.1, 8.6.1

CONNECT SYS

example of, 2.3.2

connecting

to instances, 2.2.2

control files

MAXLOGHISTORY, 3.1.7

CREATE DATABASE statement

MAXLOGHISTORY clause, 3.1.7

creating

server parameter files, 2.4, 2.7

D

database

as SRVCTL noun, B.7.2

number of archived log files, 3.1.7

quiescing, 8.7

Database Configuration Assistant

Database Storage page, 5.6

Instance Management page, 5.6

List of Cluster Database Instances page, 5.6

List of Cluster Databases page, 5.6

Operations page, 5.6

Summary dialog, 5.6

Welcome page, 5.6

Database Storage page, 5.6

DISCONNECT command, 2.2.2

disconnecting from instances, 2.2.2

documentation

Oracle Real Application Clusters Deployment and Performance Guide, 1.1.1

Real Application Clusters, 1.1

E

Enterprise Manager, 2.2.1, 8.1

error messages

for management tools, C

Event Manager (EVM)

log files, A.2.1

F

failure

instance, 7.1

multiple node, 7.1.2

node, 7.1.1

features

new, Preface

features, new, Preface

files

archiving redo log, 6.5

control file, 3.1.7

redo log, 6.5

G

GLOBAL clause

forcing a checkpoint, 8.6.1

H

HOST command, 8.6.1, 8.6.1

I

initdb_name.ora file

BACKGROUND_DUMP_DEST parameter, A.1.1, A.3

USER_DUMP_DEST parameter, A.1.1

initialization parameters

cluster database issues regarding, 2.6

RECOVERY_PARALLELISM, 7.6.2

that must be identical on all instances, 2.5.1

that must be unique on all instances, 2.5.2

instance

as SRVCTL noun, B.7.2

Instance Management page, 5.6

INSTANCE option, 8.6.1

INSTANCE_NUMBER parameter, 2.5.2

instances

failure, 7.1.2

failures, recovery from, 7.1

recovery, 2.3, 7.1.1

recovery, abnormal shutdown, 2.3

recovery, multiple failures, 7.1.2

Server Management, 8.1

shutting down, 2.3

verifying, 8.6.2, 8.6.2, 8.6.2

J

java-based tools

tracing, A.2.2

L

List of Cluster Database Instances page, 5.6

List of Cluster Databases page, 5.6

LOCAL clause

forcing a checkpoint, 8.6.1

log files

for CRS, A.2.1, A.2.1

for CSS, A.2.1

for EVM, A.2.1

for OCR, A.2.1

log sequence numbers, 6.5

log switches, 3.1.7

LOG_ARCHIVE_FORMAT parameter, 6.5

M

MAXLOGHISTORY option, 3.1.7

media failures

recovery from, 7.3

messages

errors for management tools, C

modified data

instance recovery, 7.1.1

multiple node failures, 7.1.2

multiple nodes

starting from one node, 2.3.2

multiplexed redo log files, 3.1.7

N

network interfaces

defining with OIFCFG, 8.8.1

new features, Preface

nodeapps

as SRVCTL noun, B.7.2

nodes

affinity awareness, 7.1.7

failure of, 7.1.1

O

ocrconfig -export, 3.1.12

OIFCFG, 8.8

commands, 8.8.2, 8.8.2

defining network interfaces, 8.8.1

if_name element, 8.8.2

if_type element, 8.8.2

nodename element, 8.8.2

subnet element, 8.8.2

syntax, 8.8.2

online recovery, 7.1.1

operating system-specific Oracle documentation

archived redo log name, 6.5

Operations page, 5.6

Oracle Cluster Registry (OCR), 3.1.10

administering, 3.1.10

log files, A.2.1

managing, 3.1.10

Oracle Interface Configuration tool

see OIFCFG

Oracle Real Application Clusters

overview of administration, 1

ORACLE_SID parameter, 2.5.2

oraxxxxx.trc file, A.1.1

P

parallel recovery, 7.6.2

PARALLEL_MAX_SERVERS parameter, 7.6.2

parameter file

overview, 2.4

parameter files

server file, exporting, 2.4.2

parameters

that must be identical on all instances, 2.5.1

that must be unique on all instances, 2.5.2

PRKC messages, C.3

PRKP

messages, C.9

PRKR

messages, C.10

Q

quiesce database

in Real Application Clusters, 8.7

R

RECOVER command, 7.6.2, 8.6.1, 8.6.1

recovery

after SHUTDOWN ABORT, 2.3

from multiple node failure, 7.1.2

from single-node failure, 7.1.1

instance, 2.3

media failures, 7.3

online, 7.1.1

parallel, 7.6.2

PARALLEL_MAX_SERVERS parameter, 7.6.2

RECOVERY_PARALLELISM parameter, 7.6.1, 7.6.2

redo log files

identified in control file, 3.1.7

instance recovery, 7.1.1

log sequence number, 6.5

using, 3.1.7

redo log groups, 3.1.7

redo logs

format and destination specifications, 6.5

Repository Error Messages (PRKR), C.10

resources

releasing, 7.1.1

rolling back

instance recovery, 7.1.1

S

scalability

adding nodes and instances, 5.1

sequences

log sequence number, 6.5

Server Management

administration of instances, 8.1

server parameter file

backing up, 2.7

exporting, 2.4.2

setting values in, 2.4.1

server parameter files

creating, 2.4, 2.7

service

as SRVCTL noun, B.7.2

SERVICE_NAMES

parameter, 4.2.1

services, 4.1.1

adding, modifying, 4.2

names, limitations for, 4.2.1

sessions

multiple, 2.2.2

setting instances, 2.2.2

SHOW INSTANCE command, 8.6.1, 8.6.1

SHOW PARAMETER command, 8.6.1

SHOW PARAMETERS command, 8.6.1

SHOW SGA command, 8.6.1, 8.6.1

SHUTDOWN ABORT command, 2.3

SHUTDOWN command, 8.6.1

ABORT option, 2.3

SHUTDOWN TRANSACTIONAL, 2.3

shutting down

instances, 2.3

shutting down an instance

abnormal shutdown, 2.3

shutting down instances, 2.3

sidalrt.log file, A.3

siddbwr.trc file, A.1.1

sidsmon.trc file, A.1.1

SMON process

instance recovery, 7.1.1, 7.1.2

recovery after SHUTDOWN ABORT, 2.3

snapshot control file, 6.2

SQL statements

instance-specific, 8.6.1

SQL*Plus, 2.2.2, 8.6

SRVCONFIG

importing and exporting SRVM information with, 3.2

SRVCTL

add asm command, B.7.3.5.1

add database command, B.7.3.1.1

add instance command, B.7.3.2.1

add nodeapps command, B.7.3.4.1

add service command, B.7.3.3.2

add, usage description, B.7.3

cluster database configuration tasks, B.3

cluster database tasks, B.4

concurrent commands, B.1.1

config asm command, B.7.4.4.1

config database command, B.7.4.1.1

config nodeapps command, B.7.4.3.1

config service command, B.7.4.2.1

config, usage description, B.7.4

disable asm command, B.7.6.4.1

disable database command, B.7.6.1.1

disable instance command, B.7.6.2.1

disable service command, 4.4.2.2, B.7.6.3.1

disable, usage description, B.7.6

enable asm command, B.7.5.4.1

enable database command, B.7.5.1.1

enable instance command, B.7.5.2.1

enable service command, 4.4.2.2, B.7.5.3.1

enable, usage description, B.7.5

getenv database command, B.7.12.1.2

getenv instance command, B.7.12.2.1

getenv nodeapps command, B.7.12.4.1

getenv service command, B.7.12.3.1

getenv, usage description, B.7.12

modify database command, B.7.9.1.1

modify instance command, B.7.9.2.1

modify nodeapps command, B.7.9.4.1

modify service command, B.7.9.3.1

modify, usage description, B.7.9

node-level tasks, B.5

overview, 2.2.3

relocate service command, B.7.10.1.1

relocate, usage description, B.7.10

remove asm command, B.7.14.5.1

remove database command, B.7.14.1.1

remove instance command, B.7.14.2.1

remove nodeapps command, B.7.14.4.1

remove service command, B.7.14.3.1

remove, usage description, B.7.14

setenv database command, B.7.13.1.2

setenv instance command, B.7.13.2.1

setenv nodeapps command, B.7.13.4.2

setenv service command, B.7.13.3.1

setenv, usage description, B.7.13

start asm command, B.7.7.5.1

start database command, 2.3.3, B.7.7.1.1

start instance command, 2.3.3, B.7.7.2.1

start nodeapps command, B.7.7.4.1

start service command, 4.4.2.1, 4.4.2.1, B.7.7.3.1

start, usage description, B.7.7

status asm command, B.7.11.5.1

status database command, B.7.11.1.1

status instance command, B.7.11.2.1

status nodeapps command, B.7.11.4.1

status service command, 4.4.2.4, B.7.11.3.1

status, usage description, B.7.11

stop asm command, B.7.8.5.1

stop database command, 2.3.3, B.7.8.1.1

stop instance command, 2.3.3, B.7.8.2.1

stop nodeapps command, B.7.8.4.1

stop service command, B.7.8.3.1

stop, usage description, B.7.8

unsetenv database command, B.7.13.5.2

unsetenv instance command, B.7.13.6.1

unsetenv nodeapps command, B.7.13.8.1

unsetenv service command, B.7.13.7.2

unsetenv, usage description, B.7.13

STARTUP command, 8.6.1

storage

cluster file system, 3.1

Summary dialog, 5.6

SYSDBA

privilege for connecting, 2.2.2

SYSOPER privilege

for connecting, 2.2.2

system change, 6.5

T

THREAD parameter, 2.6

trace files, A.1.1

background thread trace files, A.1.1

managing, A.1

oraxxxxx.trc, A.1.1

sidalrt.log, A.3

siddbwr.trc file, A.1.1

sidsmon.trc file, A.1.1

tracing

for CRS, A.2.2

java-based tools, A.2.2

transactions

instance failure, 7.1.1

rolling back, 7.1.1

waiting for recovery, 7.1.1

troubleshooting, A.1.1

U

UNDO_TABLESPACE parameter, 2.5.2

user trace files, A.1.1

USER_DUMP_DEST parameter, A.1.1

V

V$ACTIVE_INSTANCES, 8.6.2, 8.6.2

verification

datafiles, online files, 3.1.6

W

Welcome page, 5.6