Oracle9i Real Application Clusters Administration -- Index

abort mode, warning notice, 5-10

ACTIVE_INSTANCE_COUNT parameter, 2-12

adding nodes to a cluster, 9-2

administering instances

with Server Management, 5-2

administration

issues, general, 1-2

with SQL and SQL*Plus, 4-10

with SRVCTL, 4-2

affinity

awareness, 7-8

ALERT file, 8-4

alert log

managing, 3-9

alert logs, B-2

ALLOCATE EXTENT option

DATAFILE option, 3-11

instance number, 3-10

INSTANCE option, 3-11

SIZE option, 3-11

allocation

free space, 3-11

sequence numbers, 3-12

ALTER DATABASE ADD LOGFILE statement, 4-17

ALTER DATABASE statement

CLOSE clause, 4-17

ALTER ROLLBACK SEGMENT statement, 3-6

ALTER SESSION statement

SET INSTANCE clause, 3-11

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 4-17

ALTER SYSTEM ARCHIVE LOG statement, 4-17

CURRENT clause, 7-7

global log switch, 7-7

THREAD clause, 4-17

ALTER SYSTEM CHECK DATAFILES statement

instance recovery, 8-4

ALTER SYSTEM CHECKPOINT LOCAL statement, 4-17

ALTER SYSTEM CHECKPOINT statement, 7-6

global versus local, 4-17

specifying an instance, 4-17

ALTER SYSTEM privilege, 7-7, 7-8

ALTER SYSTEM SWITCH LOGFILE statement, 4-17, 7-7

DBA privilege, 7-7

applications

insert-intensive, 3-9

performance, 3-9

tuning performance, 3-9

ARCHIVE LOG command, 4-17

ARCHIVE LOG statement

CURRENT clause, 7-7

global log switch, 7-7

archive logging

enabling, 7-4

archive logs

backup, 7-6

central NFS for high availability, 6-23

configurations, implementation considerations for, 6-25

cross shared cross writing with one local and n remote configuration, 6-21

cross-mounting for writing configuration, 6-17

destinations, shared on UNIX, 6-17

file format and destination, 7-5

hybrid configuration, 6-24

no cross-mounting configuration, 6-16

one remote configuration, 6-13

recovering from one node, 7-12

restoring and recovering from all local nodes with release 1 (9.0.1), 7-13

restoring and recovering from all local nodes with release 8.1.5, 7-13

shared read configuration, 6-10

archived logs

configuration, selecting, 6-4

non-shared configuration, 6-6

archiving redo log files

forcing a log switch, 7-7

identified in control file, 3-8

log sequence number, 7-5

AUTOLOCATE

RMAN option, 8-15

Automatic Undo Management, 2-17, 3-2

using, 3-2

automatic undo management

overriding, 3-4

using, 3-2

availability

data files, 8-4

single-node failure, 8-2

steps of recovery, 8-4

background processes

SMON, 4-16, 8-2

background thread trace files, B-1

BACKGROUND_DUMP_DEST parameter, B-1, B-3

backing up the database, 7-2

backups, 7-2

and RMAN in Real Application Clusters, 7-8

archive log, 7-6

database, 7-2

files used in recovery, 8-6

general information about, 1-3

of all files from one node, 7-12

of local files from each node, 7-11

of multiple nodes using RMAN, 7-10

offline, 7-3

online, 7-2

parallel, 7-2

selecting a method and type, 7-2

to shared archivelog destinations, 7-11

using shared directories, 7-10

block media recovery, 8-7

blocks

associated with instance, 3-11, 8-2

buffer cache

instance recovery, 8-2

cache

recovery, 8-5

sequence cache, 3-12, 3-13

CACHE option, CREATE SEQUENCE, 3-12

central NFS for high availability archive logging, 6-23

CHECK DATAFILES clause

instance recovery, 8-4

checkpoints, 7-6

forcing, 7-6

client-side parameter files

naming conventions, 2-6

using, 2-5

closed backups, 7-3

Cluster Database

Destination Type tasks, 5-21

Cluster Database Instances folder

in Console Navigator window, 5-5

Cluster Database Operation Results dialog box, 5-11

Cluster Database Shutdown dialog box, 5-10

Cluster Database Shutdown Progress dialog box, 5-11

Cluster Database Started message box, 5-9

Cluster Database Startup dialog box, 5-8

Cluster Database Startup Results dialog box, 5-9

Cluster Database Startup/Shutdown Results dialog box, 5-11

Cluster Database Stopped message box, 5-11

Cluster databases

disconnecting from, 5-10

displaying objects in Console, 5-2

mounting, 5-8

shutdown, 5-11

Cluster Manager (CM)

software, 4-10

CLUSTER_DATABASE parameter, 2-14

CLUSTER_DATABASE_INSTANCES parameter, 2-14

CLUSTER_INTERCONNECTS parameter, 2-12, 2-14

clusterware layer

adding a node, 9-3

comments

specifying in server parameter file, 2-5

committed data

checkpoint, 7-6

instance failure, 8-2

sequence numbers, 3-13

common parameter files

using multiple, 2-10

complete media recovery, 8-6

concurrency

maximum number of instances, 3-10

sequences, 3-13

configuring

archive logs for backup and recovery, 6-26

Recovery Manager, 6-26

CONNECT command, 4-13, 4-14, 4-17

forcing a checkpoint, 7-7

connect strings, 4-14

CONNECT SYS

example of, 2-19

connecting

to instances, 4-13

to remote instances, 4-13

connecting to instances, 4-13

Console

Navigator window with Cluster Database objects, 5-2

right-mouse menu, 5-7

Edit, 5-14

Related Tools, 5-8

Results, 5-8, 5-11

Shutdown, 5-7, 5-9

Startup, 5-7, 5-8

View Edit Details, 5-8

scheduling jobs, 5-18

setting Cluster Database events, 5-24

starting cluster database, 5-8

stopping database, 5-9

viewing Cluster Database status, 5-14

viewing shutdown results, 5-11

viewing startup results, 5-11

Console, starting, 5-2

contention

disk, 3-5

rollback segment, 3-5

sequence number, 3-12

table data, 3-5

control file

autobackup in RMAN, 6-3

control file snapshots

configuring backups of in RMAN, 6-2

control files

backing up, 7-1

MAXLOGHISTORY, 3-8

CONTROL_FILES parameter, 2-12, 8-10

same for all instances, 2-12

CREATE DATABASE statement

MAXINSTANCES clause, 3-10

MAXLOGHISTORY clause, 3-8

Create Job property sheet, 5-18 to 5-23

General tab, 5-19

Parameters tab, 5-21

Tasks tab, 5-21

CREATE SEQUENCE statement, 3-12, 3-13

CACHE clause, 3-12, 3-13

CYCLE clause, 3-12

description, 3-12

ORDER clause, 3-12, 3-13

CREATE TABLE statement

FREELIST GROUPS clause, 3-11

FREELISTS clause, 3-11

creating

SPFILE, 2-2

cross, 6-17

cross shared cross writing with one local and n remote archive log configuration, 6-21

cross-mounting for writing archive log configuration, 6-17

CURRENT clause

checkpoints, 7-7

forcing a global log switch, 7-7

CYCLE option, CREATE SEQUENCE, 3-12

data dictionary

sequence cache, 3-13

data files

access for instance recovery, 8-4

adding, 3-2

backing up, 7-1

instance recovery, 8-4

parallel recovery, 8-6

database

backups, 7-2

number of archived log files, 3-8

number of instances, 3-10

quiescing, 4-16

starting NOMOUNT, 8-10

Database Configuration Assistant

adding instances, 9-10

and log files, 3-8

deleting instances, 9-19

placement of IFILE parameter, 2-10

DB_BLOCK_SIZE parameter, 2-12

same for all instances, 2-12

DB_DOMAIN parameter, 2-12

DB_FILES parameter, 2-12

same for all instances, 2-12

DB_NAME parameter, 2-7, 2-12, 2-14

same for all instances, 2-12

DBA_ROLLBACK_SEGS view, 3-5

DBCA

adding instances, 9-10

deleting instances, 9-19

disaster recovery, 8-9

DISCONNECT command, 4-14

disconnecting from instances, 4-14

multiple sessions, 4-16

user process, 4-15

disk

contention, 3-5

rollback segments, 3-5

DISPATCHERS parameter, 2-15

for the shared server, 2-15

distributed resources

sequence, 3-12

DML_LOCKS parameter, 2-12, 2-15

dropping a redo log file

log switch, 7-7

Edit Cluster Database dialog box, 5-14

error messages

ORA-9291, 6-26

parameter values, 2-19

errors

call trace stack, B-3

ORA-600, B-4

exclusive mode

specifying thread number, 2-19

export

raw device configuration information, 4-8

Export utility

and free lists, 3-9

extents

rollback segment, 3-5

size, 3-5

failure

access to files, 8-4

instance, 8-2

instance recovery, 8-4

media, 8-6

node, 8-2

failures

multiple node, 8-3

Fast-start checkpointing, 8-3

Fast-start fault recovery, 8-3

features, new, xxviii

file management, 3-2

files

ALERT, 8-4

archiving redo log, 7-5

control file, 3-8

dropping, 7-7

redo log, 7-5

renaming, 7-7

restricted operations, 7-7

used in recovery, 8-6

FORCE mode, warning notice, 5-8

foreground processes

instance shutdown, 4-15

free list groups

assigned to instance, 3-10

free lists, 3-11

and Export utility, 3-9

free space

managing with SQL, 3-11

FREELIST GROUPS

storage option, instance number, 3-10

FREELIST GROUPS option, 3-10

GCS

recovery steps, 8-4

General tab, from Create Job property sheet, 5-19

Global Cache Service resource

sequence, 3-12

GLOBAL clause

forcing a checkpoint, 4-17, 7-7

global constant parameters

same for all instances, 2-12

Global Services Daemon (GSD), 4-9, 9-10

Globalization Support parameters, 2-16

groups

redo log files, 3-7

unique numbers, 3-8

V$LOGFILE, 3-8

GSD

as a background process for manageability tools, 4-9

UNIX implementation of, 4-9

Windows implementation of, 4-9

gsdservice -install

create services, 4-9

gsdservice -remove

to stop and delete services, 4-9

gsdservice -start

to start services, 4-9

history

archive, 8-8

HOST command, 4-17

hybrid archive logging, 6-24

IFILE

parameter placement in instance-specific parameter files, 2-10

IFILE parameter

multiple files, 2-10

overriding values, 2-10

specifying identical parameters, 2-18

import

raw device configuration information, 4-8

incomplete media recovery, 8-7

initdb_name.ora file

BACKGROUND_DUMP_DEST parameter, B-1, B-3

DB_NAME parameter, 2-7

USER_DUMP_DEST parameter, B-2

initdb_name.ora file

described, 2-8

INITIAL storage parameter

rollback segments, 3-5

initialization parameter files

definition, 2-6

for instances, 2-1

initdb_name.ora, 2-8

initsid.ora, 2-7

initialization parameters

duplicate values, 2-10

identical for all instances, 2-12

multiple instance issues regarding, 2-14

setting for multiple instances, 2-12

that must be identical on all instances, 2-12

that must be unique on all instances, 2-13

init.ora file

defined, 2-7

initsid.ora file

described, 2-7

initsid.ora file

described, 2-7

inserts

performance, 3-9

INSTANCE clause

SHOW INSTANCE command, 4-14

INSTANCE_NAME parameter

unique values for instances, 2-15

INSTANCE_NUMBER

setting, 2-19

INSTANCE_NUMBER parameter, 2-13, 2-19

and SQL options, 3-11

exclusive or shared mode, 2-19

recommended settings for, 2-19

unique values for instances, 2-19

instances

adding at the Oracle layer, 9-10

associated with data block, 3-11

associating with free list groups, 3-9

associating with free lists, 3-10

connecting to, 4-13

current, 4-14, 7-7

deleting with the DBCA, 9-19

failure, 8-3

failures, recovery from, 8-2

initialization parameter files, 2-1

initsid.ora file, 2-7

instance number, 3-10

maximum number, 3-5, 3-10

recovery, 4-16, 8-2

recovery, abnormal shutdown, 4-16

recovery, access to files, 8-4

recovery, data file access, 8-4

recovery, global checkpoint, 7-7

recovery, multiple failures, 8-3

remote, 2-18, 4-14

rollback segment required, 3-5

Server Management, 5-2

setting, 4-13

shutting down, 4-15

sid, 2-7

startup and shutdown results, 5-11, 5-15

startup order, 2-19

thread number, 2-19

verifying, 4-15

Introduction, 1-1

jobs

choosing tasks for, 5-21

creating for cluster database, 5-18

setting up rights for running, 5-22

specifying information for, 5-19

specifying parameters for server management tasks, 5-21

LISTENER

parameter for the shared server, 2-15

LOCAL clause

forcing a checkpoint, 4-17, 7-7

local instances

nodes, 4-14

log files

redo log file, 7-1

log history, 8-8

log sequence numbers, 7-5

log switches, 3-8, 7-6

forcing, 7-7, 7-8

forcing on a closed thread, 7-8

forcing on closed threads, 7-8

LOG_ARCHIVE_DEST parameter, 2-12, 6-8, 8-9

specifying for recovery, 6-8, 8-9

LOG_ARCHIVE_DEST_n parameter, 7-4

LOG_ARCHIVE_FORMAT parameter, 2-16, 6-8, 7-4, 7-5, 8-9

same for all instances, 6-8, 8-9

used in recovery, 6-8, 8-9

LOG_ARCHIVE_START parameter

automatic archiving, 2-10

LOG_CHECKPOINT_TIMEOUT parameter

inactive instance, 7-7

LSNRCTL utility

START command, 4-10, 4-11

Massively Parallel Processing System, 3-10

MAX_COMMIT_PROPAGATION_DELAY parameter, 2-12, 2-16

MAXEXTENTS storage parameter

automatic allocations, 3-12

MAXINSTANCES clause, 3-10

MAXINSTANCES option, 3-10

MAXINSTANCES parameter, 3-11

assigning free lists to instances, 3-10

MAXLOGHISTORY option, 3-8

media failures, 8-6

recovery from, 8-5

media recovery

block media recovery, 8-7

complete, 8-6

incomplete, 8-7

incomplete, O/S utilities, 8-7

log history, 8-8

memory

SGA, 3-13

messages

access to files, 8-4

ALERT file, 8-4

instance shutdown, 4-15

migrating

Oracle8i configurations to Oracle9i, 4-8

MINEXTENTS storage parameter

automatic allocations, 3-12

modified data

instance recovery, 8-2

modulo, 3-10

multiple node failures, 8-3

multiple nodes

starting from one node, 2-18

multiplexed redo log files, 3-7

example, 3-8

naming conventions

for client-side parameter files, 2-6

Navigator window

Cluster Database objects, 5-2

Cluster Database Instances folder, 5-5

right-mouse menu, 5-7, 5-11

Edit, 5-14

Related Tools, 5-8

Results, 5-8

Shutdown, 5-7, 5-9

Startup, 5-7, 5-8

View Edit Details, 5-8

setting Cluster Database events, 5-24

starting cluster database, 5-8

stopping database, 5-9

viewing Cluster Database status, 5-14

viewing shutdown results, 5-11

viewing startup results, 5-11

new features, xxviii

NEXT storage parameter, 3-5

NFS

for high availability, 6-25

on UNIX, using, 6-25

no cross-mounting archive log configuration, 6-16

nodes

adding at the clusterware layer, 9-3

adding at the Oracle layer, 9-9

adding to cluster, 9-2

affinity awareness, 7-8

backing up multiple with RMAN using several channels, 7-10

failure of, 8-2

local, 2-18

parallel backup, 7-2

remote, 4-14

NOMOUNT option, 8-10

non-shared archive log destinations

and backups from each node, 7-11

non-shared archive logging

restore and recovery, 6-9

non-shared archived log configuration, 6-6

NOORDER option, CREATE SEQUENCE, 3-13

number generator, 3-12

offline backups

parallel, 7-2

redo log files, 7-3

offline tablespaces

restrictions, 3-5

one remote archive log configuration, 6-13

online backups, 7-4

block media recovery, 8-7

parallel, 7-2

redo log files, 7-2

online recovery, 8-2, 8-4

online redo log files

archiving, 7-1, 7-2

log switch, 7-7

thread of redo, 2-19

open backups, 7-2

operating system

privileges, 4-18

operating system utilities

for recovery, 8-8

operating system-specific Oracle documentation

archived redo log name, 7-5

ORA-600, B-4

ORA-9291 message, 6-26

Oracle Database Configuration Assistant

troubleshooting, 9-11

Oracle Enterprise Manager

Events

Cluster Database events, 5-24

performing administration with, 1-3

scheduling jobs, 5-18

starting

cluster database, 5-8

stopping database, 5-9

viewing

Cluster Database status, 5-14

shutdown results, 5-11

startup results, 5-11

Oracle layer

adding a node, 9-9

Oracle Real Application Clusters

creating a job on, 5-18

Oracle8i

migrating to Oracle9i, 4-8

Oracle9i

migrating from Oracle8i, 4-8

Oracle9i Real Application Clusters

overview, 1-1

oraxxxxx.trc file, B-2

ORDER option, 3-12, 3-13

Output tab

from Cluster Database Operation Results dialog box, 5-13

parallel backups, 7-2

parallel mode

sequence restrictions, 3-13

parallel recovery, 8-6, 8-12, 8-13

PARALLEL_MAX_SERVERS parameter, 8-12, 8-13

Parameter, 2-1

parameter file

server file, backing up, 2-2

server file, exporting, 2-4

server file, setting parameters in, 2-2

server file, using, 2-2

parameter files

backing up, 7-1

client-side, using, 2-5

common file, 2-18

duplicate values, 2-10

instance-specific, 2-11

location, 2-11

PFILE, 2-18

remote instance, 2-18

remote instances, 4-14

parameters

database creation, 3-10

initialization, 2-1, 3-1

instance-specific settings in server parameter file, 2-4

management of, 1-2

setting for multiple instances, 2-12

storage, 3-5

that must be identical on all instances, 2-12

types of, 2-12

Parameters tab

from Create Job property sheet, 5-21

partitioning data

rollback segments, 3-5

performance

application, 3-9

caching sequences, 3-13

inserts and updates, 3-9

rollback segments, 3-5

sequence numbers, 3-13

private rollback segments, 2-13, 3-5

specifying, 3-6

privileges

ALTER SYSTEM, 7-7, 7-8

PROCESSES parameter, 2-17

PROTOCOL

parameter for the shared server, 2-15

public rollback segments, 3-5

quiesce database

in Real Application Clusters, 4-16

raw device configuration information

export, 4-8

import, 4-8

Real Application Clusters

initialization parameter files, 2-7

Real Application Clusters databases

starting, 4-10

RECOVER command, 4-17, 8-13

recovery, 8-1

access to files, 8-4

after SHUTDOWN ABORT, 4-16

block media recovery, 8-7

disaster, 8-9

from an offline backup, 8-9

from an online backup, 8-9

from multiple node failure, 8-3

from single-node failure, 8-2

general information about, 1-3

global checkpoint, 7-7

incomplete media, 8-7

instance, 4-16, 8-2

log history, 8-8

media failure, 7-7, 8-6

media failures, 8-5

online, 8-2

parallel, 8-12, 8-13

PARALLEL_MAX_SERVERS parameter, 8-12, 8-13

recovery time, 7-7

setting parallelism, 8-12, 8-13

steps of, 8-4

using operating system utilities, 8-8

using redo log, 7-2

Recovery Manager

archive log backup, 7-6

configure archive logs, 6-26

disaster recovery, 8-9

incomplete media recovery, 8-7

media failures, 8-6

RECOVERY_PARALLELISM parameter, 2-17, 8-12, 8-13

redo log files

archiving, 7-1, 7-2, 7-7

backup, 7-2, 7-3

dropping, 7-7

identified in control file, 3-8

instance recovery, 8-2

log sequence number, 7-5

renaming, 7-7

using, 3-7

redo log groups, 3-7

redo logs

format and destination specifications, 7-5

Registering, 5-24

remote instances, 2-18, 4-14

renaming a file

log switch, 7-7

resources

associating with free list groups, 3-9

releasing, 8-2

restrictions

cached sequence, 3-13

offline tablespace, 3-5

RETRY option

STARTUP PARALLEL command, 4-12

RMAN

archived log configuration schemes, 6-5

AUTOLOCATE option, 8-15

backups in Real Application Clusters, 7-8

in Real Application Clusters, overview of using, 6-2

restoring archive logs with, 8-14

rollback segment

SYSTEM, 3-4

rollback segments

contention, 3-5

multiple, 3-5

online, 3-5

private, 3-5

public, 3-5

public versus private, 3-5

tablespace, 3-5

ROLLBACK_SEGMENTS parameter, 2-13, 2-17, 3-6

rolling back

instance recovery, 8-2

ROW_LOCKING parameter, 2-12, 2-13

scaling

adding instances, 9-10

adding nodes, 9-3

adding nodes and instances, 9-1

general information about, 1-3

Select Instances to Start dialog box, 5-9

Select Instances to Stop dialog box, 5-11

sequence number generator, 3-12

distributed resources, 3-12

in Real Application Cluster databases, 3-12

restriction, 3-13

skipping sequence numbers, 3-13

sequence numbers

CACHE option, 3-12

ORDER option, 3-13

sequences

data dictionary cache, 3-12, 3-13

log sequence number, 7-5

not cached, 3-13

timestamp, 3-13

SERIALIZABLE parameter, 2-12

Server Control

using, 4-2

Server Management

administration of instances, 5-2

server parameter file

backing up, 2-2

backups and restores of, 8-10

exporting, 2-4

instance specific settings, 2-4

setting values in, 2-2

using, 2-2

SERVICE_NAMES parameter, 2-12

sessions

multiple, 4-14, 4-16

SESSIONS_PER_USER parameters, 2-17

SET INSTANCE command, 2-18, 4-13

example of, 2-18

instance startup, 4-14

setting instances, 4-13

shared archivelog destinations

backups to, 7-11

shared directories

and backups, 7-10

shared drives

using, on Windows platforms, 6-26

shared mode

instance number, 2-19

instance recovery, 8-2

shared read archive log configuration, 6-10

shared server

parameters for, 2-15

SHOW INSTANCE command, 4-14, 4-17

SHOW PARAMETER command, 4-17

SHOW PARAMETERS command, 4-17

example of, 2-19

SHOW SGA command, 4-17

SHUTDOWN ABORT command, 4-16

SHUTDOWN command, 4-17

ABORT option, 4-16

IMMEDIATE option, 4-16

specifying an instance, 4-14

SHUTDOWN TRANSACTIONAL, 4-16

shutdown types, 5-10

abort, 5-10

immediate, 5-10

normal, 5-10

shutdown database and other services, 5-10

shutdown database only, 5-10

shutting down

instances, 4-15

shutting down a cluster database

setting parameters, 5-23

shutting down a database

viewing results, 5-11

shutting down an instance

abnormal shutdown, 4-16

archiving redo log files, 7-7

forcing a log switch, 7-7

lost sequence numbers, 3-13

shutting down a cluster database, 5-11

shutting down instances, 4-15

sidalrt.log file, B-2

sidbsp0.trc file, B-2

siddbwr.trc file, B-2

sidlckn.trc file, B-2, B-4

sidlmdn.trc file, B-2

sidlmon.trc file, B-2

sidp00n.trc file, B-2

sidsmon.trc file, B-2

SMON process

instance recovery, 8-2, 8-3

recovery after SHUTDOWN ABORT, 4-16

snapshot control file, 6-3

SPFILE

creating, 2-2

SPFILE parameter, 2-17

SQL statements

instance-specific, 4-17

SQL*Plus sessions

multiple, 4-16

SRVCONFIG

importing and exporting raw device configuration with, 4-8

SRVCTL

using, 4-2

srvctl add db command, 4-6

srvctl add instance command, 4-6

srvctl config command, 4-5

srvctl delete db command, 4-6

srvctl delete instance command, 4-6

srvctl get env command, 4-5

srvctl move instance command, 4-7

srvctl rename instance command, 4-7

srvctl set env command, 4-7

srvctl start command, 4-3

srvctl status command, 4-4

srvctl stop command, 4-4

srvctl unset env command, 4-7

SRVCTL utility

commands that update the configuration, 4-5

using to administer instance configurations, 4-2

start services

with gsdservice, 4-9

starting

listener, 4-10, 4-11

cluster database, 5-8

Real Application Clusters database, 4-10

Starting OEM Console, 5-2

starting up

remote instance, 4-14

rollback segments, 3-5

startup

and parameters, 2-18

on remote nodes, 2-18

remote instance, 2-18

results, 5-11

setting cluster database parameters for, 5-21

startup order, 2-19

STARTUP command, 2-18, 4-17

specifying an instance, 4-14

startup types, 5-8

force, 5-8

mount, 5-8

no mount, 5-8

open, 5-8

restrict, 5-9

Status Details tab, 5-12

from Cluster Database Operation Results dialog box, 5-12

from Edit Cluster Database dialog box, 5-16

Status tab

from Edit Cluster Database dialog box, 5-15

stop and delete services

with gsdservice, 4-9

stopping

database, 5-9

storage

administering, 1-2

storage options

extent size, 3-5

rollback segment, 3-5

SYSDBA

privilege for connecting, 4-14

SYSDBA privilege, 5-22

SYSOPER privilege, 5-22

for connecting, 4-14

system change numbers

archive file format, 7-5

System Global Area (SGA)

sequence cache, 3-12

SYSTEM rollback segment, 3-4

tables

allocating extents, 3-11

contention, 3-5

tablespace, 3-5

tablespaces

active rollback segments, 3-5

offline, 3-5

parallel backup, 7-2

parallel recovery, 8-6

rollback segment, 3-5

switching for undo, 3-3

tables, 3-5

taking offline, 3-5

Tasks tab

from Create Job property sheet, 5-21

THREAD clause, 4-17, 7-7

THREAD parameter, 2-13, 2-17

THREAD statement

for backing up archivelogs, 7-10

threads

archive file format, 7-5

archiving redo log files, 7-7

enabled, 8-8

example, 3-7

exclusive mode, 2-19

forced log switch, 7-7

number of groups, 3-7

threads of redo, 3-7

trace files, B-1

background thread trace files, B-1

error call trace stack, B-3

managing, 3-9

oraxxxxx.trc, B-2

sidalrt.log, B-2

sidbsp0.trc, B-2

siddbwr.trc file, B-2

sidlckn.trc, B-2, B-4

sidlmdn.trc, B-2

sidlmon.trc, B-2

sidp00n.trc, B-2

sidsmon.trc file, B-2

transactions

committed data, 7-6

instance failure, 8-2

rolling back, 8-2

sequence numbers, 3-12

waiting for recovery, 8-2

troubleshooting, B-1 to B-4

general information about, 1-4

Oracle Database Configuration Assistant, 9-11

trace files, B-1

undo tablespace

switching, 3-3

UNDO_MANAGEMENT parameter, 3-2, 3-4

UNDO_TABLESPACE parameter, 3-3

updates

performance, 3-9

user processes

associating with free lists, 3-11

free lists, 3-11

instance shutdown errors, 4-15

user trace files, B-2

USER_DUMP_DEST parameter, B-2

users

associating with free list groups, 3-9

utilities

operating system, for recovery, 8-8

V$ACTIVE_INSTANCES, 4-15

V$ACTIVE_INSTANCES table, 5-15

V$FAST_START_SERVERS

view, 8-13

V$FAST_START_TRANSACTIONS

view, 8-13

V$LOGFILE view, 3-8