Oracle Data Guard Concepts and Administration -- Index

ABORT LOGICAL STANDBY clause

of ALTER DATABASE, 13-16

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, 7-26, 10-17, 13-1

ADD STANDBY LOGFILE clause

of ALTER DATABASE, 5-9, 6-7, 7-14, 8-15, 13-2

ADD STANDBY LOGFILE GROUP clause

of ALTER DATABASE, 5-10, 13-2

ADD STANDBY LOGFILE MEMBER clause

of ALTER DATABASE, 5-10, 6-7, 13-3

ADD STANDBY LOGFILE THREAD clause

of ALTER DATABASE, 13-2

ADD STANDBY MEMBER clause

of ALTER DATABASE, 5-10

ADD SUPPLEMENTAL LOG DATA clause

of ALTER DATABASE, 4-9, 4-10, 13-4

ADD TEMPFILE clause

of ALTER TABLESPACE, 4-22, 8-6

adding

datafiles, 6-6, 8-10, 9-14, 9-15

examples, 8-10

indexes on logical standby databases, 1-7, 2-4, 9-4

new or existing standby databases, 1-5

online redo logs, 5-8, 8-14

standby redo logs, 5-9

tablespaces, 8-10

temporary files, 4-22

AFFIRM attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-19, 5-25, 12-2, 12-6, 12-54

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE

DELAY control option, 5-6

ALTER DATABASE statement, 13-1

ABORT LOGICAL STANDBY clause, 13-16

ACTIVATE STANDBY DATABASE clause, 7-26, 10-17, 13-1

ADD STANDBY LOGFILE clause, 5-9, 6-7, 7-14, 8-15, 13-2, 13-3

keywords for, 13-2

ADD STANDBY LOGFILE GROUP clause, 5-9, 5-10

ADD STANDBY LOGFILE MEMBER clause, 5-10, 6-7

keywords for, 13-3

ADD SUPPLEMENTAL LOG DATA clause, 4-9, 4-10, 13-4

ALTER STANDBY LOGFILE clause, 5-9

ALTER STANDBY LOGFILE GROUP clause, 5-10

CLEAR UNARCHIVED LOGFILES clause, 8-17

COMMIT TO SWITCHOVER clause, 7-12, 7-14, 7-17, 7-19, 7-20, 10-19, 13-5, 13-16, E-4

in Real Application Clusters, C-10

troubleshooting, A-5, A-7, A-8, A-9

CREATE CONTROLFILE clause, 8-9, 8-16, 8-17

CREATE DATAFILE AS clause, 6-7

CREATE STANDBY CONTROLFILE clause, 3-4, A-3

REUSE clause, 13-6

DROP LOGFILE clause, 6-7

DROP STANDBY LOGFILE MEMBER clause, 6-7, 13-7

FORCE LOGGING clause, 2-6, 3-2, 4-2, 10-21, 13-8, 13-9

GUARD clause, 4-19, 7-21, 9-3

keywords of, 9-3, 9-4

MOUNT STANDBY DATABASE clause, 3-9, 6-3, 7-12, 8-2, 8-5, 8-14, 10-19, 13-9, B-4

NOFORCE LOGGING clause, 13-8, 13-9

online redo logs and, 7-13

OPEN READ ONLY clause, 8-5, 13-9

OPEN RESETLOGS clause, 4-19, 4-21, 8-17

RECOVER MANAGED STANDBY DATABASE clause, 3-9, 5-6, 7-14, 8-5, 8-7, 10-9, 10-17, 13-9, B-12, C-9

background process, 6-4, 8-2, 13-10

cancelling, 6-5

cancelling log apply services, 8-5

controlling redo apply operations, 6-5

failover operations, 13-2

foreground session, 6-4, 13-10

gap resolution, 6-15

initiating failover, 7-17

keywords, 13-11

overriding the delay interval, 12-17

skipping standby logfiles, 7-17, 13-2, C-9

switchover scenario, 10-18

syntax, 13-10

REGISTER LOGFILE clause, 7-18, 12-43, 13-13, A-6

keywords, 13-14

REGISTER LOGICAL LOGFILE clause, 4-22, 10-14

RENAME FILE clause, 4-18, 6-7, B-12, B-13

restrictions, 6-7

SET STANDBY DATABASE clause, 5-26

TO MAXIMIZE AVAILABILITY clause, 13-14

TO MAXIMIZE PERFORMANCE clause, 7-10, 13-14

TO MAXIMIZE PROTECTION clause, 13-14

START LOGICAL STANDBY APPLY clause, 6-9, 7-27, 13-15, A-11

INITIAL keyword, 4-23

NEW PRIMARY keyword, 7-27

STOP LOGICAL STANDBY APPLY clause, 6-9, 7-26, 10-14, 13-16

TEMPFILE clause, 4-22

ALTER SYSTEM statement

ARCHIVE LOG CURRENT clause, 3-10, 4-23, 10-21

SET LOG_ARCHIVE_DEST_STATE_n clause, 7-19, 7-20, 7-27

SET LOG_ARCHIVE_TRACE clause, 6-25

SET LOG_PARALLELISM clause, 4-3

ALTER TABLESPACE

skipping, 8-11

ALTER TABLESPACE statement, 8-11, 8-13, 9-15, 10-23

ADD TEMPFILE clause, 4-22, 8-6

FORCE LOGGING clause, 8-16

skipping, 9-7

TEMPFILE clause, 4-22

altering

control files, 8-15

alternate archive destinations

setting up initialization parameters for, A-4

ALTERNATE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-9, A-3

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-12

ANALYZER process, 9-10

APPLIED_SCN column

of DBA_LOGSTDBY_PROGRESS view, 10-12

APPLIER process, 9-10

apply delay interval

disabling, 7-25

specifying

for logical standby databases, 9-12

for physical standby databases, 5-6, 13-11

superceding, 5-6

APPLY_SET procedure

of DBMS_LOGSTDBY, 9-3

APPLY_UNSET procedure

of DBMS_LOGSTDBY, 9-3

applying

redo logs on standby database, 1-4, 2-2, 6-1

SQL statements to logical standby databases, 6-7

AQ_TM_PROCESSES dynamic parameter, A-10

ARCH attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-18, 12-14

archive destinations

See destinations

alternate, A-3

archive gap

defined, 6-11

archive gaps

causes of, B-5

identifying the logs, 6-14, B-8

manually applying redo logs to standby database, B-11

manually copying the logs in, B-9

preventing, B-7

resolving using Oracle Net Manager, 6-14

ARCHIVE LOG CURRENT clause

of ALTER SYSTEM, 3-10, 4-23, 10-21

archive tracing

standby databases and, 5-33, 6-24

ARCHIVE_LAG_TARGET

initialization parameter, 11-6

archived redo logs

accessing information about, 6-16, 8-21

applying

redo apply technology, 1-4

SQL apply technology, 1-5

to physical and logical standby databases, 1-3

defined, 5-5

delayed application, 5-6, 9-12, 13-11

cancelling, 9-12

on the standby database, 5-6

destinations, 5-12 to 5-19

disabling, 5-12

displaying with DBA_LOGSTDBY_LOG view, 10-12

displaying with V$ARCHIVE_DEST view, 14-12

displaying with V$ARCHIVE_DEST_STATUS view, 14-15

enabling, 5-12

determining the most recently archived, 5-32

listing, 10-12

managing gaps, 1-8, 6-10, 6-11

See also gap management

manually transmitting, B-9

progression to the standby site, 11-22

redo data transmitted, 1-4, 6-1

registering, 4-22, 6-13, 7-24, 10-14

during failover, 7-23

partial, 10-15

retrieving missing, 10-14

specifying

dependent destinations, 5-15

location on the standby database, 5-13

standby databases and, 6-15, 6-19

ARCHIVELOG mode

switching from primary role to standby, 7-8

archiver process

See ARCn process

archiving

automatically, 5-7

cross-instance, C-6

redo logs

setting permissions for, 5-5

specifying failure resolution policies for, 5-16

specifying network transmission modes for, 5-18

starting, 3-10, 4-23

to failed destinations, 5-16

to standby databases, 5-7

See also archived redo logs

ARCn process

defined, 5-19

setting up cross-instance archival, C-6

ASYNC attribute

initiating network I/O operations, 12-50

LOG_ARCHIVE_DEST_n initialization parameter, 5-19, 12-48

required for no data loss environments, 5-19

asynchronous network I/O operations, 12-48

asynchronous network transmission method, 5-19

attribute compatibility

LOG_ARCHIVE_DEST_n initialization parameter, 12-54

automatic detection of missing logs, 1-5, 1-8, 6-10

backup operations

after unrecoverable operations, 10-24

configuring on a physical standby database, 1-3

datafiles, 10-23

offloading on the standby database, 1-7

primary databases, 1-2, 3-4, 7-18

used by the broker, 1-5

benefits

Data Guard, 1-7

logical standby database, 2-4

physical standby database, 2-2

broker

command-line interface, 1-8

defined, 1-5

graphical user interface, 1-8

BUILD procedure

of DBMS_LOGSTDBY, 4-14, 9-3

BUILDER process, 9-10

CANCEL IMMEDIATE option

of managed recovery operations, 13-11

CANCEL NOWAIT option

of managed recovery operations, 13-11

CANCEL option

managed recovery and, 8-2

of managed recovery operations, 13-11

cancelling

log apply services, 8-5

managed recovery, 13-10

cascaded redo log destinations

defined, D-1

for logical standby databases, D-3

for physical standby databases, D-1, D-2

materialized view on logical standby databases, D-6

scenario, D-4 to D-8

changing

attributes for LOG_ARCHIVE_DEST_n initialization parameter, 12-2

logical standby database name, 4-19, 4-20

checklist

tasks for creating logical standby databases, 4-11

tasks for creating physical standby databases, 3-2

CJQ0 process, A-10

CLEAR UNARCHIVED LOGFILES clause

of ALTER DATABASE, 8-9, 8-17

closed backup operations

creating a logical standby database, 4-13

command-line interface

broker, 1-8

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 7-12, 7-14, 7-17, 7-19, 7-20, 10-19, 13-5, 13-16, E-4

in Real Application Clusters, C-10

troubleshooting, A-5, A-7, A-8, A-9

COMMIT TO SWITCHOVER TO PRIMARY clause

of ALTER DATABASE, 7-20

communication

between databases in a Data Guard configuration, 1-1

COMPATIBLE

initialization parameter, 11-7

configuration options

of online redo logs, 5-4

of standby environment, 5-26

physical standby databases

location and directory structure, 2-7

standby databases

cross-instance archival, 5-17, C-6

delayed standby, 5-6, 10-16

typical, 1-3

configurations

creating, 1-5

overview, 1-1

configuring

backup operations on standby databases, 1-3

cascaded redo log destinations, D-2

cascaded redo log destinations standby databases

logical, D-3

disaster recovery, 1-3

initialization parameters

for alternate archive destinations, A-4

for logical standby database, 4-15

for physical standby database, 3-5

in anticipation of a failover, 7-10

in anticipation of a switchover, 7-6

to create a standby database with a time lag, 10-16

to set up log transport services, 5-12

listener for logical standby databases, 4-17

listener for physical standby databases, 3-8

no data loss, 1-5

online redo logs, 5-4

physical standby databases, 2-7

reporting operations on a logical standby database, 1-3

standby databases, 5-26

standby databases at remote locations, 1-3

standby redo log groups, 5-8

standby redo logs, 5-9

constraints

handled on a logical standby database, 9-6

control file

creating for standby databases, 3-4

control files

altering, 8-15

copying, 3-5, 4-15

effect on physical standby databases, 8-15

switchover and, 7-12

CONTROL_FILE_RECORD_KEEP_TIME

initialization parameter, 5-5, 11-8

CONTROL_FILES

initialization parameter, 11-9

COORDINATOR process, 9-10

LSP background process, 4-26, 5-22, 9-10

copy a new tablespace to a remote standby database, 8-11

copying

control files, 3-5, 4-15

tablespace to a remote standby location, 8-11

CREATE CONTROLFILE clause

of ALTER DATABASE, 8-9, 8-16, 8-17

CREATE CONTROLFILE statement

effect on physical standby databases, 8-15

CREATE DATABASE statement

FORCE LOGGING clause, 10-21

CREATE DATAFILE AS clause

of ALTER DATABASE, 6-7

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 3-4, 13-6, A-3

CREATE TABLESPACE statement, 4-10

skipping, 9-7

CREATE TEMPORARY TABLESPACE statement, 8-6

TEMPFILE clause, 8-6

creating

back up files for the primary databases, 8-8

database link, 7-21, 7-26

indexes on logical standby databases, 9-4

logical standby databases, 4-1 to 4-23

from a closed backup, 4-11

roles required, 4-1

physical standby databases, 3-1 to 3-10

standby redo log groups, 5-9

standby redo log members, 5-9, 5-10

temporary files, 4-22

for read-only physical standby databases, 8-6

temporary tablespaces

for read-only physical standby databases, 8-6

traditional initialization parameter file

for logical standby database, 4-15

for physical standby database, 3-5

cross-instance archival, 5-17

in Real Application Clusters configurations, C-4

setting destinations, C-6

standby redo logs and, C-4

using the log writer process, C-5

V$ARCHIVE_DEST_STATUS view, 14-15

where the MRP operates, C-5

data availability

balancing against system performance requirements, 1-8

data corruption

safeguarding against, 1-7

Data Guard

protection modes

overview, 1-6

services

defined, 1-4

log transport services, 1-4

role management services, 1-5

Data Guard broker

defined, 1-5

Data Guard configuration

archiving to standby destination using the logwriter process, 5-23

archiving to standby destinations using the archive process, 5-22

defined, 1-1

for gap detection and resolution, 5-24

log transport services and, 5-2

scenarios, 10-1 to 10-24

Data Guard Manager, 1-8

data loss

due to failover, 1-5, 7-8

minimizing, 7-15

switchover and, 7-4

data protection

balancing against performance, 1-7

benefits, 1-7

flexibility, 1-7

provided by Data Guard, 1-1

data protection modes

affect on network timeouts, 12-34

enforced by log transport services, 1-4

ensuring no data loss, 2-3

influence on network reconnection, 12-34

maximum availability mode, 1-6, 13-14

maximum performance mode, 1-6, 13-14

maximum protection mode, 1-6, 13-14

overview, 1-6

providing no data loss, 5-3

setting up synchronous and asynchronous network I/O operations, 12-48

database link

creating, 7-21, 7-26

database roles

LOGSTDBY_ADMINISTRATOR, 4-1, 9-2, 9-9

primary, 1-2, 7-1

role management services, 1-5

role reversals, 1-5

SELECT_CATALOG_ROLE, 4-1, 9-2

standby, 1-2, 4-1, 7-1

transition, 7-1

database roles, irreversible transitions, 1-5

database schema

physical standby databases, 1-2

databases

cascading standby databases See cascaded redo log destinations

failover operations and, 7-8

logical standby See logical standby databases

physical standby See physical standby databases

primary See primary database

role transition and, 7-1

surviving disasters and data corruptions, 1-1

datafiles

adding to primary database, 6-6, 8-10

deleting from the primary database, 8-12

renaming on the primary database, 8-13

renaming standby manually, B-12

datatypes

filtering out unsupported from SQL apply operations, 9-7

on logical standby databases

supported, 4-3

unsupported, 4-4

DB_FILE_NAME_CONVERT

initialization parameter, 3-6, 11-10

DB_FILES

initialization parameter, 11-11

DB_NAME initialization parameter, 3-6, 11-12

DBA_DATA_FILES view, 8-17

DBA_LOGSTDBY_EVENTS view, 9-10, 14-4, A-11

DBA_LOGSTDBY_LOG view, 6-20, 14-5

listing archived redo logs, 10-12

DBA_LOGSTDBY_NOT_UNIQUE view, 4-7, 14-6

DBA_LOGSTDBY_PARAMETERS view, 14-7

DBA_LOGSTDBY_PROGRESS view, 6-21, 9-12, 14-8

log apply service and LSP progress, 6-10

querying SCN information and, 10-12

DBA_LOGSTDBY_SKIP view, 14-9

DBA_LOGSTDBY_SKIP_TRANSACTION view, 14-10

DBA_LOGSTDBY_UNSUPPORTED view, 4-4, 14-11

DBA_TABLESPACES view, 8-17

DBMS_LOGMNR_D package

SET_TABLESPACE procedure, 4-10

DBMS_LOGSTDBY package

APPLY_SET procedure, 9-3

APPLY_UNSET procedure, 9-3

BUILD procedure, 4-14, 9-3

GUARD_BYPASS_OFF procedure, 9-3

GUARD_BYPASS_ON procedure, 7-21, 7-26, 9-3

INSTANTIATE_TABLE procedure, 9-3, 9-9

SKIP procedure, 9-3, 9-7, A-11

SKIP_ERROR procedure, 9-3

SKIP_TRANSACTION procedure, 9-3, A-11

UNSKIP procedure, 9-3, 9-9

UNSKIP_ERROR procedure, 9-3

UNSKIP_TRANSACTION procedure, 9-3

using to manage SQL apply operations, 9-2

DBMS_LOGSTDBY.APPLY_SET procedure

delay applying archived redo log s, 5-6

DBMS_LOGSTDBY.GUARD_BYPASS_OFF procedure, 9-16

DBMS_LOGSTDBY.GUARD_BYPASS_ON procedure, 9-16

DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure, 9-9

DBMS_MVIEW.REFRESH routine

refreshing materialized views, 4-6, 9-16

DBNEWID (nid) utility, 4-19, 4-20

DBSNMP process, A-10

DDL transactions

filtering from SQL apply operations, 9-7

dead connection

troubleshooting, A-12, A-13

DEFAULT DELAY option

of managed recovery operations, 13-11

DEFER attribute

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-12, 10-20

DELAY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-6, 10-16, 12-16

DELAY option

of ALTER DATABASE RECOVER MANAGED STANDBY DATABASE, 5-6, 13-11

delaying

application of archived redo logs, 5-6, 9-12, 13-11

deleting

datafiles, 8-12

redo logs, 8-14

DEPENDENCY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-15, 12-19

dependent destinations, 5-15

destinations

archived redo logs, 5-12 to 5-19

cross-instance archival, 5-17, 14-15, C-4

dependent, 5-15

setting cross-instance archival operations, C-6

sharing among multiple standby databases, 5-15

detecting

missing archived redo logs, 1-5, 1-8, 6-10

network disconnects between primary and standby databases, 12-34

determining

the applied redo log data, 9-12

the highest applicable (newest) SCN, 10-11

direct path load operations

physical standby databases and, 8-16

directory structure

of physical standby databases, 2-7

disabling

a destination for archived redo logs, 5-12

apply delay interval, 7-25

archived redo log operations, 7-19

disaster recovery

benefits, 1-7

configuring, 1-3

provided by Data Guard, 1-1

provided by standby databases, 1-3

ReadMe file at standby site, 10-4

DISCONNECT FROM SESSION, 8-2

DISCONNECT option

of managed recovery operations, 13-11

DML transactions

filtering from SQL apply operations, 9-7

DROP STANDBY LOGFILE clause

of ALTER DATABASE, 6-7

DROP STANDBY LOGFILE MEMBER clause

of ALTER DATABASE, 6-7, 13-7

dropping

obsolete tempfiles, 4-21

online redo logs, 8-14

tablespaces from primary database, 8-12

temporary files, 4-22

dynamic parameters

AQ_TM_PROCESSES, A-10

JOB_QUEUE_PROCESSES, A-10

dynamic performance views, 8-18, 14-3

See also views

ENABLE attribute

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-12, 10-20

enabling

destinations for archived redo logs, 5-12

supplemental logging, 4-9

events

recording, 9-10

viewing on logical standby databases, 9-10

EXPIRE option

of managed recovery operations, 13-11

EXPIRE_TIME parameter

recommended values, 12-34

setting on the standby database, 12-33

failover, 1-5

data loss due to, 7-8

defined, 1-5, 7-8

determining the target logical standby database, 10-10

initialization parameters and, 7-10

logical standby databases and, 7-22, 10-1, 10-10

minimal data loss and, 10-13

minimal performance impact, 10-13

performing a, 7-15

physical standby databases and, 7-14, 10-1, 13-2

preparing for, 7-10

re-creating after, 7-15

scenario involving a time lag, 10-17

transferring redo data prior to, 7-10

with maximum performance mode, 7-10

with maximum protection mode, 7-10

failure resolution policies

log transport services, 5-16

FAL client, 5-20, 11-13

FAL server, 5-20, 11-13, 11-14

FAL_CLIENT initialization parameter, 6-13, 11-13

FAL_SERVER initialization parameter, 6-13, 11-14

false network failure detection, 12-34, 12-35

fetch archive log client

See FAL client

fetch archive log server

See FAL server, 5-20

FINISH option

of managed recovery operations, 13-11

fixed views

See views

FORCE LOGGING clause

of ALTER DATABASE, 2-6, 3-2, 4-2, 10-21, 13-8, 13-9

of ALTER TABLESPACE, 8-16

of CREATE DATABASE, 10-21

gap management, 6-10

automatic detection and resolution, 1-5, 1-8

defined, 6-11

detecting missing logs, 1-8

registering archived redo logs, 4-22, 6-13, 7-24

during failover, 7-23

See also archived redo logs

global dynamic performance views, 8-18, 14-3

See also views

GUARD clause

of ALTER DATABASE, 4-19, 7-21, 9-3

GUARD_BYPASS_OFF procedure

of DBMS_LOGSTDBY, 9-3

GUARD_BYPASS_ON procedure

of DBMS_LOGSTDBY, 7-21, 7-26, 9-3

GV$ fixed views, 8-18, 14-3

See also views

GV$INSTANCE view, C-10

high availability

benefits, 1-7

provided by Data Guard, 1-1

initialization parameter file

creating from server parameter

for logical standby database, 4-15

creating from server parameter file

for physical standby database, 3-5

modifying

for logical standby database, 4-15

for physical standby database, 3-5

setting up for log transport services, 5-26

setting up primary for logical standby database, 4-3

initialization parameters

ARCHIVE_LAG_TARGET, 11-6

COMPATIBLE, 11-7

CONTROL_FILE_RECORD_KEEP_TIME, 5-5, 11-8

CONTROL_FILES, 11-9

DB_FILE_NAME_CONVERT, 11-10

DB_FILES, 11-11

DB_NAME, 11-12

FAL_CLIENT, 6-13, 11-13

FAL_SERVER, 6-13, 11-14

LOCK_NAME_SPACE, 11-15, A-7

LOG_ARCHIVE_DEST, 5-13, 5-14, B-10

LOG_ARCHIVE_DEST_1, 5-13

LOG_ARCHIVE_DEST_n, 5-11, 11-16, 12-1 to 12-54, B-4

LOG_ARCHIVE_DEST_STATE_n, 5-12, 11-17, 12-2

LOG_ARCHIVE_FORMAT, 5-13, 11-18

LOG_ARCHIVE_MAX_PROCESSES, 11-19

LOG_ARCHIVE_MIN_SUCCEED_DEST, 11-20, 12-26

LOG_ARCHIVE_START, 11-21

LOG_ARCHIVE_TRACE, 5-33, 6-24, 6-25, 11-22

LOG_FILE_NAME_CONVERT, 11-23

LOG_PARALLELISM, 11-24

modifying for logical standby databases, 4-15

modifying for physical standby databases, 3-5

PARALLEL_MAX_SERVERS, 4-16, 9-19, 11-25

preparing for a failover, 7-10

preparing for switchover and, 7-6

REMOTE_ARCHIVE_ENABLE, 5-5, 11-26

SHARED_POOL_SIZE, 11-27

SORT_AREA_SIZE, 8-7, 11-28

STANDBY_ARCHIVE_DEST, 5-13, 11-29

STANDBY_FILE_MANAGEMENT, 6-6, 11-30

USER_DUMP_DEST, 6-24, 11-31

initiating

network I/O operations, 12-50

INSTANTIATE_TABLE procedure

of DBMS_LOGSTDBY, 9-3, 9-9

irreversible role transitions, 1-5

JOB_QUEUE_PROCESSES dynamic parameter, A-10

keepalive parameters

recommended values, 12-34

setting on the standby database, 12-33

LGWR attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-18, 12-14

LGWR process

See log writer process

listener.ora file

configuring, 3-8, 4-17

log transport services tuning and, A-12

troubleshooting, 10-20, A-2, A-12

listing

archived redo logs, 10-12

LOCATION attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-23, A-4

LOCK_NAME_SPACE initialization parameter, 11-15, A-7

log apply services, 6-1 to 6-10

canceling on physical standby databases, 13-10

defined, 1-4, 6-1

for logical standby databases, 1-4, 6-1, 9-2

for physical standby database, 6-1

initiating, 6-4

introduction, 1-4, 6-1

logical standby databases, 6-7

LSP process example, 5-22

RFS and LSP processes communication, 5-24, 6-8

viewing activity for logical standby databases, 9-10

viewing progress in DBA_LOGSTDBY_PROGRESS view, 6-10

viewing SQL apply operations, 9-10

log switching, 4-9

log transport services, 5-1 to 5-33

archive destinations

specifying quotas for, C-7

archived redo logs

confirming successful disk write, 5-19

specifying filenames and locations on the standby database, 5-13

defined, 1-4, 5-1

failure resolution policies, 5-16

generating archived redo log filenames, 5-13

interfaces to, 5-26

introduction to maximum availability mode, 1-6

introduction to maximum performance mode, 1-6

introduction to maximum protection mode, 1-6

monitoring, 5-31

network transmission modes, 5-18

ASYNC, 5-19

SYNC, 5-18

network tuning, A-11

permission for archiving online redo logs and, 5-5

providing no data loss, 5-18

re-archiving to failed destinations, 5-16

reception of redo data and, 5-2, 5-17

redo log destinations and, 5-11

setting up the primary database initialization parameters, 5-12

specifying alternate destinations for archiving, A-3

specifying storage locations for archived redo logs, 5-13

specifying storage locations for standby redo logs, 5-13

transmission of redo data and, 5-2, 5-17

log writer process, 5-19

acknowledging network timeouts, 12-33

detecting a network disconnect, 12-34

reconnecting after a network timeout, 12-34

re-connecting to the standby database, 12-34

setting up synchronous or asynchronous network I/O operation, 12-48

LOG_ARCHIVE_DEST_1 initialization parameter, 5-13

LOG_ARCHIVE_DEST_n initialization parameter, 5-11, 5-13, 11-16, 12-1 to 12-54, B-4

AFFIRM attribute, 5-19, 5-25, 12-2, 12-6, 12-54

ALTERNATE attribute, 12-9, A-3

ARCH attribute, 5-18, 12-14

ASYNC attribute, 5-19, 12-48

attribute compatibility, 12-54

changing attributes for with SQL, 12-2

DELAY attribute, 5-6, 10-16, 12-16

DEPENDENCY attribute, 5-15, 12-19

LGWR attribute, 5-18, 12-14

LOCATION attribute, 12-23, A-4

MANDATORY attribute, 12-26

MAX_FAILURE attribute, 12-29, 12-47

NET_TIMEOUT attribute, 12-32

NOAFFIRM attribute, 5-19, 12-6

NOALTERNATE attribute, 12-9, A-4

NODELAY attribute, 5-6, 12-16

NODEPENDENCY attribute, 12-19

NOMAX_FAILURE attribute, 12-29, 12-47

NONET_TIMEOUT attribute, 12-32

NOQUOTA_SIZE attribute, 12-36

NOQUOTA_USED attribute, 12-39

NOREGISTER attribute, 12-42

NOREOPEN attribute, 5-16, 12-46

NOTEMPLATE attribute, 12-51

OPTIONAL attribute, 12-26

QUOTA_SIZE attribute, 12-36, C-7

QUOTA_USED attribute, 12-39

REGISTER attribute, 12-42

REGISTER=location_format attribute, 12-44

REOPEN attribute, 5-16, 12-46

SERVICE attribute, 12-23

specifying destinations using, 12-2

SYNC attribute, 5-18, 5-19, 12-48

TEMPLATE attribute, 12-51

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-12, 11-17, 12-2

ALTERNATE attribute, 5-12

DEFER attribute, 5-12, 10-20

ENABLE attribute, 5-12, 10-20

LOG_ARCHIVE_FORMAT initialization parameter, 5-13, 5-14, 11-18

LOG_ARCHIVE_MAX_PROCESSES

initialization parameter, 11-19

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 11-20, 12-26

LOG_ARCHIVE_START initialization parameter, 11-21

LOG_ARCHIVE_TRACE initialization parameter, 5-33, 6-24, 6-25, 11-22

LOG_FILE_NAME_CONVERT initialization parameter, 11-23

LOG_PARALLELISM initialization parameter, 11-24

logical corruptions

resolving, 1-7

logical standby databases

access for queries and reporting purposes, 1-3

adding

datafiles, 9-14

indexes, 1-7, 2-4, 9-4

tables, 9-8, 9-9

applying redo logs, 6-7

DBMS_LOGSTDBY.APPLY_SET procedure, 5-6

delaying, 5-6, 9-12

ensuring redo logs are applied, 6-9

SQL apply technology, 1-5, 6-1

supported datatypes, 4-3

unsupported objects, 4-4

background processes, 4-26, 5-22, 9-10

benefits, 1-7, 2-4

cascading, D-1, D-3

controlling user access to database tables, 9-3

creating, 1-5, 4-1 to 4-23

checklist of tasks, 4-11

configuring a listener, 4-17

database roles required for, 4-1

from a closed backup, 4-13

modifying initialization parameters for, 4-16

traditional initialization parameter file, 4-15

DDL statements automatically skipped, 4-5

defined, 1-2

enabling

LOGSTDBY_ADMINSTRATOR role, 4-1

SELECT_CATALOG_ROLE role, 4-1

executing SQL statements on, 1-2

failover operations, 7-22, 10-1

scenario, 10-17

target of, 10-10

logical standby process (LSP) and, 4-26, 5-22, 5-24, 6-8, 9-10

managing, 9-1 to 9-19

manual recovery mode, B-4

materialized views

creating on, 1-7, 2-4, D-4, D-6

refreshing on, 4-6, 9-16

monitoring, 14-1

parallel execution processes, 9-19

read-only operations, 1-7

remote file server (RFS) and, 6-8

renaming datafiles and, B-12

role transitions, 7-19

scenarios

failover, 10-17

recovery, 10-21

skipping

SQL statements, 9-7

tables, 9-7

SQL apply technology, 1-5, 6-2

supported datatypes, 4-3

switchover operations, 7-19, 10-1

tables in the SYS and SYSTEM schemas, 4-10

tuning system performance, 9-17

uniquely identifying tables, 4-7

unsupported

datatypes, 4-4

sequences, 4-4

tables, 4-4

viewing events, 9-10

logical standby process (LSP), 6-8

communication with RFS process, 5-24, 6-8

COORDINATOR process, 4-26, 5-22, 9-10

information in DBA_LOGSTDBY_PROGRESS view, 6-10

LOGSTDBY_ADMINISTRATOR role

enabling, 4-1

required for DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure, 9-9

managed recovery operations, 2-2

cancelling, 13-10

definition, 2-2

in foreground session, 6-4

managed recovery process (MRP) and, 6-2

modifying, 13-10

monitoring, 6-5

options

CANCEL, 13-11

CANCEL IMMEDIATE, 13-11

CANCEL NOWAIT, 13-11

DEFAULT DELAY, 13-11

DELAY, 13-11

DISCONNECT, 13-11

EXPIRE, 13-11

FINISH, 13-11

NEXT, 13-11

NO EXPIRE, 13-12

NO TIMEOUT, 13-12

NODELAY, 10-18, 13-11

NOPARALLEL, 13-12

PARALLEL, 6-16, 13-12

THROUGH ALL ARCHIVELOG, 13-13

THROUGH...SEQUENCE, 13-12

THROUGH...SWITCHOVER, 13-13

TIMEOUT, 13-13

starting, 3-9, 6-4, 13-10

managed recovery process (MRP), 5-22

cross-instance archival, C-5

See also managed recovery operations

managing

with the broker, 1-5

MANDATORY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-14, 12-26

manual recovery mode

initiating, B-3

preparing for, B-1

when is it required, B-5

materialized views

creating on logical standby databases, 1-7, 2-4, D-6

on cascaded redo log destinations, D-4

refreshing on logical standby databases, 4-6, 9-16

MAX_FAILURE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-29, 12-47

maximum availability mode

for Real Application Clusters, C-8

influence on network reconnection, 12-34

introduction, 1-6

providing no data loss, 5-3

maximum performance mode, 7-10

for Real Application Clusters, C-9

influence on network reconnection, 12-34

introduction, 1-6

maximum protection mode

for Real Application Clusters, C-8

influence on network reconnection, 12-34

introduction, 1-6

providing no data loss, 5-3

standby databases and, 7-10

missing log sequence

See also gap management

detecting, 1-8

modifying

a logical standby database, 9-4

initialization parameters for logical standby databases, 4-16

initialization parameters for physical standby databases, 3-5

managed recovery operations, 13-10

monitoring

log apply services, 6-5

log transport services, 5-31

standby databases, 8-8

MOUNT STANDBY DATABASE clause

of ALTER DATABASE, 3-9, 6-3, 7-12, 8-2, 8-5, 8-14, 10-19, 13-9, B-4

MRP

See managed recovery operations

multiple standby databases

specifying dependent destinations and, 5-16

NET_TIMEOUT attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-32

network I/O operations

acknowledging, 12-33

coordinating timeout parameter values, 12-34

detecting a disconnect, 12-34

false failures, 12-34, 12-35

influence of data protection modes, 12-34

initiating, 12-50

network timers

EXPIRE_TIME parameter, 12-33

NET_TIMEOUT attribute, 12-32

setting comparably on primary and standby databases, 12-34

TCP/IP keepalive parameter, 12-34

setting up synchronous or asynchronous, 12-48

transmission method, 5-19

troubleshooting, A-12

tuning

log transport services, A-11

NEWEST_SCN column

of DBA_LOGSTDBY_PROGRESS view, 10-12

NEXT option

of managed recovery operations, 13-11

no data loss

benefits, 1-7

data protection modes overview, 1-6

ensuring, 1-5, 2-3

environments, 5-18

guaranteeing, 1-5

provided by maximum availability mode, 1-6, 5-3

provided by maximum protection mode, 1-6, 5-3

requires synchronous network transmission method, 5-19

NO EXPIRE option

of managed recovery operations, 13-12

NO TIMEOUT option

of managed recovery operations, 13-12

NOAFFIRM attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-6

NOALTERNATE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-9, A-4

NODELAY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-6, 12-16

NODELAY option

of managed recovery operations, 10-18, 13-11

NODEPENDENCY attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-19

NOFORCE LOGGING clause

of ALTER DATABASE, 13-8, 13-9

NOMAX_FAILURE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-29, 12-47

NONET_TIMEOUT attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-32

NOPARALLEL option

of managed recovery operations, 13-12

NOQUOTA_SIZE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-36

NOQUOTA_USED attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-39

NOREGISTER attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-42

NOREOPEN attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-16, 12-46

NOTEMPLATE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-51

on-disk database structures

physical standby databases, 1-2

online redo logs

adding, 8-14

ALTER DATABASE statement and, 7-13

configuration considerations for, 5-4

dropping, 8-14

manually adding to physical standby database, 7-13

OPEN READ ONLY clause

of ALTER DATABASE, 8-5, 13-9

OPEN RESETLOGS clause

of ALTER DATABASE, 4-19, 4-21, 8-17

operational requirements, 2-5

OPTIONAL attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-14, 12-26

Oracle Net

communication between databases in a Data Guard configuration, 1-1

recommended parameter settings, 12-34

setting the EXPIRE_TIME parameter, 12-33

Oracle Net Manager

configuring the listener, 6-14

creating a network service name, 6-14

parallel execution processes

adjusting for logical standby databases, 9-19

PARALLEL option

of managed recovery operations, 6-16, 13-12

parallel recovery

on physical standby databases, 6-16

PARALLEL_MAX_SERVERS

initialization parameter, 4-16, 9-19, 11-25

partial archived redo logs

registering, 7-24, 10-15

performance

balancing against data availability, 1-8

balancing against data protection, 1-7

permission

log transport services and, 5-5

physical standby databases

altering

control files, 8-15

redo log files, 8-14

applying redo logs, 6-1

archiver (ARCn) process and, 6-2

cascading, D-1

delaying, 5-6, 13-11

redo apply technology, 1-4

starting, 6-4

background processes, 5-22

benefits, 2-2

configuration options, 2-7

delayed standby, 5-6

creating, 1-5, 3-1 to 3-10

checklist of tasks, 3-2

configuring a listener, 3-8

directory structure, 2-7, 2-9

initialization parameters for, 3-5

temporary tablespace, 8-6

traditional initialization parameter file, 3-5

defined, 1-2

direct path load operations, 8-16

failover, 10-1

checking for updates, 7-11

preparing for, 7-10

managed recovery operations, 2-2

cancelling, 13-10

modifying, 13-10

starting, 13-10

managed recovery process (MRP) and, 5-22, 6-2

manual recovery mode

procedures, B-4

renaming datafiles, B-12

monitoring, 6-5, 8-8, 14-1

online backup operations and, 2-3

read-only operations, 2-2, 8-3

remote file server (RFS) and, 6-2

reverting back to primary database, A-6

role transition and, 7-11

starting

database instance, 6-3

log apply services, 6-4

managed recovery operations, 13-10

support for DDL, 2-3

support for DML, 2-3

switchover, 7-11, 10-1

adding online redo logs prior to, 7-13

preparing for, 7-6

PREPARER process, 9-10

primary database

backup operations and, 4-13, 7-18, 8-8

configuring

for cross-instance archival operations, C-5

on Real Application Clusters, 1-2

single-instance, 1-2

datafiles

adding, 6-6, 8-10

renaming, 8-12

defined, 1-2

failover and, 7-8

gap resolution, 1-8

gathering redo log archival information, 5-31

initialization parameters

and logical standby database, 4-3

and physical standby database, 3-5

log transport services on, 1-4

network connections

avoiding network hangs, 12-32

detecting disconnections, 12-34

handling network timeouts, 12-33

influence of data protection modes on network reconnection, 12-34

terminating, 12-33

preparing for logical standby database creation, 4-1

preparing for physical standby database creation, 3-1

Real Application Clusters and

setting up, C-2, C-5

reducing workload on, 1-7

setting archive tracing, 5-33

switchover, 7-4

initiating, 7-12

tablespaces

adding, 8-10

dropping, 8-12

primary role, 1-2

processes

archiver (ARCn), 5-19

CJQ0, A-10

DBSNMP, A-10

log writer (LGWR), 5-19

QMN0, A-10

See also logical standby process (LSP)

See also managed recovery process (MRP)

production database

See primary database

protection modes

See data protection modes

QMN0 process, A-10

queries

improved performance, 1-7

offloading on the standby database, 1-7

QUOTA_SIZE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-36, C-7

QUOTA_USED attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-39

READER process, 9-10

read-only operations, 1-4

definition, 2-2

logical standby databases, 1-7

physical standby databases and, 8-3

Real Application Clusters, 5-17, C-3

cross-instance archival, C-4

instance recovery, C-6

performing switchover and, 7-7, 7-10, C-9

primary databases and, 1-2, C-2, C-5

setting

cross-instance archiving, C-6

maximum data availability, C-8

maximum data performance mode, C-9

maximum data protection, C-8

skipping standby logfiles, C-9

standby databases and, 1-2, C-1, C-5

standby redo logs and, 5-8, C-4

reception

of redo data, 5-2

reconnecting

network connection

when in maximum availability mode, 12-34

when in maximum performance mode, 12-34

when in maximum protection mode, 12-34

recording logical standby database events, 9-10

RECOVER MANAGED STANDBY DATABASE clause

of ALTER DATABASE, 3-9, 5-6, 6-4, 7-14, 8-5, 8-7, 10-9, 10-17, 13-2, 13-9, 13-11, B-12, C-9

background process, 6-4, 8-2, 13-10

CANCEL IMMEDIATE option, 13-11

CANCEL NOWAIT option, 13-11

CANCEL option, 13-11

cancelling, 6-5

cancelling log apply services, 8-5

controlling redo apply operations, 6-5

DEFAULT DELAY option, 13-11

DELAY option, 13-11

DISCONNECT option, 13-11

EXPIRE option, 13-11

FINISH option, 13-11

foreground session, 6-4, 13-10

gap resolution, 6-15

initiating failover, 7-17

NEXT option, 13-11

NO EXPIRE option, 13-12

NO TIMEOUT option, 13-12

NODELAY option, 13-11

NOPARALLEL option, 13-12

overriding the delay interval, 12-17

PARALLEL option, 13-12

skipping standby logfiles, 7-17, 13-2, C-9

switchover scenario, 10-18

syntax, 13-10

THROUGH ALL ARCHIVELOG option, 13-13

THROUGH...SEQUENCE option, 13-12

THROUGH...SWITCHOVER option, 13-13

TIMEOUT option, 13-13

recovering

after a NOLOGGING clause is specified, 10-21

from errors, 9-13

re-creating

a table on a logical standby database, 9-8

redo apply technology, 1-4

redo data

applying

through redo apply technology, 1-4

through SQL apply technology, 1-5

archived on the standby system, 1-4, 6-1

transmitting, 1-2, 1-4

validated, 1-7

redo logs

adding, 8-14

applying to standby database, 1-2, 6-1 to 6-27

archive gap managing, 6-11

deleting, 8-14

logging supplemental information, 4-8, 4-9

receiving and storing on standby databases See log transport services

setting permission to archive, 5-5

transmitting See log transport services

update standby database tables, 1-7

when applied to logical standby database, 6-9

refreshing materialized views, 9-16

REGISTER attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-42

REGISTER LOGFILE clause

of ALTER DATABASE, 7-18, 12-43, 13-13, A-6

REGISTER LOGICAL LOGFILE clause, 10-15

of ALTER DATABASE, 4-22, 6-13, 7-23, 7-24, 10-14

REGISTER=location_format attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-44

registering

archived redo logs, 4-22, 6-13, 7-24, 10-14

during failover, 7-23

partial archived redo logs, 10-15

RELY constraint

creating, 4-8

remote file server process (RFS)

communicating with LSP process, 5-24, 6-8

defined, 5-7, 5-20

log writer process and, 5-18, 5-23

sample configuration, 5-22

standby redo logs reused by, 5-8

trace file, 5-8

REMOTE_ARCHIVE_ENABLE initialization parameter, 5-5, 11-26

RENAME FILE clause

of ALTER DATABASE, 4-18, 6-7, B-12, B-13

renaming

datafiles

manually, B-12

on the primary database, 8-13

on the standby database, B-12

REOPEN attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-16, 12-46

reporting operations

configuring, 1-3

offloading on the standby database, 1-7

performing on a logical standby database, 1-3

resolving

logical corruptions, 1-7

retrieving

missing archived redo logs, 1-5, 1-8, 6-10, 10-14

RFS

See remote file server process (RFS)

role management, 1-5, 7-1

role transitions, 7-1

choosing a type of, 7-2

logical standby database and, 7-19

physical standby databases and, 7-11

reversals, 1-5, 7-1

roles

LOGSTDBY_ADMINSTRATOR, 4-1

SELECT_CATALOG_ROLE, 4-1

rolling upgrade

during switchover, 7-8

scenarios

cascaded redo log destinations, D-4 to D-8

choosing best standby database for role transition, 10-1

failing over with a time lag, 10-17

recovering

a logical standby database, 10-21

after NOLOGGING is specified, 10-21

from a network failure, 10-20

time lag in redo logs, 10-16

schemas

data manipulation on logical standby databases, 1-7

identical to primary database, 1-2

SCN

determine the highest applicable (newest), 10-11

SELECT_CATALOG_ROLE role

enabling, 4-1

sequences

unsupported on logical standby databases, 4-4

server parameter file

modifying

for logical standby database, 4-15

for physical standby database, 3-5

setting up

for log transport services, 5-26

primary for logical standby databases, 4-3

SERVICE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-23

SET LOG_ARCHIVE_DEST_STATE_n clause

of ALTER SYSTEM, 7-19, 7-20, 7-27

SET LOG_ARCHIVE_TRACE clause

of ALTER SYSTEM, 6-25

SET LOG_PARALLELISM clause

of ALTER SYSTEM, 4-3

SET STANDBY DATABASE clause

of ALTER DATABASE, 5-26, 7-10, 13-14

SET_TABLESPACE procedure

of DBMS_LOGMNR_D, 4-10

setting

network timers on primary and standby databases, 12-34

Oracle Net EXPIRE_TIME network timers, 12-34

TCP/IP network timers, 12-34

SHARED_POOL_SIZE

initialization parameter, 11-27

SKIP procedure

of DBMS_LOGSTDBY, 9-3, 9-7, A-11

SKIP_ERROR procedure

of DBMS_LOGSTDBY, 9-3

SKIP_TRANSACTION procedure

of DBMS_LOGSTDBY, 9-3, A-11

skipping

ALTER TABLESPACE, 9-7

standby logfiles, 10-17, 13-2, C-9

SORT_AREA_SIZE initialization parameter, 8-7, 11-28

SQL apply operations, 1-5

ANALYZER process, 9-10

APPLIER process, 9-10

applying redo data to logical standby databases, 9-2

BUILDER process, 9-10

COORDINATOR process, 9-10

DBMS_LOGSTDBY PL/SQL package and, 9-2

definition, 6-2

PREPARER process, 9-10

READER process, 9-10

uniquely identifying table rows, 4-7

viewing activity with V$LOGSTDBY view, 9-10

SQL statements, 13-1

executing on logical standby databases, 1-2, 1-5

skipping on logical standby databases, 4-5, 9-7

switchover and, 7-12

standby databases

applying redo logs on, 1-4, 1-7, 6-1

cascading, D-1

configuring, 1-1

a single log file destination, 5-15

cross-instance archival, 5-17, 14-15, C-4, C-6

delayed standby, 10-16

mandatory destinations, 5-14

maximum number of, 2-1

network connections, 12-33

on Real Application Clusters, 1-2, C-1, C-5

on remote locations, 1-3

optional destinations, 5-14

single-instance, 1-2

creating, 1-2, 3-1, 4-1

with a time lag, 5-6, 10-17

defined, 2-1

failover to, 7-8

re-creating after, 7-15

log apply services on, 6-1

operational requirements, 2-5

renaming datafiles and, B-12

resynchronizing with the primary database, 1-8

setting TCP/IP keepalive parameters, 12-33

skipping logfiles, 10-17

See also logical standby databases

See also physical standby databases

standby redo logs

creating, 5-9

log groups and members, 5-8, 5-9

redo log members, 5-10

cross-instance archival and, C-4

Real Application Clusters and, 5-8, C-4

specifying storage locations for, 5-13

standby role, 1-2

STANDBY_ARCHIVE_DEST initialization parameter, 5-13, 11-29

STANDBY_FILE_MANAGEMENT initialization parameter, 6-6, 11-30

START LOGICAL STANDBY APPLY clause

of ALTER DATABASE, 4-23, 6-9, 7-27, 13-15, A-11

starting

managed recovery, 13-10

physical standby instances, 6-3

STOP LOGICAL STANDBY APPLY clause

of ALTER DATABASE, 6-9, 7-26, 10-14, 13-16

stopping

managed recovery operations, 13-10

superceding

apply delay interval, 5-6

supplemental logging

adding data to redo logs, 4-8, 4-9

creating a unique key, 4-7

enabling, 13-4

log switching and, 4-9

on primary database, 4-8

SUPPLEMENTAL_LOG_DATA_PK column

of V$DATABASE, 4-9

SUPPLEMENTAL_LOG_DATA_UI column

of V$DATABASE, 4-9

switchover, 1-5, 7-4

control files and, 7-12

defined, 1-5

initialization parameters and, 7-6

initiating on the primary database, 7-12

logical standby databases and, 7-19, 10-1

no data loss and, 7-4

performing a rolling upgrade and, 7-8

physical standby databases and, 7-7, 7-11, 7-13, 10-1

preparing for, 7-6

processes that prevent, A-10

CJQ0, A-10

DBSNMP, A-10

QMN0, A-10

redo logs and, 7-13

rolling upgrade and, 7-8

SQL statements and, 7-12

standby databases not involved in, 7-14

typical use for, 7-4

using Real Application Clusters and, 7-7, 7-10, C-9

V$DATABASE view and, 7-11, 7-13

verifying, 7-13

SWITCHOVER_STATUS column

of V$DATABASE view, 7-12, 7-13, A-6

SYNC attribute

LOG_ARCHIVE_DEST_n initialization parameter, 5-18, 5-19, 12-48

required for no data loss environments, 5-19

SYS schema

tables used by logical standby databases, 4-10

system resources

efficient utilization of, 1-7

SYSTEM schema

tables used by logical standby databases, 4-10

tables

logical standby databases

adding on, 9-8

identifying rows in, 4-7

re-creating tables on, 9-8

skipping on, 9-7

unsupported on, 4-4

tablespaces

adding

a new datafile, 9-15

to primary database, 8-10

creating and associating temporary files, 8-6

dropping from primary database, 8-12

managing, 4-10

sorting without, 8-7

TCP/IP network interconnect

expired network timers, 12-33

recommended parameter settings, 12-34

setting the keepalive parameter, 12-33

TEMPFILE clause

of ALTER DATABASE, 4-22

of ALTER TABLESPACE, 4-22

of CREATE TEMPORARY TABLESPACE, 8-6

TEMPLATE attribute

LOG_ARCHIVE_DEST_n initialization parameter, 12-51

tempfiles

See temporary files

temporary files

adding, 4-22, 8-6

creating, 4-22, 8-7

dropping, 4-22

dropping obsolete, 4-21

temporary tablespaces

adding tempfile entries, 8-6

creating, 8-6

terminating

network connection, 12-32

THROUGH ALL ARCHIVELOG option

of managed recovery operations, 13-13

THROUGH...SEQUENCE option

of managed recovery operations, 13-12

THROUGH...SWITCHOVER option

of managed recovery operations, 13-13

time lag

in standby database, 5-6, 10-17, 12-16

TIMEOUT option

of managed recovery operations, 13-13

tnsnames.ora file

log transport services tuning and, A-12

troubleshooting, 10-20, A-2, A-8, A-12

trace files

levels of tracing data, 6-25

location of, 6-24

RFS process, 5-8

setting, 6-24

transactionally consistent read-only access, 1-4

triggers

handled on a logical standby database, 9-6

troubleshooting

apply operations, A-10

dead network connections, A-12, A-13

listener.ora file, 10-20, A-2, A-12

tnsnames.ora file, 10-20, A-2, A-8, A-12

tuning

logical standby databases, 9-17

unrecoverable operations, 10-22

backing up after, 10-24

UNSKIP procedure

of DBMS_LOGSTDBY, 9-3, 9-9

UNSKIP_ERROR procedure

of DBMS_LOGSTDBY, 9-3

UNSKIP_TRANSACTION procedure

of DBMS_LOGSTDBY, 9-3

user errors

safeguarding against, 1-7

USER_DUMP_DEST initialization parameter, 6-24, 11-31

V$ARCHIVE_DEST view, 5-32, 10-20, 14-12, A-2

V$ARCHIVE_DEST_STATUS view, 5-32, 6-5, 6-16, 14-15

cross-instance archival column, 14-15

V$ARCHIVE_GAP view, 14-17

V$ARCHIVED_LOG view, 5-13, 5-32, 6-16, 14-18, A-6, B-8

determining the most recently archived redo log, 5-32

V$DATABASE view, 14-20

SUPPLEMENTAL_LOG_DATA_PK column, 4-9

SUPPLEMENTAL_LOG_DATA_UI column, 4-9

switchover and, 7-11, 7-13

SWITCHOVER_STATUS column and, 7-12, 7-13, A-6

V$DATAFILE view, 3-3, 4-12, 10-22, 10-24, 14-24

V$DATAGUARD_STATUS view, 6-17, 14-26

V$LOG view, 5-31, 14-28

V$LOG_HISTORY view, 6-17, 8-21, 14-30

V$LOGFILE view, 14-29

V$LOGSTDBY view, 6-9, 9-10, 14-31

viewing SQL apply operations, 9-10

V$LOGSTDBY_STATS view, 9-11, 14-32

V$MANAGED_STANDBY view, 6-5, 6-15, 14-33

V$PX_SESSION view, 14-31

V$RECOVER_FILE view, 8-17

V$SESSION view, 14-31, A-5, A-9

V$STANDBY_LOG view, 14-35

V$TEMPFILE view, 4-21

temporary files

querying, 4-22

V$THREAD view, 8-16

validating

redo data, 1-7

views, 8-18, 14-1

DBA_LOGSTDBY_EVENTS, 9-10, 14-4, A-11

DBA_LOGSTDBY_LOG, 6-20, 10-12, 14-5

DBA_LOGSTDBY_NOT_UNIQUE, 4-7, 14-6

DBA_LOGSTDBY_PARAMETERS, 14-7

DBA_LOGSTDBY_PROGRESS, 6-10, 6-21, 9-12, 14-8

DBA_LOGSTDBY_SKIP, 14-9

DBA_LOGSTDBY_SKIP_TRANSACTION, 14-10

DBA_LOGSTDBY_UNSUPPORTED, 4-4, 14-11

DBA_TABLESPACES, 8-17

GV$INSTANCE, C-10

V$ARCHIVE_DEST, 5-32, 10-20, 14-12, A-2

V$ARCHIVE_DEST_STATUS, 5-32, 6-5, 6-16, 14-15

V$ARCHIVE_GAP, 14-17

V$ARCHIVED_LOG, 5-13, 5-32, 6-16, 14-18, B-8

V$DATABASE, 14-20

V$DATAFILE, 3-3, 4-12, 10-22, 10-24, 14-24

V$DATAGUARD_STATUS, 6-17, 14-26

V$LOG, 5-31, 14-28

V$LOG_HISTORY, 6-17, 8-21, 14-30

V$LOGFILE, 14-29

V$LOGSTDBY, 6-9, 9-10, 14-31

V$LOGSTDBY_STATS, 9-11, 14-32

V$MANAGED_STANDBY, 6-5, 6-15, 14-33

V$PX_SESSION, 14-31

V$RECOVER_FILE, 8-17

V$SESSION, 14-31, A-5, A-9

V$STANDBY_LOG, 14-35

V$TEMPFILE, 4-21

V$THREAD, 8-16