Oracle9i Data Guard Concepts and Administration -- Index

ABORT LOGICAL STANDBY clause

of ALTER DATABASE, 13-16

ACTIVATE LOGICAL STANDBY DATABASE clause

of ALTER DATABASE, 7-27

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, 7-31, 7-35, 13-1

ADD LOGFILE clause

of ALTER DATABASE, 5-52, 6-22

ADD LOGFILE GROUP clause

of ALTER DATABASE, 5-52, 13-2

ADD LOGFILE MEMBER clause

of ALTER DATABASE, 5-53, 6-22

ADD STANDBY LOGFILE clause

of ALTER DATABASE, 5-50

ADD STANDBY LOGFILE MEMBER clause

of ALTER DATABASE, 13-3

ADD STANDBY LOGFILE THREAD clause

of ALTER DATABASE, 13-2

ADD SUPPLEMENTAL LOG DATA clause

of ALTER DATABASE, 13-4

adding

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

online redo logs, 8-10, 10-20

standby redo logs, 5-52

tablespaces, 8-9

AFFIRM option

LOG_ARCHIVE_DEST_n initialization parameter, 5-47, 5-56, 12-3

ALTER DATABASE statement, 13-1

ABORT LOGICAL STANDBY clause, 13-16

ACTIVATE LOGICAL STANDBY DATABASE clause, 7-27

ACTIVATE STANDBY DATABASE clause, 7-31, 13-1

SKIP STANDBY LOGFILE clause, 7-35

ADD LOGFILE clause, 5-52, 6-22

GROUP keyword, 5-52

MEMBER keyword, 5-53, 6-22

ADD STANDBY LOGFILE clause

GROUP keyword, 5-52, 13-2

MEMBER keyword, 5-53, 6-22

REUSE keyword, 13-3

THREAD keyword, 13-2

ADD SUPPLEMENTAL LOG DATA clause, 13-4

CLEAR LOGFILE GROUP clause, 8-14

CLEAR UNARCHIVED LOGFILE clause, 8-11, 10-20

COMMIT TO SWITCHOVER clause, 7-10, 7-14, 13-5

COMMIT TO SWITCHOVER TO LOGICAL PRIMARY clause, 7-14

CREATE STANDBY CONTROLFILE clause, 3-7, 8-14, 10-11

REUSE clause, 13-6

DROP STANDBY LOGFILE clause, 13-7

DROP STANDBY LOGFILE MEMBER clause, 13-7

FORCE LOGGING clause, 13-8

GUARD clause, 9-2

ALL keyword, 4-14, 9-2

NONE keyword, 9-2

STANDBY keyword, 9-2

MOUNT STANDBY DATABASE clause, 8-14, 13-9, B-4

NOFORCE LOGGING clause, 13-8

OPEN READ ONLY clause, 6-24, 13-9

OPEN RESETLOGS clause, 10-20

RECOVER AUTOMATIC clause, 4-14

RECOVER MANAGED STANDBY DATABASE clause, 6-11 to 6-20, 7-11, 7-24, 10-9, 13-10

REGISTER LOGFILE clause, 7-16, 13-13

REGISTER LOGICAL LOGFILE clause, 4-16, 7-26, 7-33

RENAME FILE clause, 6-22, B-14

RESETLOGS clause, B-8

restrictions, 6-22

SET STANDBY DATABASE clause

TO MAXIMIZE AVAILABILITY clause, 13-14

TO MAXIMIZE PERFORMANCE clause, 13-14

TO MAXIMIZE PROTECTION clause, 5-55, 13-14

START LOGICAL STANDBY APPLY clause, 7-26, 7-33, 13-15, A-8

INITIAL keyword, 4-16

NEW PRIMARY clause, 7-15, 7-27

STOP LOGICAL STANDBY APPLY clause, 7-26, 7-27, 7-33, 13-16

TEMPFILE clause, 4-16

ALTER SESSION statement

modifying initialization parameters with, 5-14

ALTER SYSTEM statement

ARCHIVE LOG CURRENT clause, 4-18, 10-32

modifying initialization parameters with, 5-14

QUIESCE clause, 4-12

SET LOG_ARCHIVE_DEST_STATE_n clause, 7-14, 7-15

SET LOG_ARCHIVE_TRACE clause, 6-34

SET RESOURCE_MANAGER_PLAN=SYSTEM_PLAN clause, 4-7

SWITCH LOGFILE clause, 4-12

UNQUIESCE clause, 4-12

altering

control files, 8-11

ALTERNATE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-26, 12-6

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-11

APPLIED_SCN column

of DBA_LOGSTDBY_PROGRESS, 10-52

APPLY_SET procedure

of DBMS_LOGSTDBY, 6-4, 9-9

APPLY_UNSET procedure

of DBMS_LOGSTDBY, 6-4

applying

redo logs

on standby database, 2-5

SQL statements to logical standby databases, 6-2

AQ_TM_PROCESSES dynamic parameter, A-7

ARCH option

LOG_ARCHIVE_DEST_n initialization parameter, 5-43, 12-11

archive destinations, 5-2, 10-23

alternate, 5-26

MANDATORY, 10-23

multiple, 10-5

OPTIONAL, 10-24

archive gaps

applying the logs to standby database, B-12

causes of, B-5

copying the logs in, B-10

definition, 6-37

identifying the logs, 6-38, B-9

management of, 6-37

preventing, B-8

resolving using Oracle Net Manager, 6-38

resolving using the Oracle Net Manager, 6-38

ARCHIVE LOG CURRENT clause

of ALTER SYSTEM, 4-18, 10-32

ARCHIVE LOG LIST command, 3-6, 4-5, 10-4, 10-11

archive tracing

standby databases and, 5-60, 6-33

ARCHIVE_LAG_TARGET initialization parameter, 11-2

archived redo logs

accessing information about, 6-30, 8-7

copying manually, 2-4

definition, 5-1

delayed application

on the logical standby database, 6-5

on the standby database, 5-29

destinations, 5-4, 5-22 to 5-30

disabling, 7-32

displayed in DBA_LOGSTDBY_LOG view, 10-51

filtering data, 10-47

gap management, 6-37

gaps in sequence numbers, 10-51

introduction, 5-1

listing, 10-51

multiple destinations and, 10-5

recovering missing, 10-52

registering recovered, 10-53

specifying the location of with the TEMPLATE option, 5-28

specifying the location on the standby database, 5-53

standby databases and, 6-28

switchover indicator, 6-18

transmitting, 6-7

ARCHIVELOG mode

checking for, 3-6, 4-5, 10-4, 10-11

log transport services, 5-18

switching from primary role to standby, 7-6

archiver process, 5-3

definition, 5-3

archiving

definition, 5-18

redo logs

automatically, 5-1, 5-21

manually, 2-4

specifying failure resolution policies for, 5-25

specifying network transmission modes for, 5-44

starting, 4-18

to failed destinations, 5-25

to standby databases, 2-3

ARCn process, 5-3

ASYNC option

LOG_ARCHIVE_DEST_n initialization parameter, 5-45, 5-56, 12-43

asynchronous network I/O

log writer process and, C-1

network server processes and, C-2

availability modes

configuring, 5-43

background mode recovery, 6-12

backing up

after unrecoverable operations, 8-13

primary database datafiles, 10-10

primary databases, 3-5

primary databases from standby databases, 8-1, 10-38

standby databases, 10-38

BAD_COLUMN column

of DBA_LOGSTDBY_NOT_UNIQUE, 4-4

broker

definition, 1-4

introduction, 1-4

BUILD procedure

of DBMS_LOGSTDBY, 6-4

CANCEL IMMEDIATE option

of managed recovery mode, 13-11

CANCEL NOWAIT option

of managed recovery mode, 6-11, 13-11

CANCEL option

of managed recovery mode, 6-11, 8-14, 13-11

cascading standby databases, 2-1, E-1

configuring, E-3

for switchover, E-2

the initialization parameter file, E-2

definition, E-1

failing over to, E-3

logical, E-4

physical, E-3

scenario, E-5 to E-9

changing

logical standby database name, 4-14

checklist

tasks for creating logical standby databases, 4-8

tasks for creating physical standby databases, 3-1

child destination

definition, 5-27

CJQ0 process, A-7

CLEAR LOGFILE clause

of ALTER DATABASE, 8-14

CLEAR LOGFILE GROUP clause

of ALTER DATABASE, 8-14

CLEAR UNARCHIVED LOGFILE clause

of ALTER DATABASE, 8-11, 10-20

clearing

online logs

implication for standby databases, 8-14

cold backup operations

creating a logical standby database, 4-10

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 7-10, 13-5

COMMIT TO SWITCHOVER TO LOGICAL PRIMARY clause

of ALTER DATABASE, 7-14

COMPATIBLE initialization parameter, 10-7, 11-2

configuration options

of online redo logs, 5-18

of standby environment, 2-1, 5-31

standby databases

cross-instance archival, 1-10, 2-9

delayed standby, 5-29, 10-36

location, 2-6

configuring

an Oracle Net connection, 10-4

cascading standby databases, E-3

logical, E-4

physical, E-3

initialization parameter file, 10-5, 10-12, 10-15

for cascading standby databases, E-2

listener for logical standby databases, 4-17

log transport services data availability modes, 5-43

network files, 10-4

online redo logs, 5-18

standby databases, 2-6, 5-31

standby redo log groups, 5-51

standby redo logs, 5-50, 5-52

switchover, 10-28, E-2

control files

altering, 8-11

backing up, 4-12

copying, 3-8

creating, 3-6, 10-11

effect on standby databases, 8-11

refreshing standby database, 8-13

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 5-20, 11-2

CONTROL_FILES initialization parameter, 10-2, 10-7, 11-2

CREATE CONTROLFILE statement

effect on standby databases, 8-11

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 3-7, 8-14, 10-11, 13-6

CREATE TABLESPACE statement, 4-8

CREATE TEMPORARY TABLESPACE statement, 6-26

creating

a table on a logical standby database from an existing table definition, 10-48

control files, 10-11

database link, 4-18, 4-19

logical standby databases, 4-1

from a cold backup, 4-8

standby database files, 3-3

standby databases, 3-3, 3-5, B-13

standby initialization parameter files, 5-32

standby redo log groups, 5-52

standby redo log members, 5-52, 5-53

tempfiles, 4-16

temporary tablespaces

for read-only physical standby databases, 6-26

cross-instance archival, 8-16, D-2

standby redo logs and, D-2

data availability modes

configuring, 5-43

Data Guard configuration

cascading standby databases and, E-1

failover, 1-5

log transport services and, 5-4

data loss

intentional, 7-19, 7-35

minimizing, 7-20

on the standby database, 1-12

preventing, 7-19

See also no-data-loss failover

unavoidable, 7-27

database guard

STANDBY keyword, 9-3

database initialization file

setting destination parameters, 5-11

database link

creating, 4-18, 4-19

database protection modes, 14-21

maximum availability, 13-14

maximum performance, 13-14

maximum protection, 5-36, 13-14

database roles

primary, 1-11, 7-1

standby, 1-11, 7-1

summary, 7-20

transition, 1-11, 7-1

forced database failover, 7-31

graceful database failover, 7-23

unavoidable-data-loss failover, 7-27

databases

cascading standby, E-1

data

intentional loss of, 7-35

logical standby

cascading, E-1, E-4

SQL apply mode, 1-9, 2-9, 6-2, 9-3

physical standby

cascading, E-1, E-3

managed recovery mode, 2-2, 6-7

manual recovery mode, B-4

read-only mode, 2-2, 6-23

renaming datafiles, 6-20

transmitting archived redo logs, 6-7

primary

gathering redo log archival information, 5-58

setting archive tracing, 5-60

role transition, 1-11, 7-1

forced database failover, 7-31

graceful database failover, 7-23

unavoidable-data-loss failover, 7-27

standby

control files, 8-11, 8-13

creating procedures for, 3-5, B-13

datafiles, taking offline, 8-11

direct path operations, 8-12

failover to, 7-17

initialization parameters, 3-8, 5-32

redo log files, altering, 8-10

renaming datafiles, 8-10

datafiles

adding to primary database, 8-9, 10-15

deleting, 8-6, 8-9, 10-19

renaming, 6-20, 10-18

effect on standby database, 8-10

datatypes

on logical standby databases

avoiding problems, 10-47

supported, 4-2

unsupported, 4-2

skipping unsupported, 10-45

DB_FILE_NAME_CONVERT initialization parameter, 6-20, 10-2, 10-7, 11-2

DB_FILES initialization parameter, 10-7, 11-3

DB_NAME initialization parameter, 10-7, 11-3

DBA_DATA_FILES view, 8-6

DBA_LOGSTDBY_EVENTS view, 9-5, 14-4, A-8

DBA_LOGSTDBY_LOG view, 6-32, 14-5

listing archived redo logs, 10-51

DBA_LOGSTDBY_NOT_UNIQUE view, 4-3, 14-6

DBA_LOGSTDBY_PARAMETERS view, 14-7

DBA_LOGSTDBY_PROGRESS view, 6-5, 6-33, 9-6, 14-8

querying SCN information, 10-52

DBA_LOGSTDBY_SKIP view, 9-4, 14-9

DBA_LOGSTDBY_SKIP_TRANSACTION view, 14-10

DBA_LOGSTDBY_UNSUPPORTED view, 4-3, 9-4, 14-11

DBA_TABLESPACES view, 8-5

DBMS_LOGMNR_D package

SET_TABLESPACE procedure, 4-8

DBMS_LOGSTDBY package

APPLY_SET procedure, 6-4, 9-9

APPLY_UNSET procedure, 6-4

BUILD procedure, 6-4

GUARD_BYPASS_OFF procedure, 6-4

GUARD_BYPASS_ON procedure, 4-18, 6-4

INSTANTIATE_TABLE procedure, 6-5, 9-3, 10-48

SKIP procedure, 6-5, 9-3, 9-4, 10-47, A-8

SKIP_ERROR procedure, 6-5, 9-5

SKIP_TRANSACTION procedure, 6-5, A-8

UNSKIP procedure, 6-5, 9-3

UNSKIP_ERROR procedure, 6-5

UNSKIP_TRANSACTION procedure, 6-5

using to manage SQL apply operations, 6-3

DBNEWID (nid) utility, 4-14

DBSNMP process, A-7

DDL transactions

filtering, 10-48

DEFAULT DELAY option

of managed recovery mode, 6-12, 13-11

DEFER option

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-11, 10-32

DELAY option

LOG_ARCHIVE_DEST_n initialization parameter, 5-29, 10-36, 12-13

of managed recovery mode, 6-12, 13-11

deleting

datafiles, 8-6, 8-9, 10-19

redo logs, 8-10

DEPENDENCY option

LOG_ARCHIVE_DEST_n initialization parameter, 5-27, 12-16

destinations

archived redo logs, 5-22 to 5-30

log transport services, 5-2, 5-4

specifying dependency, 5-27

determining

the applied redo log data, 9-6

the highest applicable (newest) SCN, 10-51

the highest applied SCN, 10-51

direct path operations

standby databases, 8-12

directory structure

of standby database, 2-5

disabling

archived redo log operation, 7-32

disaster recovery preparation

ReadMe file at standby site, 10-25

DISCONNECT option

of managed recovery mode, 6-12, 10-16, 13-11

distributed management framework, 1-4

DML transactions

filtering, 10-48

DROP STANDBY LOGFILE clause

of ALTER DATABASE, 13-7

DROP STANDBY LOGFILE MEMBER clause

of ALTER DATABASE, 13-7

dropping

online redo logs, 10-20

tablespaces, 8-6, 8-9, 10-19

tempfiles, 4-15

dynamic parameters

AQ_TM_PROCESSES, A-7

JOB_QUEUE_PROCESSES, A-7

dynamic performance views, 8-2, 14-3

See also views

ENABLE option

LOG_ARCHIVE_DEST_n, 10-6

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-11, 5-24, 10-6, 10-32

enabling

supplemental logging, 4-6

end-of-redo marker

switchover indicator, 6-18

events

on logical standby databases, 9-5

recording, 9-5

EXPIRE option

of managed recovery mode, 6-13, 13-11

failover

cascading standby databases and, E-3

forced, 7-31

graceful, 7-23

in multiple standby databases

configuration, 10-23

intentional data loss and, 7-19, 7-35

minimal-data-loss, 1-12, 7-20, 7-30

no-data-loss, 1-11, 7-19, 7-24

planning for, 7-19

standby databases not involved in, 7-23

to standby database, 7-17

initiating, 7-34

unavoidable-data-loss, 7-27

failover operations

determining the target logical standby database, 10-50

logical standby database scenario, 10-50

failure resolution policies

log transport services, 5-6, 5-25, 5-55

FAL client, 5-3

FAL server, 5-4

FAL_CLIENT initialization parameter, 6-39, 10-7, 11-3

FAL_SERVER initialization parameter, 6-39, 10-7, 11-3

fetch archive log client, 5-3

fetch archive log server, 5-4

filtering

data in archived redo logs, 10-47

filters

for DDL transactions, 10-48

for DML transactions, 10-48

removing, 10-47, 10-49

FINISH option

of managed recovery mode, 6-14, 7-25, 13-12

fixed views, 8-2

See also views

FORCE LOGGING clause

of ALTER DATABASE, 13-8

forced database failover, 7-31

See also failover

gap

in the sequence numbers, 10-51

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

See also views

graceful database failover, 7-23

minimal-data-loss, 7-30

no-data-loss, 7-24

See also failover

unavoidable-data-loss, 7-27

GUARD clause

of ALTER DATABASE, 4-14

GUARD_BYPASS_OFF procedure

of DBMS_LOGSTDBY, 6-4

GUARD_BYPASS_ON procedure

of DBMS_LOGSTDBY, 4-18, 6-4

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

See also views

GV$INSTANCE view, A-6

hot backup operations

copy of the primary database, 4-11

creating a logical standby database, 4-11

initialization parameters, 11-1

ARCHIVE_LAG_TARGET, 11-2

changing at runtime, 5-14

COMPATIBLE, 10-7, 11-2

configuring, 3-8, 5-32, 10-5, 10-12, 10-15

configuring standby databases, 5-30

CONTROL_FILE_RECORD_KEEP_TIME, 5-20, 11-2

CONTROL_FILES, 10-2, 10-7, 11-2

DB_FILE_NAME_CONVERT, 6-20, 10-2, 10-7, 11-2

DB_FILES, 10-7, 11-3

DB_NAME, 10-7, 11-3

FAL_CLIENT, 6-39, 10-7, 11-3

FAL_SERVER, 6-39, 10-7, 11-3

LOB_ARCHIVE_DUPLEX_DEST, 5-11

LOCK_NAME_SPACE, 6-20, 10-2, 10-7, 11-4, A-4

LOG_ARCHIVE_DEST, 5-11, 5-54, 5-55, B-4

LOG_ARCHIVE_DEST_1, 5-54

LOG_ARCHIVE_DEST_n, 5-7, 10-6, 10-8, 11-4, 12-2 to 12-49, B-4, C-3, E-1

LOG_ARCHIVE_DEST_STATE_n, 5-11, 10-6, 11-4, 12-2

LOG_ARCHIVE_FORMAT, 5-53, 10-6, 11-5

LOG_ARCHIVE_MAX_PROCESSES, 11-5

LOG_ARCHIVE_MIN_SUCCEED_DEST, 5-24, 11-5, 12-23

LOG_ARCHIVE_START, 4-6, 11-5

LOG_ARCHIVE_TRACE, 5-60, 6-33, 6-35, 11-5

LOG_FILE_NAME_CONVERT, 6-21, 10-2, 10-8, 11-6

LOG_PARALLELISM, 11-6

modifications for logical standby database, 4-13

modifying for switchover operations, 10-56

on the primary database, 7-5

on the standby database, 7-5

PARALLEL_MAX_SERVERS, 6-3, 11-6

REMOTE_ARCHIVE_ENABLE, 5-21, 11-7

RESOURCE_MANAGER_PLAN, 4-7, 4-11

SHARED_POOL_SIZE, 11-7

SORT_AREA_SIZE, 6-28, 11-7

STANDBY_ARCHIVE_DEST, 5-53, 10-8, 11-8

STANDBY_FILE_MANAGEMENT, 6-21, 6-22, 8-10, 10-16, 11-8

USER_DUMP_DEST, 6-34, 11-8

instance recovery, 7-22

INSTANTIATE_TABLE procedure

of DBMS_LOGSTDBY, 6-5, 9-3, 10-48

JOB_QUEUE_PROCESSES dynamic parameter, A-7

LGWR option

LOG_ARCHIVE_DEST_n initialization parameter, 5-43, 5-56, 12-11

LGWR process, 5-3, C-1

listener.ora file

configuring for standby database, 7-6, 10-4

log transport services tuning and, 5-57

listing

archived redo logs, 10-51

LOCATION option

LOG_ARCHIVE_DEST_n initialization parameter, 5-24, 5-27, 10-6, 12-20

LOCK_NAME_SPACE initialization parameter, 6-20, 10-2, 10-7, 11-4, A-4

log apply services, 6-1 to 6-37

canceling on physical standby databases, 13-11

ensuring that redo logs are being applied, 6-5

for logical standby databases, 6-1, 6-2, 6-3

for physical standby databases, 6-6

initiating, 6-9

introduction, 6-1

monitoring, 6-28

viewing activity for logical standby databases, 9-5

log transport services, 1-10, 5-1 to 5-60

archive destinations

specifying quotas for, 5-29

archived redo logs

confirming successful disk write, 5-47

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

ARCHIVELOG mode, 5-18

capabilities of, 5-4

configuring

data availability modes, 5-43

on the primary database, 5-17

on the standby database, 3-8, 5-30, 5-32

data protection modes, 5-35 to 5-48

definition, 1-2

destinations, 5-2, 5-4

failure resolution policies, 5-6

generating archived redo log filenames, 5-53

interfaces to, 5-7 to 5-16

monitoring, 5-58

network tuning, 5-57

no-data-loss, 5-44, 5-55

overview, 5-2

permission, 5-4

re-archiving to failed destinations, 5-25

reception, 5-6

setting failure resolution policies, 5-55

setting primary database initialization parameters, 5-17

specifying alternate destinations for archiving, 5-26

specifying storage locations for standby redo logs, 5-54

SQL interface, 5-13

transmission, 5-5

using Oracle Net with, 5-2

log transport services data protection modes

maximum availability, 5-39

maximum performance, 5-41

maximum protection, 5-36

log writer process, 5-3

asynchronous network I/O and, C-1

LOG_ARCHIVE_DEST initialization parameter, 5-11, B-4

LOG_ARCHIVE_DEST_1 initialization parameter, 5-54

LOG_ARCHIVE_DEST_n initialization parameter, 5-7, 5-23, 5-54, 10-6, 10-8, 11-4, 12-2 to 12-49, B-4, C-3, E-1

AFFIRM option, 5-47, 5-56, 12-3

ALTERNATE option, 5-26, 12-6

ARCH option, 5-43, 12-11

ASYNC option, 5-45, 5-56, 12-43

DELAY option, 5-29, 6-12, 10-36, 12-13

DEPENDENCY option, 5-27, 12-16

ENABLE option, 10-6

LGWR option, 5-43, 5-56, 12-11

LOCATION option, 5-24, 5-27, 10-6, 12-20

MANDATORY option, 5-23, 5-24, 10-23, 12-23

MAX_FAILURE option, 5-26, 12-26

NET_TIMEOUT option, 12-29

network and disk I/O methods, 5-56

NOAFFIRM option, 5-47, 5-56, 12-3

NOALTERNATE option, 5-26, 12-6

NODELAY option, 5-29, 12-13

NODEPENDENCY option, 12-16

NOMAX_FAILURE option, 5-26, 12-26

NONET_TIMEOUT option, 12-29

NOQUOTA_SIZE option, 12-31

NOQUOTA_USED option, 12-34

NOREGISTER option, 12-37

NOREOPEN option, 5-25, 12-41

NOTEMPLATE option, 12-46

option compatibility, 12-49

OPTIONAL option, 5-24, 10-6, 10-24, 12-23

QUOTA_SIZE option, 5-29, 12-31

QUOTA_USED option, 12-34

REGISTER option, 12-37

REGISTER=location_format option, 5-28, 12-39

REOPEN option, 5-23, 5-25, 10-6, 12-41

SERVICE option, 5-23, 10-6, 12-20

specifying destinations using, 5-23, 10-6, 12-2

SYNC option, 5-44, 5-47, 5-56, 12-43

SYNC=NOPARALLEL option, 5-45

SYNC=PARALLEL option, 5-45

TEMPLATE option, 12-46

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-11, 10-6, 11-4, 12-2

ALTERNATE option, 5-11

DEFER option, 5-11, 10-32

ENABLE option, 5-11, 5-24, 10-6, 10-32

RESET option, 5-11

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 5-11

LOG_ARCHIVE_FORMAT initialization parameter, 5-53, 5-54, 5-55, 10-6, 11-5

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 11-5

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 5-24, 11-5, 12-23

LOG_ARCHIVE_START initialization parameter, 4-6, 11-5

LOG_ARCHIVE_TRACE initialization parameter, 5-60, 6-33, 6-35, 11-5

LOG_FILE_NAME_CONVERT initialization parameter, 6-21, 10-2, 10-8, 11-6

LOG_PARALLELISM initialization parameter, 11-6

setting for logical standby databases, 4-7

logging

See also supplemental logging

supplemental, 4-6

logical standby databases

adding tables, 9-3

applying SQL statements, 6-2

archiver (ARCn) and, 6-2

cascading, E-1, E-4

checklist of tasks, 4-8

configuring a listener, 4-17

controlling user access to tables, 9-2

creating, 4-1

creating a table from an existing table, 10-48

creating from a cold backup, 4-10

creating from a hot backup, 4-11

determining unsupported objects, 4-3

events, 9-5

LOG_PARALLELISM initialization parameter, 4-7

logical standby process (LSP) and, 6-3

maintaining data in tables, 4-3

managing, 9-1

modifying initialization parameters for switchover operations, 10-55

preparing to create, 4-1

recovering a table, 10-49

registering the location of archived redo logs, 5-28

remote file server (RFS) and, 6-2

removing filters, 10-47, 10-49

scenarios, 10-45 to 10-58

skipping all objects, 10-47

skipping tables, 9-3

skipping transactions, 10-45

SQL apply mode, 1-9, 2-9, 6-2, 9-3

supported datatypes, 4-2

switchover scenario, 10-55

tables not supported, 9-4

target of a failover operation, 10-50

uniquely identifying tables, 4-3

unsupported

datatypes, 4-2

sequences, 4-3

tables, 4-3

using tables in the SYS and SYSTEM schemas, 4-8

logical standby process

for logical standby databases, 6-3

logs

switching, 4-12

managed recovery

in background mode, 6-12

in background session, 6-9

in foreground session, 6-9

of physical standby databases

canceling, 6-11

monitoring, 6-10

of standby databases, 3-3

monitoring, 6-28

preparing for, 3-3

managed recovery mode

definition, 6-1

managed recovery process (MRP) and, 6-1, 6-6, 6-13, 7-25

physical standby databases, 2-2, 6-7

CANCEL IMMEDIATE option, 13-11

CANCEL NOWAIT option, 6-11, 13-11

CANCEL option, 6-11, 8-14, 13-11

DEFAULT DELAY option, 6-12, 13-11

DELAY option, 6-12, 13-11

DISCONNECT option, 6-12, 10-16, 13-11

EXPIRE option, 6-13, 13-11

FINISH option, 6-14, 13-12

NEXT option, 6-14, 13-11

NO EXPIRE option, 6-13, 13-12

NO TIMEOUT option, 6-20, 13-12

NODELAY option, 6-15, 10-38, 13-12

NOPARALLEL option, 13-12

PARALLEL option, 6-15, 6-29, 13-12

starting, 6-9, 10-9

THROUGH ALL ARCHIVELOG option, 6-17, 13-13

THROUGH...SEQUENCE option, 6-19, 13-12

THROUGH...SWITCHOVER option, 6-18, 13-13

TIMEOUT option, 6-19, 10-9, 13-13

managed recovery process (MRP)

See managed recovery mode

MANDATORY option

LOG_ARCHIVE_DEST_n initialization parameter, 5-23, 5-24, 10-23, 12-23

manual recovery mode

initiating, B-3

of physical standby databases

preparing for, B-1

when is it required, B-5

manually propagating unrecoverable operations, 8-12

MAX_FAILURE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-26, 12-26

maximize data availability, 5-35

maximize data performance, 5-35

maximize data protection, 5-35

maximum availability

log transport services data protection modes, 5-39

Real Application Clusters, 5-41

maximum performance

for Real Application Clusters, 5-42

log transport services data protection modes, 5-41

maximum protection

log transport services data protection modes, 5-36

Real Application Clusters, 5-38

minimal-data-loss failover, 1-12, 7-20

modifying

initialization parameter files for switchover, 10-55

monitoring

log apply services, 6-10, 6-28

log transport services, 5-58

standby databases, 8-2

MOUNT STANDBY DATABASE clause

of ALTER DATABASE, 8-14, 13-9, B-4

MRP

See managed recovery mode

multiple standby databases

failing over to one, 10-23

NET_TIMEOUT option

LOG_ARCHIVE_DEST_n initialization parameter, 12-29

network and disk I/O methods

LOG_ARCHIVE_DEST_n initialization parameter, 5-56

network failures

identifying, 10-30

network files

configuring, 3-2, 10-4

network server processes

achieving asynchronous network I/O, C-2

network tuning

log transport services, 5-57

NEWEST_SCN column

of DBA_LOGSTDBY_PROGRESS, 10-52

NEXT option

of managed recovery mode, 6-14, 13-11

NO EXPIRE option

of managed recovery mode, 6-13, 13-12

NO TIMEOUT option

of managed recovery mode, 6-20, 13-12

NOAFFIRM option

LOG_ARCHIVE_DEST_n initialization parameter, 5-56, 12-3

NOALTERNATE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-26, 12-6

no-data-loss failover, 1-11, 5-44, 5-55, 7-19

NODELAY option

LOG_ARCHIVE_DEST_n initialization parameter, 5-29, 12-13

of managed recovery mode, 6-15, 10-38, 13-12

NODEPENDENCY option

LOG_ARCHIVE_DEST_n initialization parameter, 12-16

NOFORCE LOGGING clause

of ALTER DATABASE, 13-8

NOMAX_FAILURE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-26, 12-26

NONET_TIMEOUT option

LOG_ARCHIVE_DEST_n initialization parameter, 12-29

NOPARALLEL option

of managed recovery mode, 13-12

SYNC option, 5-45

NOQUOTA_SIZE option

LOG_ARCHIVE_DEST_n initialization parameter, 12-31

NOQUOTA_USED option

LOG_ARCHIVE_DEST_n initialization parameter, 12-34

NOREGISTER option

LOG_ARCHIVE_DEST_n initialization parameter, 12-37

NOREOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 5-25, 12-41

NOTEMPLATE option

LOG_ARCHIVE_DEST_n initialization parameter, 12-46

offline

taking standby database datafiles, 8-11

online redo logs

adding, 10-20

clearing, 8-14

configuration considerations for, 5-18

dropping, 10-20

OPEN READ ONLY clause

of ALTER DATABASE, 6-24, 13-9

OPEN RESETLOGS clause

of ALTER DATABASE, 10-20

operational requirements

standby database, 1-16

option compatibility

LOG_ARCHIVE_DEST_n initialization parameter, 12-49

OPTIONAL option

LOG_ARCHIVE_DEST_n initialization parameter, 5-24, 10-6, 10-24, 12-23

Oracle Net

configuring a connection, 10-4

Oracle Net Manager

configuring the listener, 6-38

creating a net service name, 6-38

resolving archive gaps, 6-38

Oracle9i Data Guard command-line interface

introduction, 1-5

PARALLEL option

of managed recovery mode, 6-15, 6-29, 13-12

SYNC option, 5-45

parallel recovery

on physical standby databases, 6-16, 6-29

PARALLEL_MAX_SERVERS initialization parameter, 6-3, 11-6

parent destination

definition, 5-27

permission

log transport services, 5-4, 5-21

physical standby databases

archived redo logs

transmitting, 6-7

archiver (ARCn) and, 6-6

cascading, E-1, E-3

checklist of tasks, 3-1

datafiles

renaming, 6-20

managed recovery mode, 2-2, 6-1, 6-7, 10-9

managed recovery process (MRP) and, 6-6

manual recovery mode

procedures, B-4

parallel recovery, 6-16

read-only mode, 2-2, 6-2, 6-23

registering the location of archived redo logs, 5-28

remote file server (RFS) and, 6-6

renaming datafiles automatically, 6-20

starting the physical standby instance, 6-8

transmitting archived redo logs, 6-7

planned transitions, 1-11, 7-1

primary databases

backing up from standby databases, 8-1, 10-38

configuring log transport services on, 5-17

datafiles

adding, 8-9, 10-16

deleting, 8-9, 10-19

renaming, 8-10, 10-18

hot backup copy operations, 4-11

initialization parameter file, 7-5

instance recovery, 7-22

performing a cold backup, 4-10

performing a hot backup, 4-11

putting in a quiesced state, 4-12

Real Application Clusters and

setting up, D-3

setting failure resolution policy for, 5-55

switching to logical standby role, 7-13

switching to physical standby role, 7-8

tablespaces

adding, 8-9

dropping, 8-9

processes

archiver (ARCn), 5-3

CJQ0, A-7

DBSNMP, A-7

log writer (LGWR), 5-3, C-1

QMN0, A-7

See also logical standby process

See also managed recovery process (MRP)

See also network server processes

protection levels

setting, 5-55

to maximize availability, 5-39

to maximize performance, 5-41

to maximum protection, 5-36

protection modes, 14-21

QMN0 process, A-7

QUIESCE clause

of ALTER SYSTEM, 4-12

quiesced state

primary database, 4-12

QUOTA_SIZE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-29, 12-31

QUOTA_USED option

LOG_ARCHIVE_DEST_n initialization parameter, 12-34

read-only mode

definition, 6-2

physical standby databases, 2-2, 6-2, 6-23

Real Application Clusters, 1-10, 2-9, D-1

instance recovery, 7-22

performing switchover and, 7-6

primary databases and, D-3

setting

maximum data availability, 5-41

maximum data performance, 5-42

maximum data protection, 5-38

standby databases and, 8-15, D-3

using standby redo logs, 5-51

reception

log transport services, 5-6, 5-48

recording events, 9-5

RECOVER AUTOMATIC clause

of ALTER DATABASE, 4-14

RECOVER MANAGED STANDBY DATABASE clause, 6-9

of ALTER DATABASE, 7-11, 13-10

CANCEL IMMEDIATE option, 6-11, 13-11

CANCEL NOWAIT option, 6-11, 13-11

CANCEL option, 6-11, 13-11

DEFAULT DELAY option, 6-12, 13-11

DELAY option, 6-12, 13-11

DISCONNECT option, 6-12, 6-13, 13-11

EXPIRE option, 6-13, 13-11

FINISH option, 6-14, 7-24, 7-25, 13-12

NEXT option, 6-15, 13-11

NO EXPIRE option, 6-13, 13-12

NO TIMEOUT option, 6-20, 13-12

NODELAY option, 6-15, 13-12

NOPARALLEL option, 6-17, 13-12

PARALLEL option, 6-17, 13-12

THROUGH ALL ARCHIVELOG option, 6-18, 13-13

THROUGH...SEQUENCE option, 6-19, 13-12

THROUGH...SWITCHOVER option, 6-18, 13-13

TIMEOUT option, 6-20, 10-9, 13-13

recovering

a table, 10-49

from errors, 9-7

missing archived redo logs, 10-52

recovery

from network failure, 10-30

instances in Real Application Clusters, 7-22

redo logs

adding, 8-10

applying on logical standby databases, 4-16

applying on standby databases, 2-5

archive gap management of, 6-37

archiving to standby databases, 2-3

clearing, 8-11, 8-14

deleting, 8-10

logging supplemental information, 4-6

receiving and storing on standby databases, 5-48

registering, 4-16

resetting, 8-11

setting permission to archive, 5-21

switchover indicator, 6-18

transmitting, 5-5

See also archived redo logs

See also online redo logs

See also standby redo logs

refreshing

standby database control files, 8-13

REGISTER LOGFILE clause

of ALTER DATABASE, 7-16, 13-13

REGISTER LOGICAL LOGFILE clause

of ALTER DATABASE, 4-16, 7-26, 7-33

REGISTER option

LOG_ARCHIVE_DEST_n initialization parameter, 12-37

REGISTER=location_format option

LOG_ARCHIVE_DEST_n initialization parameter, 5-28, 12-39

registering

recovered archived redo logs, 10-53

RELY constraint

creating, 4-5

disabled, 4-4

logical database system tuning and, 9-9

overview, 4-4

REMOTE_ARCHIVE_ENABLE initialization parameter, 5-21, 11-7

removing

filters on logical standby databases, 10-47, 10-49

RENAME FILE clause

of ALTER DATABASE, 6-22, B-14

renaming

datafiles, 8-10, 10-18

automatically, 6-20

manually, B-13

physical standby database datafiles, 6-20

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 5-23, 5-25, 10-6, 12-41

RESET option

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 5-11

RESETLOGS clause

of ALTER DATABASE, B-8

Resource Manager

starting, 4-11

RESOURCE_MANAGER_PLAN initialization parameter, 4-7, 4-11

revert

from physical standby role to primary role, 7-16

role management services, 7-1

role transition, 1-11, 7-1

forced database failover, 7-31

graceful database failover, 7-23

rolling upgrade

during switchover, 7-5

scenarios

cascading standby databases, E-5 to E-9

logical standby database, 10-45 to 10-58

physical standby database, 10-1 to 10-44

schemas

skipping all objects, 10-47

SCN

determine the highest applicable (newest), 10-51

determine the highest applied, 10-51

sequences

unsupported on logical standby databases, 4-3

SERVICE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-23, 10-6, 12-20

SET LOG_ARCHIVE_DEST_STATE_n clause

of ALTER SYSTEM, 7-14, 7-15

SET LOG_ARCHIVE_TRACE clause

of ALTER SYSTEM, 6-34

SET RESOURCE_MANAGER_PLAN clause

of ALTER SYSTEM, 4-7

SET STANDBY DATABASE clause

of ALTER DATABASE, 5-55, 13-14

SET_TABLESPACE procedure

of DBMS_LOGMNR_D, 4-8

SHARED_POOL_SIZE initialization parameter, 11-7

SKIP procedure

of DBMS_LOGSTDBY, 6-5, 9-3, 9-4, 10-47, A-8

SKIP_ERROR procedure

of DBMS_LOGSTDBY, 6-5, 9-5

SKIP_TRANSACTION procedure

of DBMS_LOGSTDBY, 6-5, A-8

skipping

activity on all objects in a schema, 10-47

activity on specific objects in a schema, 10-47

transactions, 10-45

SORT_AREA_SIZE initialization parameter, 6-28, 11-7

specifying the location of archived redo logs, 5-28

SQL apply mode, 1-9, 2-9, 9-3

applying redo data to logical standby databases, 6-3

definition, 6-2

viewing activity for logical standby databases, 9-5

SQL apply operations

uniquely identifying table rows, 4-3

SQL statements

ALTER DATABASE, 4-14, 5-52, 5-53, 5-55, 7-10, 7-11, 7-16, 7-24, 7-31, 8-11, 8-14, 9-2, 13-1

restrictions, 6-22

ALTER SESSION, 5-14

ALTER SYSTEM, 5-14

CREATE CONTROLFILE, 8-11

CREATE TABLESPACE, 4-8

CREATE TEMPORARY TABLESPACE, 6-26

relating to standby database, 13-1

SQL*Plus commands

ARCHIVE LOG LIST, 3-6, 4-5, 10-4, 10-11

standby databases

activating, 7-17

altering control files, 8-11

cascading, E-1, E-3

configuration of environment, 2-1

configuration options

cross-instance archival, 1-10, 2-9

delayed standby, 5-29, 10-36

configuring, 5-30

control files

copying, 3-8

creating, 3-6, 10-11

refreshing, 8-13

creating, 3-3

on remote host, 10-10

on same host, 10-1

procedures, 3-5, B-13

creating files, 3-3

datafiles

automating creation of, 10-16

manual creation of, 10-17

renaming, 8-10

taking offline, 8-11

direct path operations, 8-12

directory structure, 2-5

failing over to one of many, 10-23

failover to, 7-17

initialization parameter file for, 3-8, 5-32, 7-5, 10-7, 10-13

invalidating, B-8

location

on different site from primary, 2-6

on same site as primary, 2-6

maximum number of, 2-1

minimal-data-loss failover, 1-12, 7-20

monitoring, 8-2

no-data-loss failover, 1-11, 7-19

operational requirements, 1-16

Real Application Clusters and, 8-15

setting up, D-3

re-creating, 10-33

redo log files

altering, 8-10

switching to primary role, 7-10

with a time lag

bypassing, 10-38

creating, 5-29, 10-37

managing, 10-37

rolling back database, 10-37

standby initialization parameter files

creating, 5-32

standby redo log groups

creating, 5-51

standby redo logs

creating, 5-50

log groups and members, 5-52

on the primary database, 5-50

redo log members, 5-53

in Real Application Clusters, 5-51

introduction, 5-6, 5-49

specifying storage locations for, 5-54

specifying the location on the standby database, 5-53

STANDBY_ARCHIVE_DEST initialization parameter, 5-53, 10-8, 11-8

specifying the standby location of archived redo logs, 5-53

STANDBY_FILE_MANAGEMENT initialization parameter, 6-21, 6-22, 8-10, 10-16, 11-8

START LOGICAL STANDBY APPLY clause

of ALTER DATABASE, 4-16, 7-15, 7-26, 7-33, 13-15, A-8

starting

physical standby instances, 6-8

Resource Manager, 4-11

STOP LOGICAL STANDBY APPLY clause

of ALTER DATABASE, 7-26, 7-33, 13-16

supplemental logging

adding data to redo logs, 4-6

creating a unique key, 4-4

enabling, 4-6

identifying table rows, 4-3

logical standby databases and, 6-3

on primary database, 4-6

SUPPLEMENTAL_LOG_DATA_PK column

of V$DATABASE, 4-6

SUPPLEMENTAL_LOG_DATA_UI column

of V$DATABASE, 4-6

SWITCH LOGFILE clause

of ALTER SYSTEM, 4-12

switchback, 7-9

switchover, 7-4, 10-28

configuring, 10-28

for cascading standby databases, E-2

from primary to logical standby role, 7-13

from primary to physical standby role, 7-8

from primary to standby role, 4-8, 10-28

from standby to primary role, 7-10

logical standby database scenario, 10-55, 10-56

modifying initialization parameters for logical standby databases, 10-55

multiple standby databases, 7-15

performing a rolling upgrade and, 7-5

physical database access and, 7-6

primary control file conversion, 7-12

processes that prevent, A-7

CJQ0, A-7

DBSNMP, A-7

QMN0, A-7

standby control file conversion, 7-12

standby databases not involved in, 7-11

steps to perform, 7-13

using Real Application Clusters and, 7-6

validating transition, 7-15

verifying status, 7-7, 7-13

switchover indicator

definition, 6-18

SYNC option

LOG_ARCHIVE_DEST_n initialization parameter, 5-44, 5-47, 5-56, 12-43

SYNC=NOPARALLEL option

LOG_ARCHIVE_DEST_n initialization parameter, 5-45

SYNC=PARALLEL option

LOG_ARCHIVE_DEST_n initialization parameter, 5-45

SYS schema

tables used by logical standby databases, 4-8

SYSTEM schema

tables used by logical standby databases, 4-8

system tuning for logical standby databases, 9-8

table rows

identifying in logical standby databases, 4-3

tables

logical standby databases

adding on, 9-3

maintaining data in, 4-3

not supported by, 9-4

recovering on, 10-49

re-creating on, 10-48

skipping on, 9-3

skipping transactions on, 10-45

unsupported on, 4-3

tablespaces

adding to primary database

effect on standby, 8-9

creating temporary, 6-26

dropping, 8-6, 8-9, 10-19

managing, 4-8

sorting without, 6-27

tempfile

creating, 4-16

dropping, 4-15

TEMPFILE clause

of ALTER DATABASE, 4-16

TEMPLATE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-28, 12-46

THROUGH ALL ARCHIVELOG option, 6-17

of managed recovery mode, 6-17, 13-13

THROUGH...SEQUENCE option, 6-19

of managed recovery mode, 6-19, 13-12

THROUGH...SWITCHOVER option, 6-18

of managed recovery mode, 6-18, 13-13

time lag

in standby database, 5-29, 10-37 to 10-38, 12-13

when applying redo logs to standby databases, 12-13

TIMEOUT option

of managed recovery mode, 6-19, 10-9, 13-13

tnsnames.ora file

configuring, 7-6

log transport services tuning and, 5-57

trace files

levels of tracing data, 6-35

location of, 6-34

setting, 6-34

transactions

skipping on a logical standby database, 10-45

transmission modes, 5-46

ASYNC, 5-45

SYNC, 5-44

SYNC=NOPARALLEL, 5-45

transmitting

archived redo logs, 6-7

redo logs, 5-5

troubleshooting

apply operations, A-8

unavoidable-data-loss failover

definition, 7-27

UNQUIESCE clause

of ALTER SYSTEM, 4-12

unrecoverable operations, 8-12, 10-20

backups after, 8-13

propagating manually, 8-12

UNSKIP procedure

of DBMS_LOGSTDBY, 6-5, 9-3

UNSKIP_ERROR procedure

of DBMS_LOGSTDBY, 6-5

UNSKIP_TRANSACTION procedure

of DBMS_LOGSTDBY, 6-5

unsupported objects

skipping, 10-45

USER_DUMP_DEST initialization parameter, 6-34, 11-8

V$ARCHIVE_DEST view, 5-13, 5-59, 8-2, 10-31, 14-12, A-2

V$ARCHIVE_DEST_STATUS view, 5-59, 6-10, 6-29, 8-2, 14-15

V$ARCHIVE_GAP view, 8-3, 14-17, B-9

V$ARCHIVED_LOG view, 5-54, 5-59, 6-30, 7-16, 8-3, 14-18, B-10

V$DATABASE view, 3-6, 4-5, 7-7, 7-13, 7-16, 8-3, 10-4, 14-20

SUPPLEMENTAL_LOG_DATA_PK column, 4-6

SUPPLEMENTAL_LOG_DATA_UI column, 4-6

V$DATAFILE view, 4-10, 8-3, 8-13, 10-10, 10-21, 14-24

V$DATAGUARD_STATUS view, 6-30, 8-3, 14-26

V$LOG view, 5-58, 8-3, 14-28

V$LOG_HISTORY view, 6-30, 8-4, 8-7, 14-30

V$LOGFILE view, 8-3, 14-29

V$LOGSTDBY view, 6-5, 7-27, 9-5, 14-31

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

V$MANAGED_STANDBY view, 6-10, 6-29, 8-4, 14-33

V$PX_SESSION view, 14-31

V$RECOVER_FILE view, 8-5, 8-6

V$SESSION view, 14-31, A-3, A-6

V$STANDBY_LOG view, 8-4, 14-36

V$SYSSTAT view, 5-20

V$TEMPFILE view, 4-16

V$THREAD view, 8-5

views, 14-1

DBA_DATA_FILES, 8-6

DBA_LOGSTDBY_EVENTS, 9-5, 14-4, A-8

DBA_LOGSTDBY_LOG, 6-32, 10-51, 14-5

DBA_LOGSTDBY_NOT_UNIQUE, 4-3, 14-6

DBA_LOGSTDBY_PARAMETERS, 14-7

DBA_LOGSTDBY_PROGRESS, 6-5, 6-33, 9-6, 14-8

DBA_LOGSTDBY_SKIP, 9-4, 14-9

DBA_LOGSTDBY_SKIP_TRANSACTION, 14-10

DBA_LOGSTDBY_UNSUPPORTED, 4-3, 9-4, 14-11

DBA_TABLESPACES, 8-5

GV$INSTANCE, A-6

V$ARCHIVE_DEST, 5-13, 5-59, 8-2, 10-31, 14-12, A-2

V$ARCHIVE_DEST_STATUS, 5-59, 6-10, 6-29, 8-2, 14-15

V$ARCHIVE_GAP, 8-3, 14-17, B-9

V$ARCHIVED_LOG, 5-54, 5-59, 6-30, 7-16, 8-3, 14-18, B-10

V$DATABASE, 3-6, 4-5, 7-7, 7-13, 7-16, 8-3, 10-4, 14-20

V$DATAFILE, 4-10, 8-3, 8-13, 10-10, 10-21, 14-24

V$DATAGUARD_STATUS, 6-30, 8-3, 14-26

V$LOG, 5-58, 8-3, 14-28

V$LOG_HISTORY, 6-30, 8-4, 8-7, 14-30

V$LOGFILE, 8-3, 14-29

V$LOGSTDBY, 6-5, 7-27, 9-5, 14-31

V$LOGSTDBY_STATS, 9-6, 14-32

V$MANAGED_STANDBY, 6-10, 6-29, 8-4, 14-33

V$PX_SESSION, 14-31

V$RECOVER_FILE, 8-5, 8-6

V$SESSION, 14-31, A-3, A-6

V$STANDBY_LOG, 8-4, 14-36

V$SYSSTAT, 5-20

V$TEMPFILE, 4-16

V$THREAD, 8-5