Oracle9i Data Guard Concepts and Administration -- Index

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, 5-5, 9-1

ADD LOGFILE clause

of ALTER DATABASE, 3-44, 4-16, 9-1

ADD LOGFILE GROUP clause

of ALTER DATABASE, 3-44, 9-1

ADD LOGFILE MEMBER clause

of ALTER DATABASE, 3-44, 4-16, 9-1

adding

datafiles, 4-15, 5-40, 6-20, 6-49

online redo logs, 5-41, 6-25

standby redo logs, 3-44

tablespaces, 5-40

AFFIRM option

LOG_ARCHIVE_DEST_n initialization parameters, 3-39, 3-47, 8-3

ALTER DATABASE statement, 9-1

ACTIVATE STANDBY DATABASE clause, 5-5, 9-1

SKIP STANDBY LOGFILE clause, 5-31

ADD STANDBY LOGFILE clause, 3-44, 4-16, 9-1

ADD STANDBY LOGFILE GROUP clause, 3-44, 9-1

ADD STANDBY LOGFILE MEMBER clause, 3-44, 4-16, 9-1

CLEAR LOGFILE GROUP clause, 5-45

CLEAR UNARCHIVED LOGFILE clause, 5-42, 6-28

COMMIT TO SWITCHOVER clause, 5-4, 5-10, 5-12, 9-2

CREATE STANDBY CONTROLFILE clause, 2-15, 5-45, 6-13, 9-1

DROP STANDBY LOGFILE clause, 9-1

DROP STANDBY LOGFILE MEMBER clause, 9-2

MOUNT STANDBY DATABASE clause, 5-45, 9-2, B-4

OPEN READ ONLY clause, 4-19, 9-2

OPEN RESETLOGS clause, 6-28

RECOVER MANAGED STANDBY DATABASE clause, 4-6 to 4-12, 5-4, 5-12, 6-11, 9-2

RECOVER STANDBY DATABASE clause, 9-2

REGISTER LOGFILE clause, 5-18, 9-2

RENAME FILE clause, 4-16, B-14

RESETLOGS parameter, B-8

restrictions, 4-16

SET STANDBY DATABASE PROTECTED clause, 3-46, 9-2

SET STANDBY DATABASE UNPROTECTED clause, 3-46, 3-47, 5-29, 9-2

ALTER SESSION statement

modifying initialization parameters with, 3-12

ALTER SYSTEM statement

ARCHIVE LOG CURRENT clause, 6-45

modifying initialization parameters with, 3-12

SET LOG_ARCHIVE_TRACE clause, 4-26

altering

control files, 5-42, 6-26

ALTERNATE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-23, 8-5

applying

redo logs

on standby database, 2-4

AQ_TM_PROCESSES dynamic parameter, 5-17

ARCH option

LOG_ARCHIVE_DEST_n initialization parameters, 3-36, 3-47, 8-10

archive destinations, 3-2, 6-31

alternate, 3-23

MANDATORY, 6-32

multiple, 6-7

OPTIONAL, 6-32

archive gaps

applying the logs to standby database, 6-51, B-11

causes of, B-5

copying the logs in, 6-50, B-10

identifying the logs, 4-12, 6-50, B-9

management of, 4-12

preventing, B-8

resolving using the Oracle Net Manager, 4-12, 4-13

ARCHIVE LOG clause

of ALTER SYSTEM, 6-45

ARCHIVE LOG LIST command, 2-14, 6-13

archive tracing

standby databases and, 3-52, 4-25

ARCHIVE_LAG_TARGET initialization parameter, 7-2

archived redo logs

accessing information about, 4-24, 5-38

copying manually, 2-3

delayed application on the standby database, 3-25

destinations, 3-4, 3-19 to 3-26

disabling, 5-28

gap management, 4-12

introduction, 3-1

multiple destinations and, 6-7

standby databases and, 4-22

transmitting, 4-3

ARCHIVELOG mode

checking for, 2-14, 6-13

log transport services, 3-15

switching from primary role to standby, 5-9

archiver process, 3-3

archiving

redo logs

automatically, 3-1, 3-3, 3-19

manually, 2-3

specifying failure resolution policies for, 3-22

specifying network transmission modes for, 3-37

to failed destinations, 3-22

to standby database, 2-3

ARCn process, 3-3

ASYNC option

LOG_ARCHIVE_DEST_n initialization parameters, 3-37, 3-47, 8-33

asynchronous network I/O

log writer process and, C-1

network server processes and, C-2

availability modes

configuring, 3-36

background mode recovery, 4-7

backing up

primary databases from standby databases, 5-32, 6-56

standby database, 6-56

backups

after UNRECOVERABLE operations, 5-44

of primary database, 2-12, 5-32, 6-56

of primary database datafiles, 6-12

of standby database, 6-56

broker

See Oracle9i Data Guard broker

CANCEL IMMEDIATE option

of managed recovery mode, 9-3

CANCEL option

of managed recovery mode, 4-6, 5-44, 6-27, 9-3

CJQ0 process, 5-17

CLEAR LOGFILE clause

of ALTER DATABASE, 5-42, 5-45, 6-28

clearing

online logs

implication for standby databases, 5-45

client application failover

configuring, 6-39

commands

standby database, 9-1

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 5-4, 5-10, 5-12, 9-2

COMPATIBLE initialization parameter, 3-27, 6-9, 7-2

configuration

of online redo logs, 3-15

of standby environment, 2-1, 3-27

configuration options

standby databases, 1-18

cross-instance archival, 1-9

delayed standby, 1-18, 3-25, 6-52

configuring

client application failover, 6-39

initialization parameter file, 6-6, 6-16, 6-19

log transport services data availability modes, 3-36

network files, 6-4, 6-39, 6-41

online redo logs, 3-15

standby databases, 3-27

standby redo log groups, 3-43

standby redo logs, 3-42, 3-44

switchover, 6-36

control files

altering, 5-42, 6-26

copying, 2-16

creating, 2-13, 6-13

effect on standby databases, 5-42

refreshing standby database, 5-44, 6-26

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 3-17, 7-2

CONTROL_FILES initialization parameter, 3-27, 6-2, 6-9, 7-2

CREATE CONTROLFILE statement

standby database

effect on, 5-42, 6-26

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 2-15, 5-45, 6-13, 9-1

CREATE TEMPORARY TABLESPACE statement, 4-21

creating

control files, 6-13

standby database files, 2-11

standby databases, 2-9, 2-13, B-13

standby initialization parameter files, 3-30

standby redo log groups and members, 3-44

standby redo log members, 3-44

temporary tablespaces

for read-only standby databases, 4-21

cross-instance archival, 5-47, D-3

standby redo logs and, D-3

data availability modes

configuring, 3-36

data divergence

ARCn process and, 1-14, 5-20

LGWR process and, 1-14, 5-20

on the primary database, 1-14, 1-16, 5-20

Data Guard broker

See Oracle9i Data Guard broker

Data Guard configuration

failover, 1-3

log transport services and, 3-3

data loss, 1-15, 5-21

minimizing, 5-22

on the standby database, 1-14, 1-16, 5-20

database initialization file

setting destination parameters, 3-10

database roles

primary, 1-19, 5-1

standby, 1-19, 5-1

summary, 5-31

transition, 5-2

forced database failover, 5-5

graceful database failover, 5-4

switchback, 5-4

switchover, 5-4

databases

data

intentional loss of, 5-31

primary

gathering redo log archival information, 3-51

setting archive tracing, 3-52

role transition, 5-2

forced database failover, 5-5

graceful database failover, 5-4

switchback, 5-4

switchover, 5-4

standby

control files, 5-42, 5-44

creating procedures for, 2-13, B-13

datafiles, taking offline, 5-42

direct path operations, 5-43

failover to, 5-18

initialization parameters, 2-16, 3-30

managed recovery mode, 2-2, 4-3

manual recovery mode, B-4

read-only mode, 2-2, 4-17

redo log files, altering, 5-41

renaming datafiles, 4-14, 5-41

transmitting archived redo logs, 4-3

datafiles

adding to primary database, 5-40, 6-20, 6-49

deleting, 5-40, 6-25

deleting in a primary database, 5-37

renaming, 4-14, 6-23

effect on standby database, 5-41

DB_FILE_NAME_CONVERT initialization parameter, 3-27, 4-15, 6-2, 6-9, 7-2

DB_FILES initialization parameter, 3-27, 6-9, 7-2

DB_NAME initialization parameter, 3-27, 6-9, 7-3

DBA_DATA_FILES view, 5-37

DBA_TABLESPACES view, 5-36

DBSNMP process, 5-17

DELAY option

LOG_ARCHIVE_DEST_n initialization parameters, 3-25, 6-52, 8-12

of managed recovery mode, 4-7, 9-3

delayed protection, 1-17

log transport services data availability modes, 1-17, 3-35

deleting

datafiles, 5-37, 5-40, 6-25

redo logs, 5-41

DEPENDENCY option

LOG_ARCHIVE_DEST_n initialization parameters, 3-24, 8-14

destinations

archived redo logs, 3-19 to 3-26

log transport services, 3-2, 3-4

specifying dependency, 3-24

direct path operations

standby databases, 5-43

directory structure

of standby database, 2-5

disabling the archived redo log operation, 5-28

disaster recovery preparation

ReadMe file at standby site, 6-33

DISCONNECT option

of managed recovery mode, 4-7, 6-21, 9-4

DROP LOGFILE clause

of ALTER DATABASE, 9-1

DROP LOGFILE MEMBER clause

of ALTER DATABASE, 9-2

dropping

online redo logs, 6-25

tablespaces, 5-37, 5-40, 6-25, 6-27

dynamic parameters

AQ_TM_PROCESSES, 5-17

JOB_QUEUE_PROCESSES, 5-17

dynamic performance views, 5-33, 10-2

See also views

ENABLE option

LOG_ARCHIVE_DEST_n, 6-8

LOG_ARCHIVE_DEST_STATE_n initialization parameters, 3-21, 6-8

EXPIRE option

of managed recovery mode, 4-8, 9-3

failover, 1-20

data loss, 1-15, 5-21

forced, 5-5

graceful, 5-4, 5-23

in multiple standby databases

configuration, 6-31

minimal-data-loss, 5-25

no-data-loss, 1-15, 5-21, 5-24

planning for, 5-22

to standby database, 5-18

initiating, 5-29

FAILOVER option

Oracle Names Server, 6-40

TNS names, 6-40

failure resolution policies

log transport services, 3-6, 3-22, 3-46

FAL client, 3-3

FAL server, 3-3

FAL_CLIENT initialization parameter, 3-28, 4-13, 6-9, 7-3

FAL_SERVER initialization parameter, 3-28, 4-13, 6-9, 7-3

features, new, xxix

fetch archive log client, 3-3

fetch archive log server, 3-3

FINISH option

of managed recovery mode, 4-8, 5-24, 9-4

fixed views, 5-33, 10-1

See also views

forced database failover, 5-5

See also failover

global dynamic performance views, 5-33, 10-2

See also views

graceful database failover, 5-4, 5-23

minimal-data-loss, 5-25

no-data-loss, 5-24

See also failover

guaranteed protection

log transport services data availability modes, 1-16, 3-34

GV$ fixed views, 5-33, 10-2

See also views

GV$INSTANCE view, 5-15

initialization parameter files

configuring, 2-16, 3-27, 3-30, 6-6, 6-16, 6-19

on the primary database, 5-7

on the standby database, 5-7

initialization parameters, 7-1

ARCHIVE_LAG_TARGET, 7-2

changing at runtime, 3-12

COMPATIBLE, 3-27, 6-9, 7-2

configuring standby databases, 3-27

CONTROL_FILE_RECORD_KEEP_TIME, 3-17, 7-2

CONTROL_FILES, 3-27, 6-2, 6-9, 7-2

DB_FILE_NAME_CONVERT, 3-27, 4-15, 6-2, 6-9, 7-2

DB_FILES, 3-27, 6-9, 7-2

DB_NAME, 3-27, 6-9, 7-3

FAL_CLIENT, 3-28, 4-13, 6-9, 7-3

FAL_SERVER, 3-28, 4-13, 6-9, 7-3

LOCK_NAME_SPACE, 3-28, 6-2, 6-9, 7-3, A-4

LOG_ARCHIVE_DEST, 3-45, 7-6, B-4

LOG_ARCHIVE_DEST_1, 3-28, 3-46, 7-3

LOG_ARCHIVE_DEST_n, 3-7, 6-7, 6-8, 6-10, 7-3, 8-1 to 8-35, B-4, C-3

LOG_ARCHIVE_DEST_STATE_n, 3-9, 7-3

LOG_ARCHIVE_FORMAT, 3-28, 3-45, 6-8, 7-4

LOG_ARCHIVE_MAX_PROCESSES, 7-4

LOG_ARCHIVE_MIN_SUCCEED_DEST, 3-21, 7-4, 8-19

LOG_ARCHIVE_START, 3-28, 7-4

LOG_ARCHIVE_TRACE, 3-28, 3-52, 4-25, 7-4

LOG_FILE_NAME_CONVERT, 3-29, 4-15, 6-2, 6-10, 7-5

REMOTE_ARCHIVE_ENABLE, 3-19, 3-29, 7-5

SORT_AREA_SIZE, 4-22, 7-5

STANDBY_ARCHIVE_DEST, 3-29, 3-45, 6-10, 7-6

STANDBY_FILE_MANAGEMENT, 3-29, 4-15, 4-16, 5-41, 6-20, 7-6

USER_DUMP_DEST, 4-25, 7-6

instant protection, 1-16

log transport services data availability modes, 3-35

JOB_QUEUE_PROCESSES dynamic parameter, 5-17

LGWR option

LOG_ARCHIVE_DEST_n initialization parameters, 3-36, 3-47, 8-10

LGWR process, 3-3, C-1

listener.ora file

configuring for standby database, 5-8, 6-5, 6-14

log transport services tuning and, 3-49

LOCATION option

LOG_ARCHIVE_DEST_n initialization parameters, 3-21, 3-24, 6-7, 8-17

LOCK_NAME_SPACE initialization parameter, 3-28, 6-2, 6-9, 7-3, A-4

log apply services, 1-9, 4-1 to 4-28

initiating, 4-4

introduction, 4-1

monitoring, 4-22

log transport services, 1-8, 3-1 to 3-52

archive destinations

specifying quotas for, 3-26

archived redo logs

confirming successful disk write, 3-39

specifying filenames and locations on the standby database, 3-45

ARCHIVELOG mode, 3-15

capabilities of, 3-3

configuring data availability modes, 3-36

configuring on the primary database, 3-14

configuring on the standby database, 2-16, 3-26, 3-30

data availability modes, 3-32 to 3-34

destinations, 3-2, 3-4

failure resolution policies, 3-6

interfaces to, 3-6 to 3-14

minimal data loss, 3-34

monitoring, 3-50

network tuning, 3-49

no data divergence, 3-33

no data loss, 3-33, 3-34, 3-37, 3-46

NOARCHIVELOG mode, 3-15

overview, 3-2

permission, 3-4

protected mode, 3-46

re-archiving to failed destinations, 3-22

reception, 3-5

setting failure resolution policies, 3-46

setting primary database initialization parameters, 3-14

specifying alternate destinations for archiving, 3-23

specifying storage locations for standby redo logs, 3-46

SQL interface, 3-12

transmission, 3-5

unprotected mode, 3-46

using Oracle Net with, 3-2

log transport services data availability modes

delayed protection, 1-17, 3-35

guaranteed protection, 1-16, 3-34

instant protection, 1-16, 3-35

rapid protection, 1-17, 3-35

log writer process, 3-3

asynchronous network I/O and, C-1

LOG_ARCHIVE_DEST initialization parameter, 3-9, 7-6, B-4

LOG_ARCHIVE_DEST_1 initialization parameter, 3-28, 3-46, 7-3

LOG_ARCHIVE_DEST_n initialization parameters, 3-7, 3-20, 3-46, 6-8, 6-10, 7-3, 8-1 to 8-35, B-4, C-3

AFFIRM option, 3-39, 3-47, 8-3

ALTERNATE option, 3-23, 8-5

ARCH option, 3-36, 3-47, 8-10

ASYNC option, 3-37, 3-47, 8-33

DELAY option, 3-25, 4-7, 6-52, 8-12

DEPENDENCY option, 3-24, 8-14

LGWR option, 3-36, 3-47, 8-10

LOCATION option, 3-21, 3-24, 6-7, 8-17

MANDATORY option, 3-20, 3-21, 6-32, 8-19

MAX_FAILURE option, 3-23, 8-21

NOAFFIRM option, 3-39, 3-47, 8-3

NOALTERNATE option, 3-23, 8-5

NODELAY option, 3-25, 8-12

NODEPENDENCY option, 8-14

NOMAX_FAILURE option, 3-23, 8-21

NOQUOTA_SIZE option, 8-23

NOQUOTA_USED option, 8-26

NOREGISTER option, 8-28

NOREOPEN option, 3-22, 8-31

option compatibility, 8-35

OPTIONAL option, 3-21, 6-8, 6-32, 8-19

QUOTA_SIZE option, 3-26, 8-23

QUOTA_USED option, 8-26

REGISTER option, 8-28

REGISTER=location_format option, 3-25, 8-30

REOPEN option, 3-20, 3-22, 6-8, 8-31

SERVICE option, 3-20, 6-8, 8-17

specifying destinations using, 3-20, 6-7, 6-8

SYNC option, 3-37, 3-39, 3-47, 8-33

LOG_ARCHIVE_DEST_STATE_n initialization parameters, 3-9, 7-3

ALTERNATE option, 3-10

DEFER option, 3-10, 6-44

ENABLE option, 3-10, 3-21, 6-8, 6-44

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 3-9

LOG_ARCHIVE_FORMAT initialization parameter, 3-28, 3-45, 6-8, 7-4

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 7-4

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 3-21, 7-4, 8-19

LOG_ARCHIVE_START initialization parameter, 3-28, 7-4

LOG_ARCHIVE_TRACE initialization parameter, 3-28, 3-52, 4-25, 7-4

LOG_FILE_NAME_CONVERT initialization parameter, 3-29, 4-15, 6-2, 6-10, 7-5

managed recovery

in background mode, 4-7

in foreground session, 4-4

of standby databases, 2-9

canceling, 4-6

monitoring, 4-5, 4-22

preparing for, 2-9

managed recovery mode

managed recovery process (MRP) and, 4-2, 4-7, 5-25

standby databases, 2-2, 4-3

CANCEL IMMEDIATE option, 9-3

CANCEL option, 4-6, 5-44, 6-27, 9-3

DELAY option, 4-7, 9-3

DISCONNECT option, 4-7, 6-21, 9-4

EXPIRE option, 4-8, 9-3

FINISH option, 4-8, 9-4

NEXT option, 4-9, 9-5

NODELAY option, 4-9, 6-55, 9-4, 9-5

PARALLEL option, 4-10, 4-24, 9-4, 9-5

starting, 4-4, 6-11

TIMEOUT option, 4-11, 6-11, 9-2

managed recovery process (MRP)

See managed recovery mode

MANDATORY option

LOG_ARCHIVE_DEST_n initialization parameters, 3-20, 3-21, 6-32, 8-19

manual network configuration, 6-41

manual recovery

of standby databases, B-1

preparing for, B-1

manual recovery mode

initiating, B-3

when is it required, B-5

manually propagating unrecoverable operations, 5-43

MAX_FAILURE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-23, 8-21

minimal data loss, 3-34

log transport services, 3-34

setting up the environment for, 3-34

monitoring

log apply services, 4-5, 4-22

log transport services, 3-50

monitoring standby databases, 5-33

MOUNT clause

of ALTER DATABASE, 5-45, 9-2, B-4

MRP

See managed recovery mode

multiple standby databases

failing over to one, 6-31

network configuration

manual, 6-41

network failures

identifying, 6-43

network files

configuring, 2-11, 6-4, 6-14

network server processes

achieving asynchronous network I/O, C-2

network tuning

log transport services, 3-49

new features, xxix

NEXT option

of managed recovery mode, 4-9, 9-5

no data divergence, 1-16

log transport services, 3-33

setting up the environment for, 3-33

no data loss, 1-15, 3-33, 3-34, 3-37, 3-46, 5-21

log transport services, 3-33

setting up the environment for, 3-33

NOAFFIRM option

LOG_ARCHIVE_DEST_n initialization parameters, 3-47, 8-3

NOALTERNATE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-23, 8-5

NOARCHIVELOG mode

log transport services, 3-15

NODELAY option

LOG_ARCHIVE_DEST_n initialization parameters, 3-25, 8-12

of managed recovery mode, 4-9, 6-55, 9-4, 9-5

NODEPENDENCY option

LOG_ARCHIVE_DEST_n initialization parameters, 8-14

NOLOGGING clause, 6-28, 6-50

NOMAX_FAILURE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-23, 8-21

NOQUOTA_SIZE option

LOG_ARCHIVE_DEST_n initialization parameters, 8-23

NOQUOTA_USED option

LOG_ARCHIVE_DEST_n initialization parameters, 8-26

NOREGISTER option

LOG_ARCHIVE_DEST_n initialization parameters, 8-28

NOREOPEN option

LOG_ARCHIVE_DEST_n initialization parameters, 3-22, 8-31

offline

taking standby database datafiles, 5-42

online redo logs

adding, 6-25

clearing, 5-45

configuration considerations for, 3-15

dropping, 6-25

OPEN READ ONLY clause

of ALTER DATABASE, 4-19, 9-2

OPEN RESETLOGS clause

of ALTER DATABASE, 6-28

operational requirements

standby database, 1-6

option compatibility

LOG_ARCHIVE_DEST_n initialization parameters, 8-35

OPTIONAL option

LOG_ARCHIVE_DEST_n initialization parameters, 3-21, 6-8, 6-32, 8-19

Oracle Names server, 6-40

Oracle Net Manager

configuring the listener, 4-13

creating a net service name, 4-13

resolving archive gaps, 4-13

Oracle9i Data Guard broker

definition, 1-7

introduction, 1-5

Oracle9i Data Guard command-line interface

introduction, 1-5

Oracle9i Data Guard Manager

introduction, 1-5

PARALLEL option

of managed recovery mode, 4-10, 4-24, 9-4, 9-5

parallel recovery

on standby database, 4-10, 4-24, 9-4, 9-5

permission

log transport services, 3-4, 3-19

primary databases

backing up from standby databases, 5-32, 6-56

configuring log transport services on, 3-14

datafiles

adding, 5-40, 6-20

backing up, 6-3

deleting, 5-40, 6-25

renaming, 5-41, 6-23

definition, 1-7

initialization parameter file, 5-7

Real Application Clusters and

setting up, D-3

setting failure resolution policy for, 3-46

switching to standby role, 5-9

tablespaces

adding, 5-40

dropping, 5-40

processes

archiver, 3-3

log writer, 3-3

protected mode, 3-46

protection levels

delayed, 1-14, 1-17, 3-35, 5-20

guaranteed, 1-14, 1-16, 3-34, 5-20

instant, 1-14, 1-16, 3-35, 5-20

rapid, 1-14, 1-17, 3-35, 5-20

setting, 3-46

See also failure resolution policies

QMN0 process, 5-17

QUOTA_SIZE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-26, 8-23

QUOTA_USED option

LOG_ARCHIVE_DEST_n initialization parameters, 8-26

rapid protection, C-1

log transport services data availability modes, 1-17, 3-35

read-only mode

standby databases, 2-2, 4-2, 4-17

Real Application Clusters, 1-9, D-1

performing switchover and, 5-8

primary databases and, D-3

standby databases and, 5-46, D-3

reception

log transport services, 3-5, 3-40

RECOVER MANAGED STANDBY DATABASE clause, 4-4

of ALTER DATABASE, 5-12, 9-2

CANCEL IMMEDIATE option, 4-6, 9-3

CANCEL NOWAIT option, 4-6

CANCEL option, 4-6 to ??, 4-6, 9-3

DELAY option, 4-7, 9-3

DISCONNECT FROM SESSION option, 4-7

DISCONNECT option, 4-7, 9-4

EXPIRE option, 4-8, 9-3

FINISH NOWAIT option, 4-8

FINISH option, 4-8, 5-4, 5-24, 9-4

NEXT option, 4-9, 9-5

NODELAY option, 4-10, 9-4, 9-5

PARALLEL option, 4-11, 9-4, 9-5

TIMEOUT option, 4-12, 6-11, 9-2

RECOVER STANDBY DATABASE clause

of ALTER DATABASE, 9-2

recovery

from network failure, 6-43

redo logs

adding, 5-41

applying on standby database, 2-4

archive gap management of, 4-12

archiving to standby database, 2-3

clearing, 5-42, 5-45

deleting, 5-41

receiving and storing on standby database, 3-40

resetting, 5-42

setting permission to archive, 3-19

transmitting, 3-5

See also archived redo logs

See also online redo logs

See also standby redo logs

refreshing

standby database control files, 5-44, 6-26

REGISTER LOGFILE clause

of ALTER DATABASE, 5-18, 9-2

REGISTER option

LOG_ARCHIVE_DEST_n initialization parameters, 8-28

REGISTER=location_format option

LOG_ARCHIVE_DEST_n initialization parameters, 3-25, 8-30

REMOTE_ARCHIVE_ENABLE initialization parameter, 3-19, 3-29, 7-5

RENAME FILE clause

of ALTER DATABASE, 4-16, B-14

renaming

datafiles, 5-41, 6-23

automatically, 4-14

manually, B-13

standby database datafiles, 4-14

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameters, 3-20, 3-22, 6-8, 8-31

RESETLOGS parameter

of ALTER DATABASE, B-8

revert

from standby to primary role, 5-18

role management services, 1-10

role transition, 1-10, 5-2

forced database failover, 5-5

graceful database failover, 5-4

switchback, 5-4

switchover, 5-4

rolling upgrade

during switchover, 5-7

SERVICE option

LOG_ARCHIVE_DEST_n initialization parameters, 3-20, 6-8, 8-17

SET STANDBY DATABASE clause

of ALTER DATABASE, 3-46, 3-47, 5-29, 9-2

SORT_AREA_SIZE initialization parameter, 4-22, 7-5

SQL session access

during switchover, 5-8

SQL statements

ALTER DATABASE, 3-44, 3-46, 5-4, 5-5, 5-10, 5-12, 5-18, 5-29, 5-42, 5-45, 9-1

restrictions, 4-16

ALTER SESSION, 3-12

ALTER SYSTEM, 3-12

CREATE CONTROLFILE, 5-42

CREATE TEMPORARY TABLESPACE, 4-21

relating to standby database, 9-1

SQL*Plus commands

ARCHIVE LOG LIST, 2-14, 6-13

standby database

initialization parameter file, 6-16

standby database files

creating, 2-11

standby databases

activating, 5-18

altering control files, 5-42, 6-26

archived redo logs

transmitting, 4-3

configuration of environment, 2-1

configuration options, 1-18

cross-instance archival, 1-9

delayed standby, 1-18, 3-25, 6-52

configuring, 3-27

control files

altering, 6-26

copying, 2-16

creating, 2-13, 6-13

refreshing, 5-44, 6-26

creating, 2-9

on remote host, 6-12

on same host, 6-2

procedures, 2-13, B-13

datafiles

automating creation of, 6-20

manual creation of, 6-21

renaming, 4-14, 5-41

taking offline, 5-42

data-loss failover, 1-15, 5-21

direct path operations, 5-43

directory structure, 2-5

failing over to one of many, 6-31

failover to, 5-18

initialization parameter file, 5-7

initialization parameters, 2-16, 3-30, 6-9

invalidating, B-8

managed recovery mode, 2-2, 4-3, 6-11

manual recovery mode

procedures, B-4

maximum number of, 2-2

monitoring, 5-33

no-data-loss failover, 1-15, 5-21

operational requirements, 1-6

parallel recovery, 4-10

read-only mode, 2-2, 4-17

Real Application Clusters and, 5-46

setting up, D-3

re-creating, 6-45

redo log files

altering, 5-41

renaming datafiles automatically, 4-14

starting the standby instance, 4-4

statements and commands, 9-1

switching to primary role, 5-11

transmitting archived redo logs, 4-3

with a time lag, 1-18

bypassing, 6-55

creating, 3-25, 6-52

managing, 6-53

rolling back database, 6-55

with no ongoing recovery, 6-48

standby initialization parameter files

creating, 3-30

standby redo log groups

creating, 3-43

standby redo logs

creating, 3-42

creating log groups and members, 3-44

creating redo log members, 3-44

introduction, 3-5, 3-41

specifying storage locations for, 3-46

STANDBY_ARCHIVE_DEST initialization parameter, 3-29, 3-45, 6-10, 7-6

STANDBY_FILE_MANAGEMENT initialization parameter, 3-29, 4-15, 4-16, 5-41, 6-20, 7-6

starting

standby instances, 4-4

STARTUP NOMOUNT statement, 9-5

switchback, 1-23, 5-4

See also switchover

switchover, 1-20, 1-22, 5-4, 5-6, 6-36

configuring, 6-36

database access and, 5-9

from primary to standby role, 5-4, 5-9, 6-36

from standby to primary role, 5-4, 5-11

multiple standby databases, 5-14

performing a rolling upgrade and, 5-7

primary control file conversion, 5-6

processes that prevent, 5-17

CJQ0, 5-17

DBSNMP, 5-17

QMN0, 5-17

setting up log transport services, 5-7

SQL session access and, 5-8

standby control file conversion, 5-6

standby databases not involved in, 5-14

using Real Application Clusters and, 5-8

validating transition, 5-17

verifying status, 5-9, 5-12

SYNC option

LOG_ARCHIVE_DEST_n initialization parameters, 3-37, 3-39, 3-47, 8-33

tablespaces

adding to primary database

effect on standby, 5-40

creating temporary, 4-21

dropping, 5-37, 5-40, 6-25, 6-27

sorting without, 4-21

TAF

See transparent application failover

time lag

in standby database, 1-18, 3-25, 6-52 to 6-56, 8-12

when applying redo logs to standby databases, 8-12

TIMEOUT option

of managed recovery mode, 4-11, 6-11, 9-2

TNS name settings

FAILOVER option, 6-40

tnsnames.ora file

configuring, 5-8, 6-39, 6-41

log transport services tuning and, 3-49

trace files

location of, 4-25

transmission modes, 3-38

ASYNC, 3-37

SYNC, 3-37

transmitting

archived redo logs, 4-3

redo logs, 3-5

transparent application failover, 6-40

unprotected mode, 3-46

UNRECOVERABLE operations, 5-43, 6-28

backups after, 5-44

unrecoverable operations

propagating manually, 5-43

USER_DUMP_DEST initialization parameter, 4-25, 7-6

V$ARCHIVE_DEST view, 3-12, 3-51, 5-33, 6-44, 10-3, A-2

V$ARCHIVE_DEST_STATUS view, 3-51, 4-5, 4-23, 5-34, 10-6

V$ARCHIVE_GAP view, 5-34, 6-50, 10-8, B-9

V$ARCHIVED_LOG view, 3-45, 3-51, 4-24, 5-17, 5-34, 6-50, 10-9, B-10

V$DATABASE view, 2-14, 5-9, 5-12, 5-18, 5-34, 10-11

V$DATAFILE view, 5-34, 5-44, 6-12, 6-29, 10-13

V$LOG view, 3-51, 5-34, 6-22, 10-15

V$LOG_HISTORY view, 4-24, 5-35, 5-38, 10-17

V$LOGFILE view, 5-34, 10-16

V$MANAGED_STANDBY view, 4-5, 4-23, 5-35, 6-22, 10-18

V$RECOVER_FILE view, 5-36, 5-37

V$SESSION view, 5-15, A-3

V$STANDBY_LOG view, 5-35, 10-21

V$SYSSTAT view, 3-18

V$THREAD view, 5-36

views

DBA_DATA_FILES, 5-37

DBA_TABLESPACES, 5-36

GV$INSTANCE, 5-15

V$ARCHIVE_DEST, 3-12, 3-51, 5-33, 6-44, 10-3, A-2

V$ARCHIVE_DEST_STATUS, 3-51, 4-5, 4-23, 5-34, 10-6

V$ARCHIVE_GAP, 5-34, 6-50, 10-8, B-9

V$ARCHIVED_LOG, 3-45, 3-51, 4-24, 5-17, 5-34, 6-50, 10-9, B-10

V$DATABASE, 2-14, 5-9, 5-12, 5-18, 5-34, 10-11

V$DATAFILE, 5-34, 5-44, 6-12, 6-29, 10-13

V$LOG, 3-51, 5-34, 6-22, 10-15

V$LOG_HISTORY, 4-24, 5-35, 5-38, 10-17

V$LOGFILE, 5-34, 10-16

V$MANAGED_STANDBY, 4-5, 4-23, 5-35, 6-22, 10-18

V$RECOVER_FILE, 5-36, 5-37

V$SESSION, 5-15, A-3

V$STANDBY_LOG, 5-35, 10-21

V$SYSSTAT, 3-18

V$THREAD, 5-36