/oracle/app/oracle/product/11.2.0.1 directory,
OPEN RESETLOGS command, 418, 519, 528,
13
542
ORACLE column, 351
OPEN_CURSORS parameter, 618
Oracle Enterprise Manager (OEM), 564
oper group, 5
Oracle Managed File (OMF), 80
operating-system utilities, 340
Oracle Recovery Manager.
See
RMAN
Optimal Flexible Architecture.
See
OFA
Oracle Scheduler jobs, 570–574
OPTIMAL_LOGFILE_SIZE column,
copying, 573
V$INSTANCE_RECOVERY view, 103
creating, 570–571
OPTIMIZER_USE_INVISIBLE_INDEXES
vs. cron, 574–575
parameter, 184
deleting, 574
ORA-00312 error, 418
disabling, 573
ORA-00313 error, 418
enabling, 573
ORA-00376: file can't be read at this time error,
logging history for, 572
78
modifying, 572
ORA-01555 error, 620
running manually, 573–574
ORA-01567 error, 106
stopping, 572–573
662
■ INDEX
viewing details of, 571–572
ORA_HOME variable, 583
Oracle Secure Backup.
See
OSB
orahome.tar file, 13
Oracle Technology Network (OTN), 5, 100
oraInst.loc file, 12, 14
Oracle Universal Installer (OUI), 1
oraInventory/ContentsXML directory, 12, 17
oracle user, 4, 6, 32, 68, 607
oraInventory/ContentsXML/inventory.xml file,
ORACLE_BASE/diag/rdbms/dbname/instname
12, 15, 17
directory, 4
oraInventory directory, 12, 14, 17
ORACLE_BASE directory, 4, 35, 599
oraInventory/logs directory, 11–12
ORACLE_BASE variable, 3, 597–598
ORA_OWNER variable, 583
ORACLE_DATAPUMP driver, 355, 357
orapwd utility, 39, 461
ORACLE_HOME/bin/dbshut script, 583, 585
oraset script, setting environment variables
ORACLE_HOME/bin/dbstart script, 583, 585
with, 27–29
ORACLE_HOME/bin directory, 27, 29, 458, 460
oratab file, 26–28, 583
ORACLE_HOME\database directory, 29–30, 39,
oratab utility, setting environment variables
42
with, 26–27
ORACLE_HOME/dbs/arch directory, 465
ORDER BY clause, 612
ORACLE_HOME/dbs directory, 29–30, 32, 39,
ORDER option, 205
42, 461, 466, 468, 492
ORDER_ID column, 285–286
ORACLE_HOME/dbs/initE64202.ora file, 537
ORDER_ITEMS table, 284
ORACLE_HOME/dbs/[email protected] file, 469
ORDERS table, 284
ORACLE_HOME directory, 4, 17, 583, 585, 597
_O_RELEASE variable, SQL*Plus, 55
ORACLE_HOME/lib directory, 30
ORGANIZATION INDEX clause, 161
ORACLE_HOME/network/admin directory, 4,
OS setting, AUDIT_TRAIL parameter, 627
37, 41
OS utilities, copying datafiles with, 432
ORACLE_HOME/oui/bin directory, 14
OS variables, sourcing, 536
ORACLE_HOME/rdbms/admin directory, 214
OS Watcher utility, 610
ORACLE_HOME/rdbms/admin/spdoc.txt file,
OS_AUTHENT_PREFIX variable, 116
616
osb-10.3.0.3.0_linux32.zip file, 549
ORACLE_HOME variable, 16, 18, 35, 63–64, 460,
OSB-CATALOG-DS file, 562
481, 536, 582, 598
OSB (Oracle Secure Backup), 545–568
ORACLE_HOME_NAME variable, 16
command-line access to, 551–552
ORACLE_LOADER driver, 353
configuring, 552–555
ORACLE_SID variable, 29, 55, 63–64, 460, 481,
536, 543, 582, 597
database backup storage selector, 555
ora_dba group, 41
media families, 554–555
/oradump/cbackup/O11R2 directory, 416–417
users and classes, 552–553
/oradump directory, 309, 311, 355
database backup with, 556–557
/oradump/hbackup/O11R2 directory, 431, 434,
database restore with, 557–558
453
editions of, 545–546
oraenv file, 26–27
file system backup with, 558–561
oraenv utility, setting environment variables
configuring backup schedules and
with, 27
triggers, 560–561
/oraet directory, 347
configuring backup windows, 560
/orahome/oracle/bin directory, 570
creating dataset files, 559
/orahome/oracle/bin/log directory, 570
on-demand backups, 561
/orahome/orainst/10.2.0.4 directory, 15
file system restore with, 562–563
663
■ INDEX
installing, 549–551
PARALLEL parameter, 334
job monitoring, 564–566
parallel tables, creating, 142
listing jobs, 564–565
parallelism
showing job transcripts, 565–566
altering, 389
terminology of, 546–548
overview, 334
administrative domain and servers,
setting degree of, 473–474
546–547
using to reduce elapsed time, 356
daemons, 548
parallelizing index creation, 183
interfaces, 547
PARALLEL_THREADS_PER_CPU parameter,
users and classes, 548
142–143, 183
upgrading, 567–568
parameter file, 316
virtual test devices for, 566–567
PARFILE option, 316
OSB_HOME/etc directory, 548
PARMS clause, 557
OSB_HOME/install directory, 552
PARSING_USER_ID column, V$SQLAREA view,
OSB_HOME variable, 551
612
/osb_vdevices/vdrive1 directory, 567
PARTIES table, 158
/osb_vdevices/vdrive2 directory, 567
PARTITION BY HASH clause, 280
/osb_vdevices/vlib1 directory, 567
PARTITION BY LIST clause, 279
OS_USER parameter, 221
PARTITION BY RANGE clause, 272
OTN (Oracle Technology Network), 5, 100
PARTITION BY REFERENCE clause, for
OUI (Oracle Universal Installer), 1
partitioning tables, 284–286
output
PARTITION BY SYSTEM clause, for partitioning
tables, 286–287
compressing, 336
PARTITION clause, 375
for cron jobs, redirecting, 581
PARTITIONED column, DBA/ALL_LOBS view,
output file names, reusing, 335
263
OVERFLOW clause, 161
partitioned table type, 134
_O_VERSION variable, SQL*Plus, 55
partitioning, 269–306
OWNER column, DBA/ALL_LOBS view, 262
indexes, 300–304
OWNER parameter, 342
differently than tables, 303–304
■
like tables, 300–302
P
for LOBs, 251–252
P column, 382
maintaining partitions, 287–299
P constraint code, 230
adding, 291–293
-p option, 564, 607
dropping, 297–298
p switch, mkdir command, 32
exchanging with existing table, 293–295
P1_TBSP tablespace, 276
manipulating data within, 299
P_2008 partition, 299
merging, 296–297
P_2012 partition, 294, 298
metadata for, 287–288
p6810189_10204_Solaris-64.zip file, 15
moving, 288–289
p7695070_10204_Solaris-64.zip file, 17
moving updated rows automatically,
PARALLEL clause, 142, 183, 356
289–290
PARALLEL command, 313–314
removing rows from, 298–299
PARALLEL feature, 335
renaming, 295
PARALLEL option, 290, 334
splitting, 295–296
664
■ INDEX
statistics for, 298
--pending option, 564
MVs, 375
PERFSTAT user, 615
pruning of, 304
PFILE clause, 30, 42
tables, 271–287
PFILE parameter, 43
composite partitioning, 281–282
physical structure, vs. logical structure of
on demand, 282–284
database, 218–220
existing table, 290–291
PID column, 607
by hash, 280
ping command, 596
by list, 279–280
ping utility, 21
PARTITION BY REFERENCE clause,
PLSQL BLOCK job type, 571
284–286
PLUS ARCHIVELOG clause, 480
PARTITION BY SYSTEM clause, 286–287
PR column, 607
placing partitions into tablespaces,
--preauth option, 553
276–278
preprocessing external tables, 357
by range, 272–278
PREPROCESSOR clause, 358
on virtual column, 286
PREPROCESSOR parameter, 353
when to use, 270–271
PREVIEW clause, 514
PASSWORD command, 118
previewing backups used for recovery, 516–517
password file, 39–40
PRIMARY KEY clause, 369
password-verification function, 119
primary-key constraints, creating, 162–163
PASSWORD_GRACE_TIME setting, 125
PRIVATE_SGA setting, 127
PASSWORD_LIFE_TIME setting, 125
_PRIVILEGE variable, SQL*Plus, 55
PASSWORD_LOCK_TIME setting, 125
privileges, for users, 128–129
PASSWORD_REUSE_MAX setting, 125
grouping of, 130
PASSWORD_REUSE_TIME setting, 125
object, 129
passwords, for users
system, 128–129
changing, 118
proc_count.bsh script, 592
security of, 119–120, 124–126
proc.dmp file, 327
PASSWORD_VERIFY_FUNCTION setting, 125
process status (ps), 340
PATCH_DESC column, 264
processes, checking for too many, 591–592
PATCH_DESC LOB column, 258
PROD_SKU_ID column, 161
patches, applying, 17–18
production accounts, checking for locked,
PATCH_FILE BLOB column, 265
589–590
PATCHMAIN table, 264
products.xml file, 12
PATCHMAIN_NEW table, 260
.profile file, 26, 52
PATCH_SEQ sequence, 264
--progress option, 565
patch.txt file, 264
pruning partitions, 304
PATH directory, 18
ps command, 575
PATH variable, 29, 460, 536
ps (process status), 340
paths, datafile, 322
ps utility, 603, 609
PCTFREE clause, 278
pseudo-columns, for sequences, 205–206
PCTSPACE option, 323
PTIME column, 113
PCTUSED clause, 278
PUBLIC role, 129
PCTVERSION column, DBA/ALL_LOBS view,
public synonyms, 201–202
262
665
■ INDEX
PUBLIC user group, 128–129
rebuilding indexes, 188–189
pupbld.sql script, 37
RECORDLENGTH parameter, 342–343
PURGE clause, 254, 451–452
RECOVER command, 441, 458, 511–512, 519,
PURGE option, 153, 291
525, 532
PURGE RECYCLEBIN statement, 152
RECOVER COPY command, 498
PURGE_LOG procedure, 572
RECOVER DATABASE command, 518, 540
PURGE_MVIEW_FROM_LOG procedure,
RECOVER DATABASE PARALLEL command,
DBMS_MVIEW package, 407
534
pwd command, 59
RECOVER DATABASE statement, 445, 449
pwdds command, 559
RECOVER DATABASE UNTIL command, 530
RECOVER DATABASE USING BACKUP
■ Q
CONTROLFILE clause, 446
RECOVER DATAFILE command, 521
queries, creating tables from, 146
RECOVER DATAFILE statement, 449
QUERY column, DBA/ALL/USER_MVIEWS
view, 383
RECOVER statement, 443
QUERY parameter, 323–324
RECOVER TABLESPACE command, 521
Query, specifying, 324–325
RECOVER TABLESPACE UNTIL command, 530
QUERY_REWRITE_ENABLED parameter, 380
RECOVER...TEST command, 517
QUIET parameter, 43
recovery catalog, 482–486
quit command, 552
backing up, 484
creating, 482–483
■ R
dropping, 485–486
registering target database, 484
r column, 605
restoring control file using, 527–528
R command, 606
synchronizing, 485
R constraint code, 230
versions of, 485
r option, 60
RECOVERY_CATALOG_OWNER role, 483
-R option, 563, 565, 579
RECYCLEBIN feature, 152–153
\r variable, bash shell, 53
RECYCLEBIN parameter, 152
RAC (Real Application Clusters), 45, 545
RECYCLEBIN view, 452
range partition type, 272
redo
range, partitioning tables by, 272–278
avoiding creation of, 144–145
using NUMBER for, 273–275
avoiding generation of for indexes, 183
using TIMESTAMP for, 275–276
redo logging, 98–109
RATE parameter, 478
adding files to group, 106–107
raw restore, file system restore with OSB,
562–563
adding groups, 105
RCAT user, 483
controlling generation of, 76–77
READ ONLY clause, 196
determining optimal number of groups,
103–105
read-only tables, creating, 140–141
determining optimal size of groups, 102–103
read-only tablespaces, restoring, 520
displaying information for, 100–102
README.txt file, 17–18
moving or renaming files, 107
Real Application Clusters (RAC), 45, 545
online, setting new location for, 541–542
real-time refresh, 401–402
removing files from group, 107
REBUILD clause, 189
resizing groups, 105–106
666
■ INDEX
redoNA.rdo file, 35
REMAP_SCHEMA parameter, 333, 343–344
reference partition type, 272
REMAP_TABLE parameter, 331, 336
REFRESH function, DBMS_REFRESH package,
REMAP_TABLESPACE feature, 323
409
REMAP_TABLESPACE parameter, 333
refresh group
REMOTE_LOGIN_PASSWORDFILE parameter,
adding to, 410