S

Page 238

and Oracle Enterprise Manager, 212

Portable Clusterware, 14

rolling upgrades, 14–15

recovery

alter database archivelog command, 76

database backup commands, 76–77

dynamic views, 75

log_archive_format parameter, 75

monitoring transaction recovery, 102–103

recovering datafiles not backed up, 89

resetlogs command, 74–76

standby databases, 75–76

tablespace point-in-time recovery, 91

using RMAN copies, 84–85

recycle bin, 97–98

redefinition features, 38

regular expressions

common metasymbols, 165

defined, 164

regexp_instr function, 168–169

regexp_like function, 166–168

regexp_replace function, 169–171

regexp_substr function, 171–172

using in Oracle Database 10g, 164–172

remote stored procedures, calling, 190

resetlogs command, 74–76

returning clause, 206

using aggregates in, 207–208

RMAN

automatic channel failover, 89–90

backup as copy command, 83–84

backup current controlfile, 85

backup file image copies, 84

catalog and uncatalog commands, 85–86

compressing backups, 90

configuring the default device type to copy, 84

controlling backup rates and duration, 91–92

converting tablespace endian format with, 140–141

datafile image copies, 89

dropping a database in, 86

enhanced scripts, 91–92

fast recovery using RMAN copies, 84–85

flash recovery area, 78–83

incremental backups, 87–89

recovering datafiles not backed up, 89

TSPITR changes, 91

unregistering a database in, 86–87

using Flashback Database from, 95

RVWR, 232

S

save exceptions clause, 162–163

Scheduler

arguments, 30

automated administrative tasks, 44

Calendar Expressions, 32

creating a job in, 31–32

creating a program in, 28–30

overview, 27

parameters for create_program procedure, 28–29

practical use of, 27–33

variables, 30

See also Job Scheduler

searching, case-and accent-insensitive, 172–173

self-tuning checkpointing, 62

server-based advisors, 44, 50–51

Automatic Database Diagnostic Monitor, 53–55

data dictionary views, 51–53

dbms_advisor package, 51, 52

MTTR Advisor, 59

Shared Pool Advisor, 58–59

SQL Access Advisor, 58

SQL Tuning Advisor, 55–58

server-generated alerts, 44, 59

kinds of, 59–60

nonthreshold alerts, 60

threshold alerts, 60

views, 60–61

sga_target parameter, 61

Shared Pool Advisor, 58–59

shared server architecture

changes to configuration, 65

MTS parameters, 66

tracing shared server sessions, 66

V$DISPATCHER_CONFIG view, 66

shared_context_sensitive policy, 69

shared_static policy, 69

shrinking segments, 37–38