Pro Oracle Database 11g Administration (111 page)

Read Pro Oracle Database 11g Administration Online

Authors: Darl Kuhn

Tags: #Oracle DBA

BOOK: Pro Oracle Database 11g Administration
7.03Mb size Format: txt, pdf, ePub

/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

Other books

Weep No More My Lady by Mary Higgins Clark
The Mammoth Book of Regency Romance by Candice Hern, Anna Campbell, Amanda Grange, Elizabeth Boyle, Vanessa Kelly, Patricia Rice, Anthea Lawson, Emma Wildes, Robyn DeHart, Christie Kelley, Leah Ball, Margo Maguire, Caroline Linden, Shirley Kennedy, Delilah Marvelle, Sara Bennett, Sharon Page, Julia Templeton, Deborah Raleigh, Barbara Metzger, Michele Ann Young, Carolyn Jewel, Lorraine Heath, Trisha Telep
Baby On The Way by Sandra Paul
North Star by Karly Lane
City of Screams by James Rollins
Upside Down by John Ramsey Miller
A Home by the Sea by Christina Skye