Index

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

A

activating

a logical standby database, 9.3.2, 18.1

a physical standby database, 12.8.3, 18.1

Active Data Guard

and physical standby databases, 2.1.1, 10.2

and the real-time query feature, 10.2.1

adding

datafiles, 10.3.1, A.10.1.1, A.10.1.1

indexes on logical standby databases, 11.5.4.1

new or existing standby databases, 1.3

online redo log files, 10.3.5

tablespaces, 10.3.1

adjusting

initialization parameter file

for logical standby database, 4.2.4.2

AFFIRM attribute, 17

ALTER DATABASE statement

ABORT LOGICAL STANDBY clause, 18.1

ACTIVATE STANDBY DATABASE clause, 9.3.2, 12.8.3, 18.1, 18.1

ADD STANDBY LOGFILE clause, 18.1, A.1.1

ADD STANDBY LOGFILE MEMBER clause, 18.1, A.1.1, A.1.1

ADD SUPPLEMENTAL LOG DATA clause, 18.1

CLEAR UNARCHIVED LOGFILES clause, 10.5

COMMIT TO SWITCHOVER clause, 9.3.1, 9.3.1, 9.3.1, 18.1

troubleshooting, G.3.2

CREATE CONTROLFILE clause, 10.5

CREATE DATAFILE AS clause, A.1.1

CREATE STANDBY CONTROLFILE clause, 3.2.2, A.1.3

REUSE clause, 18.1

DROP LOGFILE clause, A.1.1

DROP STANDBY LOGFILE MEMBER clause, 18.1, 18.1, 18.1, A.1.1

FORCE LOGGING clause, 2.3.2, 3.1.1, 15.4, 15.4, 18.1

GUARD clause, 11.2

MOUNT STANDBY DATABASE clause, 18.1

OPEN READ ONLY clause, 18.1

OPEN RESETLOGS clause, 10.5

PREPARE TO SWITCHOVER clause, 9.3.1, 9.3.1, 18.1

RECOVER MANAGED STANDBY DATABASE clause, 3.2.6, 4.2.5, 18.1, 18.1, 18.1

canceling, 8.3.2

failover, 18.1

foreground session, 8.3.1, 8.3.1

overriding the delay interval, 8.2.2

RENAME FILE clause, A.1.1, A.1.1

SET STANDBY DATABASE clause

TO MAXIMIZE AVAILABILITY clause, 18.1

TO MAXIMIZE PERFORMANCE clause, 9.1.4

TO MAXIMIZE PROTECTION clause, 18.1

START LOGICAL STANDBY APPLY clause, 8.4.1, 13.5, A.6

IMMEDIATE keyword, 8.4.1

starting SQL Apply, 4.2.5

STOP LOGICAL STANDBY APPLY clause, 8.4.2, 9.3.2, 18.1

ALTER SESSION DISABLE GUARD statement

overriding the database guard, 11.5.4

ALTER SESSION statement

ENABLE GUARD clause, 18.2

ALTER TABLESPACE statement, 10.3.4, 15.4.2, A.10.1.1

FORCE LOGGING clause, 10.3.6

alternate archive destinations

setting up initialization parameters for, A.2

ALTERNATE attribute, 17, 17

LOG_ARCHIVE_DEST_n initialization parameter, A.2

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 7.2.2

ANALYZER process, 11.1

application continuity

support in Oracle Data Guard, 1.5.1

APPLIER process, 11.1

apply lag

monitoring in a real-time query environment, 10.2.1.1

apply lag tolerance

configuring in a real-time query environment, 10.2.1.2

apply services

defined, 1.2.2, 8.1

delaying application of redo data, 8.2.2, 17

real-time apply

defined, 8.2.1, 8.2.1

Redo Apply

defined, 8.1, 8.3

monitoring, 8.3.3

starting, 8.3.1

stopping, 8.3.2

SQL Apply

defined, 1.2.2, 8.1, 8.1

monitoring, 8.4.3

starting, 8.4.1

stopping, 8.4.2

applying

redo data immediately, 8.2.1

redo data on standby database, 1.2.2, 8

SQL statements to logical standby databases, 8.4

applying state, 11.4.1

archive destinations

alternate, A.2

archived redo log files

accessing information about, 10.5.1.3

applying

Redo Apply technology, 1.2.2

SQL Apply technology, 1.2.2

delaying application, 17

on the standby database, 8.2.2

deleting unneeded, 11.4.2

destinations

disabling, 7.2.2

enabling, 7.2.2

managing gaps, 1.7

See also gap management

redo data transmitted, 1.2.2, 8.1

registering

during failover, 9.3.2

standby databases and, 8.3.3, 8.4.3, 10.5.1

troubleshooting switchover problems, A.4.1, G.3.1

ARCHIVELOG mode

software requirements, 2.3.2

archiver processes (ARCn)

influenced by MAX_CONNECTIONS attribute, 17

archiving

real-time apply, 8.2.1

specifying

failure resolution policies for, 17

to failed destinations, 17

ASM

See Automatic Storage Management (ASM)

ASYNC attribute, 17

attributes

deprecated for the LOG_ARCHIVE_DEST_n initialization parameter, 17

AUD$ table

replication on logical standbys, C.13.2

automatic block repair, 10.2.1.5

automatic detection of missing log files, 1.2.1, 1.7

automatic failover, 1.2.3

Automatic Storage Management (ASM)

creating a standby database that uses, 15.5

automatic switchover, 1.2.3

See also switchovers

B

BACKUP INCREMENTAL FROM SCN command

scenarios using, 12.8.1, 12.10

backup operations

after failovers, 9.3.2

after unrecoverable operations, 15.4.3, 15.4.3

configuring on a physical standby database, 1.1.5

datafiles, 15.4.2

offloading on the standby database, 1.7

primary databases, 1.1.2

used by the broker, 1.3

using RMAN, 12

basic readable standby database See simulating a standby database environment

batch processing

on a logical standby database, 11.1.1.4

benefits

Data Guard, 1.7

logical standby database, 2.1.2

of a rolling upgrade, 13.1

physical standby database, 2.1.1

block repair, automatic, 10.2.1.5

broker

command-line interface, 1.7

defined, 1.3

graphical user interface, 1.7

BUILDER process, 11.1

C

cascaded redo transport destinations, 7.3

cascading redo

non-real-time, 7.3

real-time, 7.3

cascading redo data, 7.3

configuration requirements, 7.3

restrictions, 7.3

CDBs

creating a logical standby of, 4.4

creating a physical standby of, 3.4

character sets

changing on primary databases, 15.8

configurations with differing, C.17

checklist

tasks for creating physical standby databases, 3.2, 3.2

tasks for creating standby databases, 4.2, 4.2

checkpoints

V$LOGSTDBY_PROGRESS view, 11.1.1.3

chunking

transactions, 11.1.1.1

CLEAR UNARCHIVED LOGFILES clause

of ALTER DATABASE, 10.5

command-line interface

broker, 1.7

commands, Recovery Manager

DUPLICATE, E.2.1

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 9.3.1, 9.3.1, 18.1

troubleshooting, G.3.2

COMMIT TO SWITCHOVER TO PRIMARY clause

of ALTER DATABASE, 9.3.1

COMPATIBLE initialization parameter

setting after upgrading Oracle Database software, B.4

setting for a rolling upgrade, 13.2, 13.5, 13.5

complementary technologies, 1.6

COMPRESSION attribute, 17

configuration options

creating with Data Guard broker, 1.3

overview, 1.1

physical standby databases

location and directory structure, 2.4

standby databases

delayed standby, 8.2.2

configuring

backups on standby databases, 1.1.5

disaster recovery, 1.1.5

initialization parameters

for alternate archive destinations, A.2

listener for physical standby databases, 5.1.1

no data loss, 1.2.3

physical standby databases, 2.4

reporting operations on a logical standby database, 1.1.5

standby databases at remote locations, 1.1.5

constraints

handled on a logical standby database, 11.6.3

control files

copying, 3.2.4

creating for standby databases, 3.2.2

CONVERT TO SNAPSHOT STANDBY clause on the ALTER DATABASE statement, 18.1

converting

a logical standby database to a physical standby database

aborting, 4.2.4.1

a physical standby database to a logical standby database, 4.2.4.1

COORDINATOR process, 11.1

LSP background process, 11.1

copying

control files, 3.2.4

CREATE CONTROLFILE clause

of ALTER DATABASE, 10.5

CREATE DATABASE statement

FORCE LOGGING clause, 15.4

CREATE DATAFILE AS clause

of ALTER DATABASE, A.1.1

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 3.2.2, 18.1, A.1.3

CREATE TABLE AS SELECT (CTAS) statements

applied on a logical standby database, 11.1.1.5

creating

indexes on logical standby databases, 11.5.4.1

D

data availability

balancing against system performance requirements, 1.7

Data Guard broker

defined, 1.3

distributed management framework, 9

failovers, 1.3

fast-start, 9

manual, 1.3, 9

fast-start failover, 1.3

switchovers, 9

Data Guard configurations

archiving to standby destinations using the log writer process, 8.2.1

defined, 1.1

protection modes, 1.4

upgrading Oracle Database software, B

data loss

due to failover, 1.2.3

switchover and, 9.1

data protection

balancing against performance, 1.7

benefits, 1.7

flexibility, 1.7

provided by Data Guard, 1

data protection modes

enforced by redo transport services, 1.2.1

overview, 1.4, 1.4

Data Pump utility

using transportable tablespaces with physical standby databases, 10.3.3

database caching modes

force full database caching

status in Data Guard configurations, 10.2.1.7

database guard, 11.5.4

overriding, 11.5.4

database incarnation

changes with OPEN RESETLOGS, 10.4, 10.4

database roles

primary, 1.1.1, 9.1

standby, 1.1.2, 9.1

transitions, 1.2.3

database schema

physical standby databases, 1.1.2

databases

failover and, 9.1.4

role transition and, 9.1

surviving disasters and data corruptions, 1

upgrading software versions, 13.1

datafiles

adding to primary database, 10.3.1

monitoring, 10.5, 15.4.2

renaming on the primary database, 10.3.4

DB_FILE_NAME_CONVERT initialization parameter

setting at standby site after a switchover, A.4.3, G.3.3

setting on physical standby database, 3.2.3

when planning standby location and directory structure, 2.4

DB_NAME initialization parameter, 3.1.4

DB_ROLE_CHANGE system event, 9.1.5

DB_UNIQUE_NAME attribute, 17

DB_UNIQUE_NAME initialization parameter, A.4.2, G.3.2

required with LOG_ARCHIVE_CONFIG parameter, 16

setting database initialization parameters, 3.1.4

DBA_DATA_FILES view, 10.5

DBA_LOGMNR_PURGED_LOG view

list archived redo log files that can be deleted, 11.4.2

DBA_LOGSTDBY_EVENTS view, 11.3.1, 19, A.6

recording unsupported operations in, 11.5.1

DBA_LOGSTDBY_HISTORY view, 19

DBA_LOGSTDBY_LOG view, 11.3.2, 19

DBA_LOGSTDBY_NOT_UNIQUE view, 19

DBA_LOGSTDBY_PARAMETERS view, 19

DBA_LOGSTDBY_SKIP view, 19

DBA_LOGSTDBY_SKIP_TRANSACTION view, 19

DBA_LOGSTDBY_UNSUPPORTED view, 19

DBA_TABLESPACES view, 10.5

DBMS_ALERT, C.10.2

DBMS_AQ, C.10.2

DBMS_DESCRIBE, C.10.1

DBMS_JAVA, C.10.2

DBMS_LOB, C.10.1

DBMS_LOGSTDBY package

INSTANTIATE_TABLE procedure, 11.5.5

SKIP procedure, A.6

SKIP_ERROR procedure, A.3

SKIP_TRANSACTION procedure, A.6

DBMS_LOGSTDBY.BUILD procedure

building a dictionary in the redo data, 4.2.3.2

DBMS_METADATA, C.10.1

DBMS_OUTPUT, C.10.1

DBMS_PIPE, C.10.1

DBMS_RANDOM, C.10.1

DBMS_REDEFINITION, C.10.2

DBMS_REFRESH, C.10.2

DBMS_REGISTRY, C.10.2

DBMS_ROLLING package

used for rolling upgrades, 14

DBMS_SCHEDULER, C.10.1

DBMS_SPACE_ADMIN, C.10.2

DBMS_SQL, C.10.1

DBMS_TRACE, C.10.1

DBMS_TRANSACTION, C.10.1

DDL statements

supported by SQL Apply, C

DDL Statements

that use DBLINKS, C.13.1

DDL transactions

applied on a logical standby database, 11.1.1.5

applying to a logical standby database, 11.1.1.5

DEFER attribute

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 7.2.2

DELAY attribute, 17

LOG_ARCHIVE_DEST_n initialization parameter, 8.2.2

DELAY option

of ALTER DATABASE RECOVER MANAGED STANDBY DATABASE

cancelling, 8.2.2

delaying

application of archived redo log files, 17

application of redo log files, 8.2.2

deleting

archived redo log files

indicated by the DBA_LOGMNR_PURGED_LOG view, 11.4.2

not needed by SQL Apply, 11.4.2

deprecated attributes

on the LOG_ARCHIVE_DEST_n initialization parameter, 17

destinations

displaying with V$ARCHIVE_DEST view, 19

role-based definitions, 17

detecting

missing archived redo log files, 1.2.1, 1.7

DG_CONFIG attribute, 17

DGMGRL command-line interface

invoking failovers, 1.3, 9

simplifying switchovers, 1.3, 9

dictionary

building a LogMiner, 4.2.3.2

direct path inserts

SQL Apply DML considerations, 11.1.1.4

directory locations

Optimal Flexible Architecture (OFA), 2.4

structure on standby databases, 2.4

disabling

a destination for archived redo log files, 7.2.2

disaster recovery

benefits, 1.7

configuring, 1.1.5

provided by Data Guard, 1

provided by standby databases, 1.1.5

disk I/O

controlling with the AFFIRM and NOAFFIRM attributes, 17

distributed transactions, C.14

DML

batch updates on a logical standby database, 11.1.1.4

DML operations

on temporary tables, 10.2.2

DML transactions

applying to a logical standby database, 11.1.1.4

downgrading

Oracle Database software, B.6

DROP STANDBY LOGFILE clause

of ALTER DATABASE, A.1.1

DROP STANDBY LOGFILE MEMBER clause

of ALTER DATABASE, 18.1, 18.1, 18.1, A.1.1

dropping

online redo log files, 10.3.5

E

ENABLE attribute

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 7.2.2

ENABLE GUARD clause

of ALTER SESSION, 18.2

enabling

database guard on logical standby databases, 18.2

destinations for archived redo log files, 7.2.2

real-time apply

on logical standby databases, 8.4.1

extended datatype support

during replication, 11.7

F

failovers, 1.2.3

Data Guard broker, 1.3, 9

defined, 1.2.3, 9.1

displaying history with DBA_LOGSTDBY_HISTORY, 19

fast-start failover, 9

flashing back databases after, 9.4

logical standby databases and, 9.3.2

manual versus automatic, 1.2.3

performing backups after, 9.3.2

physical standby databases and, 18.1

preparing for, 9.1.4

simplifying with Data Guard broker, 9

transferring redo data before, 9.1.4

viewing characteristics for logical standby databases, 11.3.3

with maximum performance mode, 9.1.4

with maximum protection mode, 9.1.4

failure resolution policies

specifying for redo transport services, 17

far sync instances, 5

creating, 5.1, 5.1

supported protection modes, 5.3

fast-start failover

automatic failover, 1.3, 9

monitoring, 10.5

FastSync mode, 6.1

FGA_LOG$ table

replication on logical standbys, C.13.2

file specifications

renaming on the logical standby database, 11.5.3

Flashback Database

after a role transition, 9.4

after OPEN RESETLOGS, 15.3

after role transitions, 9.4

characteristics complementary to Data Guard, 1.6

physical standby database, 15.2.1

force full database caching mode

status in Data Guard configurations, 10.2.1.7

FORCE LOGGING clause

of ALTER DATABASE, 2.3.2, 3.1.1, 15.4, 15.4, 18.1

of ALTER TABLESPACE, 10.3.6

of CREATE DATABASE, 15.4

G

gap management

automatic detection and resolution, 1.2.1, 1.7

detecting missing log files, 1.7

registering archived redo log files

during failover, 9.3.2

Global Data Services, 1.6

global temporary tables

DML operations, 10.2.2

H

high availability

benefits, 1.7

provided by Data Guard, 1

provided by Oracle RAC and Data Guard, 1.6

I

idle state, 11.4.1

incarnation of a database

changed, 10.4, 10.4

initialization parameters

DB_UNIQUE_NAME, 3.1.4, A.4.2, G.3.2

LOG_ARCHIVE_MIN_SUCCEED_DEST, 17

LOG_FILE_NAME_CONVERT, E.2.2.4

modifying for physical standby databases, 3.2.3

setting for both the primary and standby roles, 17

INITIALIZING state, 11.4.1

INSTANTIATE_TABLE procedure

of DBMS_LOGSTDBY, 11.5.5

K

KEEP IDENTITY clause, 4.2.4.1

L

latency

on logical standby databases, 11.1.1.4, 11.1.1.5

listener.ora file

configuring, 3.2.5

redo transport services tuning and, A.7

troubleshooting, A.1.2, A.7

loading dictionary state, 11.4.1

LOCATION attribute, 17

setting

LOG_ARCHIVE_DEST_n initialization parameter, A.2

log apply services

Redo Apply

monitoring, 10.5.1

starting, 10.1.1

stopping, 10.1.2

tuning for Redo Apply, 10.6

log writer process (LGWR)

ASYNC network transmission, 17

NET_TIMEOUT attribute, 17

SYNC network transmission, 17

LOG_ARCHIVE_CONFIG initialization parameter, 3.1.4, 3.1.4, 3.2.3

example, 17

listing unique database names defined with, 19

relationship to DB_UNIQUE_NAME parameter, 16

relationship to DG_CONFIG attribute, 17

LOG_ARCHIVE_DEST_n initialization parameter

AFFIRM attribute, 17

ALTERNATE attribute, 17, 17, A.2

ASYNC attribute, 17

COMPRESSION attribute, 17

DB_UNIQUE_NAME attribute, 17

DELAY attribute, 8.2.2, 17

deprecated attributes, 17

LOCATION attribute, 17, A.2

MANDATORY attribute, 17

MAX_CONNECTIONS attribute, 17

MAX_FAILURE attribute, 17

NET_TIMEOUT attribute, 17

NOAFFIRM attribute, 17

NOALTERNATE attribute, A.2

NODELAY attribute, 8.2.2

NOREGISTER attribute, 17

REOPEN attribute, 17, 17

SERVICE attribute, 17

SYNC attribute, 17

VALID_FOR attribute, 17

LOG_ARCHIVE_DEST_STATE_n initialization parameter

ALTERNATE attribute, 7.2.2

DEFER attribute, 7.2.2

ENABLE attribute, 7.2.2

LOG_ARCHIVE_MAX_PROCESSES initialization parameter

relationship to MAX_CONNECTIONS, 17

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 17

LOG_FILE_NAME_CONVERT initialization parameter

setting at standby site after a switchover, A.4.3, G.3.3

setting on physical standby databases, 3.2.3

when planning standby location and directory structure, 2.4

logical change records (LCR)

converted by PREPARER process, 11.1

exhausted cache memory, 11.1.1.2

staged, 11.1

logical standby databases, 1.1.2

adding

datafiles, A.10.1.1

indexes, 11.5.4.1

tables, 11.5.5

background processes, 11.1

benefits, 2.1.2

controlling user access to tables, 11.2

creating, 4

converting from a physical standby database, 4.2.4.1

with Data Guard broker, 1.3

data types

supported, C, C.1.1

unsupported, C.1.2

database guard

overriding, 11.5.4

executing SQL statements on, 1.1.2

failovers, 9.3.2

displaying history of, 19, 19

handling failures, A.3

viewing characteristics with V$LOGSTDBY_STATS, 11.3.3

logical standby process (LSP) and, 11.1

materialized views

support for, C.12

monitoring, 8.4.3, 19

renaming the file specification, 11.5.3

setting up a skip handler, 11.5.3

SQL Apply, 1.2.2

resynchronizing with primary database branch of redo, 11.6.5

skipping DDL statements, C.12

skipping SQL statements, C.12

starting real-time apply, 8.4.1

stopping, 8.4.2

technology, 8.1

transaction size considerations, 11.1.1.1

starting

real-time apply, 8.4.1, 8.4.1

states

applying, 11.4.1

idle, 11.4.1

initializing, 11.4.1

loading dictionary, 11.4.1

waiting on gaps, 11.4.1

support for primary databases with Transparent Data Encryption, C.3

switchovers, 9.3.1, 9.3.1

throughput and latency, 11.1.1.4, 11.1.1.5

upgrading, B.3

rolling upgrades, 2.3.2

logical standby process (LSP)

COORDINATOR process, 11.1

LogMiner dictionary

using DBMS_LOGSTDBY.BUILD procedure to build, 4.2.3.2

when creating a logical standby database, 4.2.4.1

M

managed recovery operations

See Redo Apply

MANDATORY attribute, 17

MAX_CONNECTIONS attribute

configuring Oracle RAC for parallel archival, 17

reference, 17

MAX_FAILURE attribute, 17

maximum availability mode

introduction, 1.4

maximum performance mode, 9.1.4

introduction, 1.4

maximum performance protection mode, 6.1

maximum protection mode

for Oracle Real Application Clusters, D.2.2

introduction, 1.4

standby databases and, 9.1.4

memory

exhausted LCR cache, 11.1.1.2

missing log sequence

detecting, 1.7, 1.7

See also gap management

modifying

a logical standby database, 11.5.4

initialization parameters for physical standby databases, 3.2.3

monitoring

primary database events, 10.5

tablespace status, 10.5

MOUNT STANDBY DATABASE clause

of ALTER DATABASE, 18.1

multitenant container databases

See CDBs

N

NET_TIMEOUT attribute, 17

network connections

configuring multiple, 17

in an Oracle RAC environment, 17

network I/O operations

network timers

NET_TIMEOUT attribute, 17

tuning

redo transport services, A.7

network timeouts

acknowledging, 17

no data loss

data protection modes overview, 1.4

ensuring, 1.2.3

guaranteeing, 1.2.3

provided by maximum availability mode, 1.4

provided by maximum protection mode, 1.4

NOAFFIRM attribute, 17

NOALTERNATE attribute

LOG_ARCHIVE_DEST_n initialization parameter, A.2

NODELAY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 8.2.2

NOREGISTER attribute, 17

O

OMF

See Oracle Managed Files (OMF)

on-disk database structures

physical standby databases, 1.1.2

online data files

moving the location, 2.5

online redo log files

adding, 10.3.5

dropping, 10.3.5

OPEN READ ONLY clause

of ALTER DATABASE, 18.1

OPEN RESETLOGS

flashing back after, 15.3

OPEN RESETLOGS clause

database incarnation change, 10.4, 10.4

of ALTER DATABASE, 10.5

recovery, 10.4, 10.4

operational requirements, 2.3, 2.3.2

Optimal Flexible Architecture (OFA)

directory structure, 2.4

ORA-01102 message

causing switchover failures, A.4.2, G.3.2

Oracle Database software

requirements for upgrading with SQL Apply, 13.2

upgrading, 2.3.2, B.1

upgrading with SQL Apply, 13.1

Oracle Enterprise Manager

invoking failovers, 1.3, 9

invoking switchovers, 1.3, 9

Oracle Managed Files (OMF)

creating a standby database that uses, 15.5

Oracle RAC One Node

supported by Oracle Data Guard, 1.6

Oracle Real Application Clusters

characteristics complementary to Data Guard, 1.6

configuring for multiple network connections, 17

primary databases and, 1.1.1, D.1.1

setting

maximum data protection, D.2.2

standby databases and, 1.1.2, D.1

Oracle Recovery Manager utility (RMAN)

backing up files on a physical standby database, 12

Oracle Standard Edition

simulating a standby database environment, 2.3.2

P

pageout considerations, 11.1.1.2

pageouts

SQL Apply, 11.1.1.2

parallel DML (PDML) transactions

SQL Apply, 11.1.1.3, 11.1.1.4

patch set releases

upgrading, 2.3.2

performance

balancing against data availability, 1.7

balancing against data protection, 1.7

physical standby databases

and Oracle Active Data Guard, 2.1.1

applying redo data, 8.1, 8.3

Redo Apply technology, 8.3

applying redo log files

starting, 8.3.1

benefits, 2.1.1

configuration options, 2.4

converting datafile path names, 3.2.3

converting log file path names, 3.2.3

converting to a logical standby database, 4.2.4.1

creating

checklist of tasks, 3.2

configuring a listener, 5.1.1

directory structure, 2.4

initialization parameters for, 3.2.3

with Data Guard broker, 1.3

defined, 1.1.2

failover

checking for updates, 9.1.4

flashing back after failover, 15.2.1

monitoring, 8.3.3, 10.5.1, 19

opening for read-only or read/write access, 10.2

read-only, 10.2

recovering through OPEN RESETLOGS, 10.4

Redo Apply, 1.2.2

resynchronizing with primary database branch of redo, 10.4, 10.4

role transition and, 9.2, G

rolling forward with BACKUP INCREMENTAL FROM SCN command, 12.8.1, 12.10

shutting down, 10.1.2

starting

apply services, 8.3.1

tuning the log apply rate, 10.6

upgrading, B.2

using transportable tablespaces, 10.3.3

PL/SQL supplied packages

supported, C.10.1

unsupported, C.10.2

PREPARE TO SWITCHOVER clause

of ALTER DATABASE, 9.3.1, 9.3.1, 18.1

PREPARER process, 11.1

staging LCRs in SGA, 11.1

primary database

backups and, 9.3.2

configuring

on Oracle Real Application Clusters, 1.1.1

single-instance, 1.1.1

datafiles

adding, 10.3.1

defined, 1.1.1

failover and, 9.1

gap resolution, 1.7

initialization parameters

and physical standby database, 3.2.3

monitoring events on, 10.5

network connections

avoiding network hangs, 17

handling network timeouts, 17

Oracle Real Application Clusters and

setting up, D.1.1

preparing for

physical standby database creation, 3.1

prerequisite conditions for

logical standby database creation, 4.1

redo transport services on, 1.2.1

reducing workload on, 1.7

switchover, 9.1.3

tablespaces

adding, 10.3.1

primary databases

ARCHIVELOG mode, 2.3.2

software requirements, 2.3.2

primary key columns

logged with supplemental logging, 4.2.3.2, 11.1.1.4

primary role, 1.1.1

processes

SQL Apply architecture, 11.1, 11.4.1

protection modes

maximum availability mode, 1.4

maximum performance, 6.1

maximum performance mode, 1.4

maximum protection mode, 1.4

monitoring, 10.5

setting on a primary database, 6.2

Q

queries

offloading on the standby database, 1.7

R

READER process, 11.1

read-only operations, 1.2.2

physical standby databases and, 10.2

real-time apply

defined, 8.2.1

starting

on logical standby, 8.4.1

starting on logical standby databases, 8.4.1

stopping

on logical standby, 8.4.2

on physical standby databases, 10.1.2

real-time cascading, 7.3

real-time query feature, 10.2

and Oracle Active Data Guard, 10.2, 10.2.1

configuring apply lag tolerance, 10.2.1.2

forcing Redo Apply synchronization, 10.2.1.3

monitoring apply lag, 10.2.1.1

restrictions, 10.2.1.4

using, 10.2.1

RECORD_UNSUPPORTED_OPERATIONS

example, 11.5.1

RECOVER MANAGED STANDBY DATABASE CANCEL clause

aborting, 4.2.4.1

RECOVER MANAGED STANDBY DATABASE clause

canceling the DELAY control option, 8.2.2

of ALTER DATABASE, 3.2.6, 4.2.5, 8.3.1, 18.1, 18.1, 18.1, 18.1

foreground session, 8.3.1, 8.3.1

overriding the delay interval, 8.2.2

RECOVER TO LOGICAL STANDBY clause

converting a physical standby database to a logical standby database, 4.2.4.1

recovering

from errors, A.10.1

logical standby databases, 11.6.5

physical standby databases

after an OPEN RESETLOGS, 10.4, 10.4

through resetlogs, 10.4, 11.6.5

Recovery Manager

characteristics complementary to Data Guard, 1.6

commands

DUPLICATE, E.2.1

standby database

creating, E.2.1

LOG_FILE_NAME_CONVERT initialization parameter, E.2.2.4

preparing using RMAN, E.2.2

re-creating

a table on a logical standby database, 11.5.5

Redo Apply

defined, 1.2.2, 8.1

flashing back after failover, 15.2.1

starting, 3.2.6

stopping, 10.1.2

technology, 1.2.2

tuning the log apply rate, 10.6

redo data

applying

through Redo Apply technology, 1.2.2

through SQL Apply technology, 1.2.2

to standby database, 8.1

to standby databases, 1.1.2

applying during conversion of a physical standby database to a logical standby database, 4.2.4.1

archiving on the standby system, 1.2.2, 8.1

building a dictionary in, 4.2.3.2

cascading, 7.3

transmitting, 1.1.2, 1.2.1

redo gaps, 7.6.3

manual resolution, 7.6.3.1

reducing resolution time, 7.6.3

redo log files

delaying application, 8.2.2

redo logs

automatic application on physical standby databases, 8.3.1

update standby database tables, 1.7

redo transport services, 7

archive destinations

alternate, A.2

re-archiving to failed destinations, 17

authenticating sessions

using SSL, 7.2.1.1

configuring, 7.2

configuring security, 7.2.1

defined, 1.2.1

gap detection, 7.6.3

handling archive failures, 17

monitoring status, 7.6.1

network

tuning, A.7

protection modes

maximum availability mode, 1.4

maximum performance mode, 1.4

maximum protection mode, 1.4

receiving redo data, 7.2.3

sending redo data, 7.2.2

synchronous and asynchronous disk I/O, 17

wait events, 7.6.4

of ALTER DATABASE, 18.1, A.4.1, G.3.1

of ALTER DATABASE, 9.3.2

registering

archived redo log files

during failover, 9.3.2

RELY constraint

creating, 4.1.2

remote file server process (RFS)

log writer process and, 8.2.1

RENAME FILE clause

of ALTER DATABASE, A.1.1, A.1.1

renaming

datafiles

on the primary database, 10.3.4

setting the STANDBY_FILE_MANAGEMENT parameter, 10.3.4

REOPEN attribute, 17, 17

reporting operations

configuring, 1.1.5

offloading on the standby database, 1.7

requirements

of a rolling upgrade, 13.2

restart considerations

SQL Apply, 11.1.1.3

resynchronizing

logical standby databases with a new branch of redo, 11.6.5

physical standby databases with a new branch of redo, 10.4, 10.4

retrieving

missing archived redo log files, 1.2.1, 1.7

RMAN BACKUP INCREMENTAL FROM SCN command, 12.8.1, 12.10

RMAN backups

accessibility in Data Guard environment, 12.1.3

association in Data Guard environment, 12.1.2

interchangeability in Data Guard environment, 12.1.1

role management services

defined, 9

role transition triggers, 9.1.5

DB_ROLE_CHANGE system event, 9.1.5

role transitions, 1.2.3, 9.1

choosing a type of, 9.1.1

defined, 1.2.3

flashing back the databases after, 9.4

logical standby database and, 9.3

monitoring, 10.5

physical standby databases and, 9.2, G

reversals, 1.2.3, 9.1

role-based destinations

setting, 17

rollback

after switchover failures, A.4.4, G.3.4

rolling upgrade

software requirements, 2.3.2

rolling upgrades

benefits, 13.1

DBMS_ROLLING package, 14

patch set releases, 2.3.2

requirements, 13.2

setting the COMPATIBLE initialization parameter, 13.2, 13.5, 13.5

unsupported data types and storage attributes, 13.4

use of KEEP IDENTITY clause, 4.2.4.1

using Active Data Guard, 14

S

scenarios

recovering

after NOLOGGING is specified, 15.4

schemas

identical to primary database, 1.1.2

sequences

unsupported on logical standby databases, C.11

using in Oracle Active Data Guard, 10.2.3

SERVICE attribute, 17

SET STANDBY DATABASE clause

of ALTER DATA, 18.1

of ALTER DATABASE, 9.1.4, 18.1

shutting down

physical standby database, 10.1.2

simulating

standby database environment, 2.3.2

skip handler

setting up on a logical standby database, 11.5.3

SKIP procedure

of DBMS_LOGSTDBY, A.6

SKIP_ERROR procedure

of the DBMS_LOGSTDBY package, A.3

SKIP_TRANSACTION procedure

of DBMS_LOGSTDBY, A.6

snapshot standby databases, 1.1.2

managing, 10.7

software requirements, 2.3.2

rolling upgrades, 2.3.2, 2.3.2

SQL Apply, 8.4.2, 11.1.1.2

after an OPEN RESETLOGS, 11.6.5

ANALYZER process, 11.1

APPLIER process, 11.1

applying CREATE TABLE AS SELECT (CTAS) statements, 11.1.1.5

applying DDL transactions, 11.1.1.5, 11.1.1.5

applying DML transactions, 11.1.1.4

architecture, 11.1, 11.4.1

BUILDER process, 11.1

COORDINATOR process, 11.1

defined, 1.2.2, 8.1

deleting archived redo log files, 11.4.2

parallel DML (PDML) transactions, 11.1.1.3, 11.1.1.4

performing a rolling upgrade, 13.1

PREPARER process, 11.1

READER process, 11.1

requirements for rolling upgrades, 13.2

restart considerations, 11.1.1.3

rolling upgrades, 2.3.2

starting

real-time apply, 8.4.1

stopping

real-time apply, 8.4.2

support for DDL statements, C

support for PL/SQL supplied packages, C.10.1

supported data types, C.1.1

transaction size considerations, 11.1.1.1

unsupported data types, C.1.2

unsupported PL/SQL supplied packages, C.10.2

viewing current activity, 11.1

of processes, 11.1

what to do if it stops, A.6

SQL statements

executing on logical standby databases, 1.1.2, 1.2.2

skipping on logical standby databases, C.12

standby database

creating logical, 4

standby databases

about creating using RMAN, E.2.1

apply services on, 8.1

applying redo data on, 8

applying redo log files on, 1.2.2, 1.7

ARCn processes using multiple network connections, 17

configuring, 1.1

maximum number of, 2

on Oracle Real Application Clusters, 1.1.2, D.1

on remote locations, 1.1.5

single-instance, 1.1.2

creating, 1.1.2

checklist of tasks, 4.2

directory structure considerations, 2.4

if primary uses ASM or OMF, 15.5

on remote host with same directory structure, E.3

with a time lag, 8.2.2

defined, 2.1

failover

preparing for, 9.1.4

failover to, 9.1.4

LOG_FILE_NAME_CONVERT initialization parameter, E.2.2.4

operational requirements, 2.3, 2.3.2

preparing to use RMAN, E.2.2

recovering through OPEN RESETLOGS, 10.4

resynchronizing with the primary database, 1.7

SET AUXNAME command, E.2.2.4

SET NEWNAME command, E.2.2.4

software requirements, 2.3.2

starting apply services on physical, 8.3.1

See also logical standby databases

See also physical standby databases

standby redo log files

and real-time apply, 8.2.1

standby redo logs

creating and managing, 7.2.3.1

standby role, 1.1.2

STANDBY_FILE_MANAGEMENT initialization parameter

when renaming datafiles, 10.3.4

START LOGICAL STANDBY APPLY clause

IMMEDIATE keyword, 8.4.1

of ALTER DATABASE, 4.2.5, 8.4.1, 13.5, A.6

starting

logical standby databases, 4.2.5

physical standby databases, 3.2.6

real-time apply, 8.4.1, 8.4.1

on logical standby databases, 8.4.1, 8.4.1

Redo Apply, 3.2.6, 10.1.1

SQL Apply, 4.2.5, 8.4.1

STOP LOGICAL STANDBY APPLY clause

of ALTER DATABASE, 8.4.2, 9.3.2, 18.1

stopping

real-time apply

on logical standby databases, 8.4.2

real-time apply on physical standby databases, 8.3.2

Redo Apply, 8.3.2

SQL Apply, 8.4.2

storage attributes

unsupported during a rolling upgrade, 13.4

streams capture

running on a logical standby, 11.6.6

supplemental logging

setting up to log primary key and unique-index columns, 4.2.3.2, 11.1.1.4

supported data types

for logical standby databases, C, C.13

supported PL/SQL supplied packages, C.10.1

SWITCHOVER_STATUS column

of V$DATABASE view, A.4.1, G.3.1

switchovers, 1.2.3

choosing a target standby database, 9.1.2

defined, 1.2.3, 9.1

displaying history with DBA_LOGSTDBY_HISTORY, 19

fails with ORA-01102, A.4.2, G.3.2

flashing back databases after, 9.4

logical standby databases and, 9.3.1

manual versus automatic, 1.2.3

monitoring, 10.5

no data loss and, 9.1

preparing for, 9.1.3

seeing if the last archived redo log file was transmitted, A.4.1, G.3.1

setting DB_FILE_NAME_CONVERT after, A.4.3, G.3.3

setting LOG_FILE_NAME_CONVERT after, A.4.3, G.3.3

simplifying with Data Guard broker, 1.3, 9

starting over, A.4.4, G.3.4

typical use for, 9.1.3

SYNC attribute, 17

system events

role transitions, 9.1.5

system global area (SGA)

logical change records staged in, 11.1

system resources

efficient utilization of, 1.7

T

tables

logical standby databases

adding on, 11.5.5

re-creating tables on, 11.5.5

unsupported on, C.11

tablespaces

adding

a new datafile, A.10.1.1

to primary database, 10.3.1

monitoring status changes, 10.5

moving between databases, 10.3.3

target standby database

for switchover, 9.1.2

terminal destinations, 7.3

configuring, 7.3.1

terminating

network connection, 17

throughput

on logical standby databases, 11.1.1.4, 11.1.1.5

time lag

delaying application of archived redo log files, 8.2.2, 17

in standby database, 8.2.2

TIME_COMPUTED column, 9.1.2

TIME_COMPUTED column of the V$DATAGUARD_STATS view, 9.1.2

tnsnames.ora file

redo transport services tuning and, A.7

troubleshooting, A.1.2, A.4.3, A.7, G.3.3

transaction size considerations

SQL Apply, 11.1.1.1

Transparent Data Encryption

support by SQL Apply, C.3

transportable tablespaces

using with a physical standby database, 10.3.3

triggers

handled on a logical standby database, 11.6.3

role transitions, 9.1.5

troubleshooting

if SQL Apply stops, A.6

last redo data was not transmitted, A.4.1, G.3.1

listener.ora file, A.1.2, A.7

logical standby database failures, A.3

SQL Apply, A.6

switchovers, A.4

ORA-01102 message, A.4.2, G.3.2

roll back and start over, A.4.4, G.3.4

tnsnames.ora file, A.1.2, A.4.3, A.7, G.3.3

tuning

log apply rate for Redo Apply, 10.6

U

unique-index columns

logged with supplemental logging, 4.2.3.2, 11.1.1.4

unrecoverable operations, 15.4.2

backing up after, 15.4.3

unsupported data types

during a rolling upgrade, 13.4

unsupported operations

capturing in DBA_LOGSTDBY_EVENTS view, 11.5.1

unsupported PL/SQL supplied packages, C.10.2

upgrading

Oracle Database software, 2.3.2, 13.1, B, B.1

setting the COMPATIBLE initialization parameter, B.4

V

V$ARCHIVE_DEST view, 19, A.1.2

displaying information for all destinations, 19

V$ARCHIVE_DEST_STATUS view, 19

V$ARCHIVE_GAP view, 19

V$ARCHIVED_LOG view, 10.5.1.3, 19, A.4.1, G.3.1

V$DATABASE view, 19

monitoring fast-start failover, 10.5

SWITCHOVER_STATUS column and, A.4.1, G.3.1

V$DATABASE_INCARNATION view, 19

V$DATAFILE view, 15.4.2, 15.4.3, 19

V$DATAGUARD_CONFIG view, 19

listing database names defined with LOG_ARCHIVE_CONFIG, 19

V$DATAGUARD_STATS view, 9.1.2, 19

V$DATAGUARD_STATUS view, 10.5.1.5, 19

V$FS_FAILOVER_STATS view, 19

V$LOG view, 19

V$LOG_HISTORY view, 10.5.1.4, 19

V$LOGFILE view, 19

V$LOGSTDBY_PROCESS view, 11.1, 11.3.4, 11.3.4, 11.4.1, 11.8.3.1, 11.8.3.2, 19

V$LOGSTDBY_PROGRESS view, 11.3.5, 19

RESTART_SCN column, 11.1.1.3

V$LOGSTDBY_STATE view, 9.1.2, 11.3.6, 11.4.1, 19

V$LOGSTDBY_STATS view, 11.1, 11.3.7, 19

failover characteristics, 11.3.3

V$LOGSTDBY_TRANSACTION view, 19

V$MANAGED_STANDBY view, 10.5.1.2, 10.5.1.2, 19

V$REDO_DEST_RESP_HISTOGRAM

using to monitor synchronous redo transport response time, 7.6.2

V$REDO_DEST_RESP_HISTOGRAM view, 19

V$STANDBY_EVENT_HISTOGRAM view, 19

V$STANDBY_LOG view, 19

V$THREAD view, 10.5

VALID_FOR attribute, 17

verifying

logical standby databases, 4.2.6

physical standby databases, 3.2.7

versions

upgrading Oracle Database software, 13.1

views

DBA_LOGSTDBY_EVENTS, 11.3.1, 19, A.6

DBA_LOGSTDBY_HISTORY, 19

DBA_LOGSTDBY_LOG, 11.3.2, 19

DBA_LOGSTDBY_NOT_UNIQUE, 19

DBA_LOGSTDBY_PARAMETERS, 19

DBA_LOGSTDBY_SKIP, 19

DBA_LOGSTDBY_SKIP_TRANSACTION, 19

DBA_LOGSTDBY_UNSUPPORTED, 19

V$ARCHIVE_DEST, 19, A.1.2

V$ARCHIVE_DEST_STATUS, 19

V$ARCHIVED_GAP, 19

V$ARCHIVED_LOG, 10.5.1.3, 19

V$DATABASE, 19

V$DATABASE_INCARNATION, 19

V$DATAFILE, 15.4.2, 15.4.3, 19

V$DATAGUARD_CONFIG, 19

V$DATAGUARD_STATS, 19

V$DATAGUARD_STATUS, 10.5.1.5, 19

V$FS_FAILOVER_STATS, 19

V$LOG, 19

V$LOG_HISTORY, 10.5.1.4, 19

V$LOGFILE, 19

V$LOGSTDBY_PROCESS, 11.1, 11.3.4, 19

V$LOGSTDBY_PROGRESS, 11.3.5, 19

V$LOGSTDBY_STATE, 11.3.6, 19

V$LOGSTDBY_STATS, 11.1, 11.3.7, 19

V$LOGSTDBY_TRANSACTION, 19

V$MANAGED_STANDBY, 10.5.1.2, 10.5.1.2, 19

V$REDO_DEST_RESP_HISTOGRAM, 19

V$STANDBY_EVENT_HISTOGRAM, 19

V$STANDBY_LOG, 19

V$THREAD, 10.5

W

wait events

for redo transport services, 7.6.4

WAITING FOR DICTIONARY LOGS state, 11.4.1

waiting on gap state, 11.4.1

Z

zero downtime instantiation

logical standby databases, 4.2