Pro Oracle Database 11g Administration (106 page)
AUDIT_SYS_OPERATIONS parameter, 627
disabling, 427
AUDIT_TRAIL parameter, 626–627, 630–631
enabling, 426
639
■ INDEX
AUDIT_TRAIL_TYPE parameter, 632
starting and stopping database and
AUD_TBSP tablespace, 632
listener, 583–586
AUTHENTICATED_IDENTITY parameter, 221
truncating large log files, 588–589
authentication
verifying integrity of RMAN backups,
and connecting to databases, 41
592–593
for users, 115–116
Oracle Scheduler jobs, 570–574
AUTHENTICATION_METHOD parameter, 221
copying, 573
AUTOALLOCATE clause, 74
creating, 570–571
AUTOALLOCATE feature, 75
vs. cron, 574–575
autobackup directory, 527
deleting, 574
autobackups
disabling, 573
of control files, 468
enabling, 573
restoring control file using, 528
logging history for, 572
AUTO_DROP parameter, 571
modifying, 572
AUTOEXTEND feature, 74
running manually, 573–574
autoincrementing, columns, 206–207
stopping, 572–573
automated cartridge system library software
viewing details of, 571–572
(ACSLS), 546
autotrace tool, 155
automated segment space management
availability, of database, 596–597
(ASSM), 247
AWR (Automatic Workload Repository), 612,
Automatic Database Diagnostic Monitor
614
(ADDM), 614–615
awrsqrpt.sql file, 614
Automatic Storage Management (ASM), 46
Automatic Workload Repository (AWR), 612,
■ B
614
b column, vmstat utility, 604–605
automating jobs, 569–593
-B option, 567
cron jobs, 575–581
-b option, top command, 607
adding by editing cron table directly, 579
B-tree cluster index type, 173
adding by loading cron table from file,
B-tree index type, 173
580–581
B-tree indexes, creating, 175–176
enabling access to, 577
B&R (backup and recovery), 413–456
vs. Oracle Scheduler, 574–575
archivelog mode, 420–430
overview of cron, 575–576
backing up archive-redo log files, 428
redirecting output for, 581
disabling, 427
table entries for, 577–578
enabling, 426
troubleshooting, 581
making architectural decisions, 421
examples of, 582–593
making cold backups of, 428–430
checking for archive redo destination
fullness, 586–588
setting archive-redo file location,
421–426
checking for files over certain age,
590–591
archivelog-mode databases, 441–448
checking for locked production
incomplete recovery of, 449–450
accounts, 589–590
offline, 441–444
checking for too many processes,
online, 444–445
591–592
restoring control files, 445–448
flashing back databases, 454
640
■ INDEX
flashing back tables, 451–454
BACKUP INCREMENTAL LEVEL=0 DATABASE
FLASHBACK TABLE TO BEFORE DROP,
PLUS ARCHIVELOG command, 490
452
Backup-Retention policy, 471–472
to restore points, 453–454
backup sets, vs. image copies, 490–491
to SCN, 453
backup users, 465
to timestamps, 453
BACKUP VALIDATE command, 523
hot backups, scripting, 434–436
backup.bsh script, 579–581
making hot backups, 430–433
backups
altering databaseinto backup mode, 432
copying to destination server, 536
altering databaseout of backup mode,
creating on originating database, 535–536
432
making control file aware of location of, 538
backing up archive-redo logs generated
online or offline, 465
during backup, 433
restoring control file from, 538
backing up control files, 433
restoring entire database using backup
copying datafiles with OS utilities, 432
control file, 519
determining where to copy backup files,
used for recovery, previewing, 516–517
431
validating files before restoring, 517
determining which files need to be
BACKUP...VALIDATE command, 500–501
backed up, 431
BADFILE parameter, 353
ensuring that database is in archivelog
mode, 431
base directory, for OFA, 3
maximum sequence number of
base-table DDL, 385–388
online-redo logs, 431–433
.bash_profile file, 26
noarchivelog-mode databases, 414–420
.bashrc file, 26, 29, 52, 54, 56, 69
copies of files, 416
BASIC compression algorithm, 474, 477
determine locations and names of files,
BasicFile LOBs (large objects)
415
creating columns of, 248–249
with online-redo logs, 416–417
migrating to SecureFile LOB, 260–262
restarting databases, 416
overview, 246
scripting, 418–420
space consumed by, 266–267
shutting down instances, 416
batch mode, top utility, 607
space required, 415
bck.log file, 581
without online-redo logs, 417–418
bdump function, 61
redo generated during backups, 439–440
BFILE (binary file), 243–244
split-block issue, 436–439
bi column, 605
updated datafiles, 440
BIGFILE clause, 81
BACKGROUND_DUMP_DEST parameter, 537,
bigfile feature, for tablespaces, 81
598
bigfile tablespace, 81
BACKGROUND_DUMP_DEST varaible, 598
bin directory, 56, 358
backing up.
See also
OSB
binary compression, 476–477
backup and recovery.
See
B&R
binary file (BFILE), 243–244
BACKUP AS COPY command, 511, 524, 530
binary large object (BLOB), 243–244, 265
BACKUP command, 458–459, 466, 468, 476,
Bitmap index type, 173
487, 489, 491–492, 523
bitmap indexes, creating, 179–180
BACKUP INCREMENTAL command, 498
Bitmap join index type, 173, 180–181
641
■ INDEX
BITMAP keyword, 179
catalog-based restore, file system restore with
BLKG_OS_PID column, 618
OSB, 562
bllnx1_home-oracle.ds file, 559–561
CATALOG command, 471, 496–497, 538, 558
BLOB (binary large object), 243–244, 265
CATALOG DEVICE TYPE SBT_TAPE
BLOB_DATA tablespace, 249
BACKUPPIECE command, 558
blob.sql file, 265
CATALOG START WITH
558
block-change tracking, 476
catalog.sql script, 214–215
block level recovery, 523–524
catds command, 559
BLOCKRECOVER command, 524
catproc.sql script, 215
bo column, 605
catxcr command, 564, 568
BOOKS table, 201
cbdir variable, 419
bottlenecks, troubleshooting, 602–609
CBO (cost-based optimizer), 138
mapping operating system process to SQL
statement, 608–609
CB_RAD_COUNTS view, 237
using top, 606–607
cd command, 562
using vmstat, 605
cdds command, 561
buff column, 605
CHANGE function, DBMS_REFRESH package,
409
BUFFER parameter, 342–343
change/SCN-based recovery, 533
BUFFER_GETS column, 612
character large object (CLOB), 243–244,
BUILD DEFERRED clause, 378
263–264
BY ACCESS clause, AUDIT statement, 628
CHARSET parameter, 343
BYHOUR option, 572
CHAYA user, 323
BYMINUTE option, 572
CHECK LOGICAL clause, 500, 593
BYTES column, DBA/ALL/USER_SEGMENTS
checking for constraints, 165–166
view, 265
Checkpoint not complete issue, 105
■
Checkpoint not complete message, 104
C
chkbw command, 562
C constraint code, 230
chkconfig command, 584, 586
-c option, 564–565
chkds command, 559
C:\Program Files\Oracle\Backup directory, 549
chmf command, 555
cache column, 605
chmod command, 60
CACHE column, DBA/ALL_LOBS view, 262
CHSCHED command, 561
CACHE option, 205
chssel command, 556
CACHE READS setting, 254
CHUNK column, DBA/ALL_LOBS view, 262
CACHE setting, 254
chunks, for LOBs, 244–246
caching for LOBs, 254
chuser command, 554
CANCEL clause, RECOVER DATABASE
CIA_SEL user, 617
statement, 449
classes, terminology of OSB, 548
CASCADE clause, 123, 157
CLEAR command, 474, 477
CASCADE CONSTRAINTS clause, DROP
TABLESPACE statement, 79
CLOB (character large object), 243–244,
263–264
CASCADE CONSTRAINTS option, 151
CLOB_DATA tablespace, 249
CASCADE option, 168
clob.sql file, 264
CASCADE parameter, 226
cloning users, 333
cat command, 600
642
■ INDEX
CLUSTER_BUCKETS table, 231
dump files, 356
clustered table type, 134
MVs, 376
coldback.sql script, 419–420
output, 336
coldrest.sql script, 419–420
SecureFile LOBs, 256–257
COLUMN_EXPRESSION column, 178, 227
table data, 143–144
COLUMN_NAME column, DBA/ALL_LOBS
COMPRESSION column, DBA/ALL_LOBS view,
view, 262
263
COLUMN_POSITION column, 227
COMPRESSION parameter, 336, 357
columns
Computer Name tab, System window, 21
adding, 147
COMPUTER_SYSTEMS table, 154
altering, 148–149
concatenated indexes, creating, 176–177
dropping, 149–150
CONFIGURE ARCHIVELOG DELETION
encrypting, 376
command, 473
renaming, 149
CONFIGURE CHANNEL command, 467, 478
COMMAND column, 607
CONFIGURE CHANNEL...FORMAT command,
command editor, setting, 59–60
467
command history, listing, 58–59
CONFIGURE command, 463, 466, 476–477,
480–482, 489, 556–557
command prompt, customizing, 52–53
conn.bsh script, 64–65
COMMISSION column, 286
CONNECT option, AUDIT statement, 629
COMMIT parameter, 343
CONNECT role, 116, 233
COMMIT statement, 153, 617, 620
_CONNECT_IDENTIFIER variable, 55
COMPACT clause, 157
connecting to databases, and authentication,
COMPATIBLE parameter, 141
41
COMPILE parameter, 343
CONNECT_TIME setting, 127
--complete option, 564
CONSISTENT parameter, 342
complete recovery, RMAN, 516–527
consistent=y parameter, 341
performing block level recovery, 523–524
constraints, 229–231
restoring archive redo log files, 524–526
checking for, 165–166
restoring datafiles, 521–522
disabling, 167–168
restoring entire database, 518–519
displaying, 229–230
restoring spfile, 526–527
enabling, 168
restoring tablespaces, 519–520
foreign-key, 164–165
testing restore and recovery, 516–518
not null, 166–167
complete-refreshable MV, 365–369
primary-key, 162–163
composite partition type, 272
showing primary-key and foreign-key
composite partitioning, of tables, 281–282
relationships, 230–231
COMPOSITE_LIMIT setting, 127
unique, 163–164
COMPRESS clause, 256
CONSTRAINTS parameter, 342–343
COMPRESS FOR OLTP clause, 143
CONSTRAINT_TYPE column, 229, 231
COMPRESS N clause, 182
CONTENT parameter, 324, 330–331, 333, 343
COMPRESS option, ACCESS PARAMETERS
CONTENT=ALL parameter, 342
clause, 356
CONTENT=DATA_ONLY option, 330
COMPRESS parameter, 337, 342
--contentmanaged option, 554
compressing
CONTENT=METADATA_ONLY option, 336
643
■ INDEX
--contents option, 563
CREATE ANY VIEW privilege, 194
contents.sql file, 318
CREATE CONTROLFILE statement, 87–89, 482,
CONTINUE_CLIENT command, 313–315
543
control files, 91–98
CREATE DATABASE command, 214
adding, 94–96
CREATE DATABASE LINK script, 319
when using init.ora, 95–96
CREATE DATABASE LINK statement, 239, 322,
when using spfile, 94–95
404
autobackups of, 468
CREATE DATABASE statement, 25, 29, 32–36
creating required directories for, 537
CREATE DIRECTORY command, 310
file names and locations of, 93–94
CREATE EXTERNALLY statement, 116
moving, 96–97
CREATE GLOBAL TEMPORARY TABLE
statement, 159
removing, 97–98
CREATE INDEX statement, 171, 175, 300
restoring, 445–448, 527–528
CREATE MATERIALIZED VIEW LOG command,
restoring from backups, 538
391
RMAN backups of, 491–492
CREATE MATERIALIZED VIEW privilege, 365
control02.ctl file, 95, 97
CREATE MATERIALIZED VIEW statement, 379
CONTROL_FILE_RECORD_KEEP_TIME
CREATE MATERIALIZED VIEW...AS SELECT
initialization parameter, 471
statement, 366
CONTROL_FILE_RECORD_KEEP_TIME
CREATE MATERIALIZED VIEW...ON PREBUILT
parameter, 463, 465, 471, 474