Skip Headers
Oracle® Database High Availability Overview
11g Release 2 (11.2)

E17157-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  R  S  T  U  V  W 

Numerics

24x365, 1.1
64-bit systems
migration from 32-bit, 4.1.2.1

A

access control
security, 3.14
Active Data Guard
See Oracle Active Data Guard option
Active Session History (ASH)
reporting on transient performance problems, 6.1
ADD COLUMN
default values for columns, 4.5.5
advisor framework, 6.1
ALTER DATABASE RECOVER MANAGED STANDBY statement
enabling real-time query, 5.4.1
analysis
determining high availability requirements, 2
applications
defining a virtual IP address, 7.1.2
online maintenance and upgrades, 4.5
applying interim database patches, 4.1.3
architectures
choosing, 7.2, 7.2
CPU, 3.6
failures in, 1.1
grid computing, 5.1
MAA, 7
manageability, 2.2.5
multiple standby database, 7.1.5.2
Oracle Application Server, 7.2, 7.3, 7.3.1
Oracle Clusterware, 7.1.2
Oracle Clusterware and Oracle Data Guard, 7.1.5.3, 7.1.6
Oracle Data Guard, 7.1.5
Oracle Data Guard standby hub, 7.1.5.2, 7.1.5.3
Oracle Database, 7.1.1
Oracle RAC, 7.1.4
Oracle RAC and Oracle Data Guard, 7.1.8
Oracle RAC on extended clusters, 7.1.4.1
Oracle RAC One Node, 7.1.3
Oracle RAC One Node and Oracle Data Guard, 7.1.7
recommendations, 7.2
requirements, 1.1, 2.1, 2.3
roadmap, 1.5
same processor platforms, 4.1.2
single standby database, 7.1.5, 7.1.5.1
ASM
See Oracle Automatic Storage Management (Oracle ASM)
auditing
security control, 3.14
authentication
security controls, 3.14
automatic block repair, 3.8.9, 3.20
automatic failover
Oracle Data Guard, 7.1.5.1
automatic maintenance tasks, 6.1
automatic shared memory management
dynamic memory allocation, 4.2.1
Automatic Workload Repository (AWR), 6.1
availability
about, 1.1
disruptions, 1.3
roadmap, 1.5
See also high availability

B

backing out a transaction, 3.8.3
backups
fast recovery area, 3.10
offload from the primary database, 3.6.1
Oracle Secure Backup, 3.13
between objects, 4.5.6
block corruption
repairing, 3.20
block recovery
reducing time, 3.20
using Flashback logs, 3.8.9
block recovery using flashback logs, 3.8.9
bounded recovery, 3.2
Bourne shell script
physru, 3.6.3
budget planning, 2.3.1
business impact analysis
internal knowledge management system example, 2.2.1
semiconductor manufacturer example, 2.2.1
business performance planning, 2.3.1

C

change assurance, 6
checkpointing
fast-start fault recovery, 3.2
choosing the correct high availability architecture, 7.2
client failover, 3.19
Cluster Ready Services (CRS)
avoiding downtime during upgrades, 4.1.4
clusters
extended, 7.1.4.1
Oracle Clusterware, 7.1.2
cold cluster failover, 7.1.2, 7.1.6
with Oracle Clusterware, 7.1.2
with Oracle Clusterware and Data Guard, 7.1.6
components
integrated with Oracle Restart, 3.3
compressed redo data
Oracle Data Guard, 7.1.5
computer failure, 1.4
corruptions
prevention and detection, 3.21
repairing, 3.20
costs
quantifying, 2.2.2
CPU architectures, 3.6
CREATE TRIGGER statement
clauses for, 4.5.4
crossedition triggers, 4.5.1.3

D

data corruptions, 1.4
automatic detection and repair, 3.20
detecting, 3.21
prevention and detection parameters, 3.21
data distribution
Oracle GoldenGate, 3.7
data encryption, 3.14
Data Guard
See Oracle Data Guard
data integration
Oracle GoldenGate, 3.7
data protection
maximizing, 1.2
Data Recovery Advisor, 3.12
data transformation, 3.7.1
data type restrictions
resolving with Extended Datatype Support (EDS), 4.1.9.1, 4.1.9.4
data types
supporting advanced with EDS, 3.6.3
Database Replay, 6.2
Database Server Grid, 5.1
about, 5.2
Database Storage Grid, 5.1
about, 5.3
database upgrades
using transportable tablespace, 4.1.9.2
databases
applying Oracle interim patches, 4.1.3
checkpointing, 3.2
dynamic reconfiguration, 4.2.1
security, 3.14
server grid, 5.1
data-loss tolerance, 2.2.4
DBA_FLASHBACK_TRANSACTION_STATE view, 3.8.3
DBFS Content Store, 3.18
DBMS_FLASHBACK.TRANSACTION_BACKOUT() procedure, 3.8.3
DDL with the WAIT option, 4.5.3
dependencies, 4.5.6
DISABLE clause
FOLLOWS clause
CREATE TRIGGER statement, 4.5.4
disaster recovery solutions
Oracle Application Server, 7.3.1
disk group
administering with Oracle ASM, 3.9
downtime
causes, 1.4
cost, 1.3, 2.2.2
minimizing with Oracle GoldenGate and Oracle Data Guard, 4.1.9.3
mitigating, 1.3
solutions summary
planned, 4.1
unplanned, 3.1
See also unplanned downtime
dynamic reconfiguration, 4.2.1

E

edition-based redefinition, 4.5.1
crossedition triggers, 4.5.1.3
editioning view, 4.5.1.2
editions, 4.5.1.1
ENABLE clause
CREATE TRIGGER statement, 4.5.4
encryption
of data, 3.14
endian format platforms
avoiding downtime during migration of different, 4.1.11
avoiding downtime during migration of same, 4.1.10
Exadata Cell, 3.16
See also Oracle Exadata Storage Server Software
EXCLUDE STANDBY option
of the RMAN RECOVER BLOCK command, 3.20
extended clusters
architecture, 7.1.4.1
Extended Data Type Support (EDS)
rolling upgrades, 3.6.3
Extended Datatype Support (EDS)
patch set and database upgrades, 4.1.9

F

failovers
fast, 7.1.5.1
multiple standby databases
architecture, 7.1.5.2
single standby database architecture, 7.1.5.1
failure group
administering with Oracle ASM, 3.9
Oracle ASM, 3.9
failures
computer, 1.4
probability, 7.2
site, 1.4
storage, 1.4
fast application notification (FAN)
for hardware upgrades, 4.1.1
for operating system upgrades, 4.1.1
Fast Connection Failover
for nonpooled connections, 3.4.2
Fast Mirror Resync
Oracle ASM, 3.9
fast recovery area
about, 3.10
benefits, 3.10
in a Data Guard configuration, 7.1.5
fast-start failover
single standby database failover, 7.1.5.1
Fast-Start Fault Recovery
benefits of using, 3.2
fault diagnosability infrastructure, 6.1
flashback logs
block recovery using, 3.8.9
used by Flashback features, 3.8
Flashback technology
block recovery using Flashback logs, 3.8.9
See also Oracle Flashback technology
forward crossedition triggers, 4.5.1.3
frequency of outages, 7.2, 7.2
FUSE (Filesystem in Userspace) API
with Client for Database Filesystem (CDF), 3.18

G

grid computing, 5.1
Database Server Grid, 5.1
Database Storage Grid, 5.1
grids
server and storage, 5.1
growth planning, 2.3.1

H

hangs or slow down, 1.4
hardware upgrades
avoiding downtime during, 4.1.1
using FAN during, 4.1.1
high availability
24x365, 1.1
about, 1.1, 1.1
analysis framework, 2.1
applications, 7.3.1
architectures, 1.1, 2.2.5, 7, 7.2
business impact analysis, 2.2.1
determining requirements, 2
importance, 1.2
maximizing, 1.2
Oracle Application Server, 7.3
Oracle Database, 7.1
planned downtime, 4.1
planning, 2.3.1
setting manageability goals, 2.2.5
single-instance databases, 3.3
solutions, 1.1
unplanned downtime, 3
See also availability
high availability features
Oracle Database, 7.1.1
hub-and-spoke deployment, 3.7.1
human errors, 1.4

I

indexes
invisible, 4.5.7
intelligent infrastructure, 6, 6.1
interblock corruption, 1.4
interconnects
Oracle RAC, 7.1.4
intrablock corruption, 1.4
invisible indexes, 4.5.7
I/O Resource Management
Oracle Storage Grid, 5.3

L

load balancing advisory, 3.4.2
logical corruption, 1.4
logical standby databases
about, 3.6.5
benefits of, 3.6.5
transient, 3.6.3, 3.6.3
LogMiner utility
about, 3.15
lost writes, 1.4

M

making data changes, 4.5.1.1
manageability
goals, 2.2.5
optimizing, 6
overhead (MO), 2.2.5, 7.2
manual block repair, 3.20
Maximum Availability Architecture
See Oracle Maximum Availability Architecture (MAA)
media corruption
physical corruption, 1.4
memory
automatic management of, 4.2.2
memory advisors, 6.1
MEMORY_MAX_TARGET initialization parameter, 4.2.2
MEMORY_TARGET initialization parameter, 4.2.2
metadata
dependencies, 4.5.6
migrating storage
avoiding downtime, 4.1.6
migrations
32-bit to 64-bit systems, 4.1.2.1
Oracle Exadata Storage Server Software, 4.1.7
storage, 4.1.6
mirroring
Oracle ASM native, 3.9
multimaster replication, 3.7.1
multiple standby databases
Data Guard hub, 7.1.5.3
failovers, 7.1.5.2
using transient logical standby, 3.6.3, 3.6.3

N

nodes
virtual IP addresses, 7.1.2

O

observer
fast-start failover, 7.1.5.1
one-off patches, 4.1.3
online database relocation utility, 7.1.3
online maintenance
application, 4.5
online redefnition of tables, 4.3
online reorganization
about, 4.3
online table redefinition, 4.5.8
OPatch utility
patch upgrades for Oracle RAC, 4.1.3
operating systems
requirements for Oracle Clusterware, 7.1.2
upgrades, 4.1.1
using FAN during upgrades, 4.1.1
Oracle Active Data Guard
standby databases
benefits of, 3.6.2
Oracle Active Data Guard option, 5.4.1
collecting ASH samples on, 6.1
Oracle Application Server
high availability architectures, 7.3.1
security, 7.3.1
Oracle Automatic Storage Management (Oracle ASM)
about, 3.9
benefits, 3.9
distribution of files, 4.2.3
failure group, 3.9
Fast Mirror Resync, 3.9
native mirroring, 3.9
storage migration, 4.1.5
upgrading, 4.1.5
with Database Storage Grid, 5.3
Oracle Automatic Storage Management Cluster File System (Oracle ACFS), 3.9, 7.1.1
Oracle Call Interface (OCI), 3.4.2
Oracle Clusterware
about, 7.1.2
advantages over third-party clusterware, 7.1.2
avoiding downtime when upgrading, 4.1.4
benefits, 7.1.2
cold cluster failover, 7.1.2
configured with Data Guard, 7.1.6
Oracle Data Guard
about, 3.6
benefits, 3.6, 7.1.5
benefits of, 3.6
configured with Oracle Clusterware, 7.1.6
configuring with Oracle GoldenGate, 3.7.2, 4.1.9.3
hub architecture, 7.1.5.3
multiple standby database architecture, 7.1.5.2
single standby database architecture, 7.1.5.1
system and cluster upgrades, 4.1.2
Oracle Data Provider for .NET (ODP.NET), 3.4.2
Oracle Database
basic architecture, 7.1.1
with Data Guard, 7.1.5
with Oracle Clusterware (cold cluster failover), 7.1.2
with Oracle Clusterware and Oracle Data Guard, 7.1.6
with Oracle RAC, 7.1.4
with Oracle RAC and Oracle Data Guard - MAA, 7.1.8
with Oracle RAC on an extended cluster, 7.1.4.1
Oracle Database File System (DBFS), 3.18, 7.1.5
Oracle Database Resource Manager Instance Caging, 7.1.3
Oracle Enterprise Manager Grid Control, 6, 6.3
Oracle Exadata Database Machine, 3.17
Oracle Exadata Storage Server Software, 3.16
combined with Sun Oracle Database Machine, 3.17
migrating, 4.1.7
upgrading, 4.1.8
Oracle Flashback Data Archive, 3.8.10
Oracle Flashback Database, 3.8.8
Oracle Flashback Drop, 3.8.6
Oracle Flashback Query, 3.8.1
Oracle Flashback Table, 3.8.5
Oracle Flashback technology, 3.8
Oracle Flashback Transaction, 3.8.3
Oracle Flashback Transaction Query, 3.8.4
Oracle Flashback Version Query, 3.8.2
Oracle GoldenGate, 3.7
about, 3.7
comparing to Oracle Streams, 3.7
configure to minimize downtime, 4.1.9.3
configuring with Oracle Data Guard, 3.7.2
rolling upgrades, 4.5.2
Oracle interim (one-off) patches, 4.1.3
applying, 4.1.3
avoiding downtime during, 4.1.3
Oracle Management Agents
Oracle Enterprise Management Grid Control, 6.3
Oracle Management Repository
Oracle Enterprise Manager Grid Control, 6.3
Oracle Management Service (OMS)
Oracle Enterprise Manager Grid Control, 6.3
Oracle Maximum Availability Architecture (MAA)
about, 1.5
architectures, 7
benefits, 7.1.8
roadmap, 1.5
Oracle Real Application Clusters One Node, 7.1.3
online database relocation utility, 7.1.3
See Oracle RAC One Node
Oracle Real Application Clusters (Oracle RAC)
about, 7.1.4
applying Oracle interim database patches, 4.1.3
automatic redundant interconnects, 7.1.4
benefits, 3.4.2
extended clusters, 7.1.4.1
operating system and hardware upgrades, 4.1.1
Storage Area Network (SAN), 7.1.4.1
Oracle Restart, 3.3
Oracle Secure Backup
about, 3.13
benefits, 3.13
Oracle Streams, 3.7
comparing to Oracle GoldenGate, 3.7
Oracle UCP run-time connection load balancing, 3.4.2
Oracle VM
Domain Live Migration, 5.5
with Oracle RAC One Node, 7.1.3
outages
frequency, 7.2, 7.2
types of, 1.4

P

performance
ASH sampling to address transient problems, 6.1
physical corruption, 1.4
physical standby databases
benefits of, 3.6.1
collecting ASH samples, 6.1
real-time query, 5.4.1
snapshot standby, 3.6.4
transient logical standby database, 3.6.3
physru shell script, 3.6.3
planned activities
probability of failure during, 7.2
planned downtime
online patching, 4.1.3.1
recovery times, 7.2
planned outages
minimizing with Oracle GoldenGate and Oracle Data Guard, 4.1.9.3
platform migrations
using transportable database, 4.1.10.1
policy management
security, 3.14
prioritizing
high availability investment, 2.2.2
probability
of different failures during unplanned and planned activities, 7.2
Program Global Area (PGA)
automatic management, 4.2.2

R

real-time query, 5.4.1
collecting ASH samples on, 6.1
reconfiguring
databases dynamically, 4.2.1
Recovery Manager (RMAN)
about, 3.11
benefits, 3.11
recovery point objective (RPO)
about, 2.2.4, 7.2
recovery time objective (RTO)
about, 2.2.3, 7.2
recovery times
planned downtime, 7.2
reducing downtime from data block corruption, 3.20
unplanned downtime, 7.2
redundant interconnect, 7.1.4
relocation
online database, 7.1.3
replication
Oracle GoldenGate, 3.7
Oracle Streams, 3.7
restore points
Oracle Flashback, 3.8.7
return on investment (ROI), 2.2.6, 7.2
optimizing, 5
reverse crossedition triggers, 4.5.1.3
RMAN RECOVER BLOCK command
repairing data block corruption, 3.20
roadmap to Maximum Availability Architecture (MAA), 1.5
rollback
transactions, 3.8.3
rolling upgrades
Oracle GoldenGate, 4.5.2
supporting data types with Extended Data Type Support (EDS), 3.6.3
using the physru shell script, 3.6.3
using transient logical standby, 3.6.3, 3.6.3
row level security
virtual private database, 3.14
run-time connection load balancing, 3.4.2

S

secure communications
between tiers in grid control environments, 6.3
Secure Sockets Layer (SSL)
enabling for secure communications, 6.3
use with grid control, 6.3
SecureFile LOBs, 3.18
security
about, 3.14
benefits, 3.14
between tiers in firewall-protected environments, 6.3
data encryption, 3.14
Oracle Application Server, 7.3.1
Oracle ASM, 3.9
RMAN, 3.11
Segment Advisor, 6.1
server grid, 5.1
server-generated alerts, 6.1
servers
Oracle Clusterware requirements, 7.1.2
service-level agreements (SLAs), 2.1
single standby database architecture
failovers, 7.1.5.1
single-instance databases
Oracle Restart, 3.3
site failure, 1.4
SLAs, 2.1
snapshot standby database
about, 3.6.4
snapshot standby databases
benefits of, 3.6.4
SQL Access Advisor, 6.1
SQL Apply
upgrades, 4.1.9, 4.1.9.1
with Extended Datatype Support (EDS), 4.1.9.1
with logical standby databases, 3.6.5
SQL Performance Analyzer, 6.2
SQL Tuning Advisor, 6.1
SSL
See Secure Sockets Layer (SSL)
standby databases
active, 5.4
Active Data Guard option, 5.4.1
benefits of, 3.6
example hub configurations, 7.1.5.3
logical standby, 3.6.3, 3.6.3
multiple-standby architecture, 7.1.5.2
single-standby architecture, 7.1.5.1
snapshot standby database, 3.6.1
transient logical standby database, 3.6.1
standby reader farms, 5.4.2
storage
failures, 1.4, 3.9
grid, 5.1
migration, 4.1.6
Oracle ASM protection, 3.9
Storage Area Network (SAN)
extended clusters, 7.1.4.1
System Global Area (SGA)
automatic management, 4.2.2
system upgrades
avoiding downtime during, 4.1.1

T

tables
editionable, 4.5.1.2
tape backups
with Oracle Secure Backup, 3.13
thin client watchdog
observer for fast-start failover, 7.1.5.1
total cost of ownership (TCO), 2.2.6, 7.2
transactions
backing out with Flashback Transaction, 3.8.3
transient logical standby databases
about, 3.6.3
benefits of, 3.6.3
physru shell script, 3.6.3
transportable database
for platform migration, 4.1.10.1
for unplanned downtime, 4.4
transportable tablespace
for unplanned downtime, 4.4
upgrading the database, 4.1.9.2

U

Undo Advisor, 6.1
undo data
used by flashback features, 3.8
unplanned activities
probability of failure during, 7.2
unplanned downtime
causes, 1.4
recovery times, 7.2
solutions summary, 3.1
transportable technologies, 4.4
updatable standby databases, 3.6.4
upgrades
application, 4.5
cluster, 4.1.2
database, 4.1.9
hardware, 4.1.1
operating system, 4.1.1, 4.1.2
Oracle ASM, 4.1.5
Oracle Clusterware, 4.1.4
Oracle Exadata Storage Server Software, 4.1.8
Oracle Real Application Clusters (Oracle RAC), 4.1.1
patches, 4.1.3
rolling with Oracle GoldenGate, 4.5.2
using crossedition triggers, 4.5.1.3
using transportable tablespace, 4.1.9.2
with logical standby databases (SQL Apply), 3.6.3, 3.6.3

V

V$DATABASE_BLOCK_CORRUPTION view, 3.21
virtual IP (VIP) address
defining for applications, 7.1.2
managed by Oracle Clusterware, 3.4.1
virtual private database
security, 3.14
virtualization
with Oracle VM Domain Live Migration, 5.5

W

WAIT option
specifying DDL with, 4.5.3
Web scalability
using standby reader farms, 5.4.2