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 command,

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