Index_R

---

R

RAC diagnostics, 662–67

daemon processes, 662–67

RACDIAG.SQL, 662

See also Real Application Cluster (RAC)

RACDIAG.SQL, 662

RAC implementations, 681–717

characteristics, 125–26

Linux, 681–97

Windows, 698–717

RAID, 51–55

defined, 51

implementations, 51

RAID 0, 51–52

RAID 0+1, 53

RAID 1, 52–53

RAID 1+0, 54

RAID 5, 54–55

RAID 10, 54

Range partitioning, 258–60

columns, 259–60

first partition, 259

See also Database partitioning

Raw devices, 290–92

configuring, 292

creation of, 291, 452

defining, 290–91

setting up, 290

Read-only tablespaces, 94–95

Read/read behavior, 184–88

with no transfer, 184–86

with transfer, 186–88

See also Cache fusion

Read/write behavior, 188–90

illustrated, 189

See also Cache fusion

Real Application Cluster Guard (RACG), 423–31

advantages, 431

architecture, 424

architecture illustration, 425

components, 424–27

configuration, 427–28

configuring, for scalability, 433–35

defined, 423–24

disadvantages, 431

disk group manager, 427

hub configuration, 427, 428

implementation with active/passive state, 433

IP addresses, 425

listeners, 425

monitors, 426

operation, 430

packs, 424

primary instance failure and, 430

RAC instance, 425

restoration, 431

ring configuration, 427–28, 429

starting, 428–29

Real Application Cluster (RAC), 9–10, 61

architecture, 121–24

architecture illustration, 123

archive redo log files, 150

availability, 394

background processes, 124–28

clustered SMP for, 63

CM and, 143

components installation, 709

configuring OEM for, 537–46

configuring RMAN for, 469

control files, 149

database configuration, 711

database creation, 709–11

database design for, 233–81

database files, 147–50

data dictionary changes, 117–18

data files, 148–49

defined, 122

degree of parallelism, 220–21

features, 122

flashback queries in, 507

functionality, 13

illustrated, 394

lock modes, 182

lock structure, 181

LogMiner and, 513

materialized views and, 280

migrating from single instance to, 451–55

migrating to, 439–56

nodes, adding in, 330–31

online redo log files, 149–50

OPS vs., 114

parallel DDL, 221–22

parallel DML, 222–23

parallel processing in, 219–23

parameter changes, 116

parameter file, 147–48

read consistency in, 150–61

redo architecture in, 478–79

rollback segments, 151–54

scalability, 432–35

statistics affecting, 647–53

support, 122

terminology changes, 115–16

undo management, 154–61

write activity, 195

See also RAC diagnostics; RAC implementations

Recoverability

defined, 7

requirement, 6–7

Recovery, 144–47

architecture, 475–78

block resource claimed for, 495–96

cache, 145, 397, 486

catalog database, 465

checkpoint algorithm, 478

crash, 487, 501

database, 500

data file, 499

enqueue release, 497

failure and, 479–506

fast-start, 145, 146

FIX rule algorithm, 475–76

instance failure, 486, 488

instances, 496

interconnect failure and, 480

log force at commit algorithm, 477

media failure, 499–504

online block, 146–47

online log switching algorithm, 477

parallel, 226–27

pass 1, 494

pass 2, 497

process, 90

strategy, 471

tablespace, 499–500

thread, 500–502

transaction, 145–46, 486

transaction table and, 160

write-ahead logging algorithm, 476–77

Recovery Manager (RMAN), 7, 463–71

backup files from, 469

catalog database connection with, 468

channels, 465

components, 464

configuring, 465–68

configuring, for RAC, 469

defined, 463

features, 463–64

media management layer, 465

process, 463, 464

recovery catalog database, 465

reporting in, 469–71

scripts, 468

target database, 465

Redo

architecture, 472–75

architecture in RAC, 478–79

change vector, 473

checkpoint structure, 474–75

in crash recovery, 501

internals, 471–79

logging, 472

RBA, 473

record, 473

SCN, 472–73

threads, 474

Redo log buffers, 73–75

defined, 73

sequential use, 74

uses, 74

Redo log files, 78–79, 149–50

accessing, 511

archive, 79–81, 150, 509

configuring, 79

as core component, 79

defined, 78, 473

header, 473

instance-specific, 79

online, 509

protection, 78

See also Files

Redo log groups, 78

archive, 80

defined, 78

Redundancy

levels, 33, 390

MAA and, 436

two-node system, 390

Redundant array of inexpensive disks.

See RAID

References, 743–44

Refresh

complete, 279

fast, 279

force, 279

process, 279–80

Reliability requirement, 5

Remastering, 140, 141

Remote Diagnostic Agent (RDA), 678–79

defined, 678

installing, 678–79

reporting critical errors and, 678

REMOTE_LISTENER parameter, 541

Remote Procedure Call (RPC), 46

Reports

analysis, 527–34

backup summary data, 470

data files, 471

in RMAN, 469–71

STATSPACK, 527–34

Resource manager (RM), 172–73

Resource(s)

affinity, 140

information display, 369

mastering, 139–42

modes, 132

reconfiguration, 493

release, 494

remastering, 140, 141, 493

roles, 132

waiting active sessions, 373

Responsiveness requirement, 14

Resumable space allocation, 198

Retention table, 161

Reverse key indexes, 244–47

defined, 244

leaf block structure, 245

for OLTP applications, 247

performance, 246–47

uses, 245

values, 246

See also Indexes; Indexing

Rollback segments, 99–101

assigning, 152

creation, 101

defined, 99

as deprecated feature, 154

extent management, 153

extents, 100

implementing, 152

information on, 100, 151

private, 151–52

public, 152

RAC configuration, 151–54

See also Segments

ROLLBACK statement, 171–72

Rows

data, 106–7

directory, 105

number of physical I/O prediction, 370

number of physical read prediction, 355

physical I/O factor computation, 370

Rule-based optimizer (RBO), 107

---