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$_
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