Pro Oracle Database 11g Administration (112 page)

39–40, 461

dropping, 411

remotely installing, 18–23

removing from, 411

copying installation media to remote server,

REFRESH procedure, DBMS_MVIEW package,

20

367, 371, 396

ensuring DISPLAY variable is set, 21–22

refreshes

executing runInstaller utility, 22

monitoring, 400–403

installing required software on local PC, 19

determining progress of, 401

logging in to remote computer, 21

monitoring real-time refresh progress,

running xhost command, 21

401–402

starting X session, 19–20

within time periods, 402–403

troubleshooting, 22

viewing last refresh times, 400–401

REMOVE procedure, DBMS_JOB package, 399

MV groups, 409

removing

refreshed on commit, 378–379

control files, 97–98

remote, 403–407

data from tables, 153–154

architectures of, 404–405

for LOBs, 253–254

determining references to log, 406–407

redo log files from groups, 107

viewing base-table information, 405–406

RENAME statement, 200, 203, 209

refreshing MVs, 395–400

renaming

automating refreshes using shell script and

columns, 149

scheduling utilities, 397–398

database, 543

manually, from SQL*Plus, 396

datafiles, 85–90, 539–540

ORA-12034 error, 399–400

indexes, 188

performing, 399

partitions, 295

refresh intervals, 398–399

sequences, 209

REG_IDX1 bitmap index, 180

synonyms, 203

REGION column, 179, 198

tables, 147

REGION table, 381, 384

tablespaces, 76

REGISTER DATABASE command, 484

views, 200

REGISTRATIONS table, 129, 393

rends command, 559

REG_MID partition, 296

renlog.sql file, 541–542

REG_MID_A partition, 300

renmf command, 555

REG_MID_B partition, 296

renssel command, 556

REG_P_1 partition, 296

renuser command, 554

REG_P_2 partition, 296

REPAIR command, 514

REG_SALES column, 288

REPAIR FAILURE command, 514

REG_TBSP_3 tablespace, 339

repairing failures, 514–515

REG_WEST partition, 288

REPEAT_INTERVAL column, 572

reinstalling, 16–17

REPEAT_INTERVAL parameter, 571

remapping data, 332–333

667

■ INDEX

REPLACE option, 331

RESTORE DATDABASE command, 520

REP_MV user, 403

restore points, flashing back tables to, 453–454

REPORT command, 504–505

RESTORE statement, 443–444

REPORT SCHEMA command, 491, 521, 540

RESTORE TABLESPACE command, 519

--requires option, 565

RESTORE...PREVIEW command, 516

rerunning commands, 57–59

RESTORE...VALIDATE command, 500–501, 517,

listing command history, 58–59

592–593

pressing Ctrl+P and Ctrl+N, 58

RESTORE...VALIDATE HEADER command, 517

scrolling with arrow keys, 58

restoring.
See also
OSB

searching in reverse, 59

RESTRICT parameter, 43

RES column, 607

RESUMABLE parameter, 342–343

RESETLOGS clause, 446, 448, 450

RESUMABLE_NAME parameter, 342–343

RESETLOGS_ID column, V$ARCHIVED_LOG

RESUMABLE_TIMEOUT parameter, 342–343

view, 433

RESYNC command, 485

resetting, sequences, 210–212

RETENTION column, DBA/ALL_LOBS view,

back to lower value, 211

262

setting current value of, 210

REUSE clause, 34, 433

resizing redo log groups, 105–106

REUSE STORAGE parameter, 154

resource intensive SQL statements,

REUSE_DATAFILES=y parameter, 343

troubleshooting, 610–615

REUSE_DUMPFILES parameter, 335

displaying, 611–612

REVERSE clause, 181

monitoring real-time statistics, 610–611

reverse-i-search utility, 59

using ADDM, 614–615

Reverse key index type, 173

using ASH, 615

reverse-key indexes, creating, 181

using AWR, 614

reverse, searching in, 59

using Statspack, 615

REVOKE statement, 128–130, 235

resource limits, for users, 126–128

REWRITE_ENABLED column, 380

RESOURCE role, 116, 233

rm command, 47, 106, 599

RESOURCE_LIMIT parameter, 126

rm utility, 428

response files

RMAN backup command, 570

creating databases using, 45–46

RMAN backups, 487–508

installing using, 8–11

adding backup information to repository,

Oracle Database 10g scenario, 8–10

495–496

Oracle Database 11g scenario, 10–11

of archive redo logs, 492–493

restarting databases, 416

checking for corruption in, 499–501

RESTORE command, 458, 511–512, 519, 530,

using BACKUP...VALIDATE, 501

532, 539, 562–563

using RESTORE...VALIDATE, 501

RESTORE CONTROLFILE command, 527

using VALIDATE command, 500

RESTORE CONTROLFILE FROM

of control file, 491–492

AUTOBACKUP command, 528

of datafiles, 491–494

RESTORE DATABASE CHECK READONLY

of entire database, 489–491

command, 520

backup sets vs. image copies, 490–491

RESTORE DATABASE command, 518, 529

full backup vs. incremental level=0, 490

RESTORE DATABASE UNTIL command, 529

excluding tablespaces from, 493–494

RESTORE DATAFILE command, 521

of fast recovery area, 493

668

■ INDEX

incremental backups, 496–499

setting

incrementally updating backups,

CONTROL_FILE_RECORD_KEEP_TIM

498–499

E initialization parameter, 471

overview, 497

setting degree of parallelism, 473–474

using block change tracking, 499

specifying backup users, 465

of large files in parallel, 495

specifying location of autobackup of

logging output from, 501–503

control file, 468

capturing with script command,

using backup sets or image copies,

502–503

474–475

capturing with tee, 502

using block-change tracking, 476

to file, 501–502

using incremental backups, 475

SPOOL LOG command, 503

using incrementally updated backups,

475

viewing most recent RMAN output, 503

using media manager, 470–471

offline or inaccessible files, skipping,

494–495

using online or offline backups, 465

reporting from, 504–508

using recovery catalog, 470

using LIST command, 504

complete recovery, 516–527

using REPORT command, 504–505

performing block level recovery,

523–524

using SQL, 505

restoring archived redo log files, 524–526

setting ECHO, 488–489

restoring datafiles, 521–522

setting NLS_DATE_FORMAT, 488

restoring datafiles to non-default

SHOW ALL command, 489

locations, 522–523

of spfile, 492

restoring entire database, 518–519

of tablespaces, 491–494

restoring read-only tablespaces, 520

verifying integrity of, 592–593

restoring spfile, 526–527

RMAN (Oracle Recovery Manager)

restoring tablespaces, 519–520

architectural decisions, 462–478

restoring temporary tablespaces, 521

backing up archive-redo logs, 469

testing restore and recovery, 516–518

configuring archive-redo logs' deletion

determining media recovery required,

policy, 472–473

510–511

configuring backup location and file

determining what to restore, 511–515

format, 466–467

how process works, 511–512

configuring Backup-Retention policy,

471–472

using Data Recovery Advisor, 512–515

configuring binary compression,

incomplete recovery, 529–534

476–477

determining type of, 531

configuring encryption, 477

performing change/SCN-based

configuring miscellaneous settings,

recovery, 533

477–478

performing log sequenced-based

determining location for snapshot

recovery, 532

control file, 469–470

performing time-based recovery, 532

running client remotely or locally, 464

restoring to restore point, 533–534

setting archive-redo log destination and

recovery catalog, 482–486

file format, 465–466

backing up, 484

setting autobackups of control files, 468

creating, 482–483

dropping, 485–486

669

■ INDEX

registering target database, 484

rmssel command, 556

synchronizing, 485

rmuser command, 554

versions of, 485

ROLE column, 232

restoring and recovering to different server

ROLE_ROLE_PRIVS view, 234

adding tempfile, 542–543

ROLE_SYS_PRIVS view, 233–234

copying RMAN backup to destination

ROLE_TAB_PRIVS view, 234, 236

server, 536

ROLLBACK statement, 153, 617

creating init.ora file for database to be

root account, 5

restored, 536–537

root privileges, 567, 583

creating required directories for

root user, 11, 32, 575, 577, 581

datafiles, control files, and dump/trace

files, 537

root.sh script, 10–11

creating RMAN backup on originating

ROWID clause, 369

database, 535–536

ROW_ID column, 169

ensuring that Oracle is installed, 536

ROWID pseudo-column, 158–159

making control file aware of location of

ROW_MOVEMENT column, USER_TABLES

RMAN backups, 538

view, 290

opening database, 542

ROWNUM pseudo-column, 166, 611–612, 619

recovering database, 540–541

rows

renaming and restoring datafiles to

checking count, 393–394

reflect new directory locations,

removing from partitions, 298–299

539–540

ROWS parameter, 342

renaming database, 543

ROWS=N parameter, 343

restoring control file from RMAN

rsync utility, 13

backup, 538

run{ } block, 524, 526, 532, 539, 556–557

setting new location for online redo logs,

run-parts utility, 576

541–542

runInstaller command, 9

sourcing required OS variables, 536

runInstaller utility, 9, 15–17, 19, 22

starting up database in mount mode,

538

RUN_JOB procedure, 574

starting up database in NOMOUNT

running jobs, 314–315

mode, 537

running manually, Oracle Scheduler jobs,

restoring control file, 527–528

573–574

segueing from decisions to action, 478–482

RUPD$ table, 371

starting, 460–461

RUPD$_ table, 391

stopping and starting Oracle, 515–516

rman utility, 46, 458, 547, 551

■ S

rmanback.bsh script, 502, 570

S column, 607

rmanback.log file, 502

S constraint code, 230

RMAN_BACKUP job, 571–574

-S option, 567

rman_chk.bsh script, 508

\s variable, bash shell, 53

RMAN_NEW_BACK job, 573

SALARY column, EMP table, 633

rmbw command, 560

SALES table, 194, 362, 365, 367

rmds command, 559

SALES_AMT column, 288

rmmf command, 555

SALES_MV table, 367

rmsched command, 561

SALES_ROCKIES view, 194, 198

670

■ INDEX

SAMPLE parameter, 323–325

system privileges, 233–235

sar utility, 603

segment, changing attributes, 322–323

SAs (system administrators), 5, 586

SEGMENT CREATION DEFERRED clause, 366

/sbin/init program, 585

SEGMENT CREATION IMMEDIATE clause, 366

/sbin/init.d/OracleBackup start command, 568

SEGMENT SPACE MANAGEMENT AUTO

/sbin/init.d/OracleBackup stop command, 568

clause, 74, 247

SCHEMA parameter, 151, 209, 324

SEGMENT_CREATED column, DBA/ALL_LOBS

schemas

view, 263

displaying differences in, 238–241

SEGMENT_NAME column, DBA/ALL_LOBS

view, 262

and users, 111

SEGMENT_SPACE_MANAGEMENT column,

SCHEMAS parameter, 342

247

SCN (system change number), 98, 102, 329, 390,

segueing decisions to action, 478–482

439, 453

SELECT clause, 159, 364, 377

scp utility, 13, 19–20

SELECT statement, 35, 138, 144, 174, 185, 199,

SCRIPT option, 150

202, 370, 383, 621

scripts, for common tasks

SELECT_CATALOG_ROLE role, 214, 221, 232

configuring startup file, 69

SEQUENCE BETWEEN clause, 525

conn.bsh script, 64–65

sequences, 204–212

creating directories for, 68–69

autoincrementing columns, 206–207

dba_fcns script, 61–62

creating, 204

dba_setup script, 60–61

dropping, 209

filesp.bsh script, 65–66

metadata for, 208–209

lock.sql script, 67

pseudo-columns for, 205–206

login.sql script, 66

renaming, 209

tbsp_chk.bsh script, 62–64

resetting, 210–212

top.sql script, 66–67

back to lower value, 211