Index

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

---

A

activating

standby databases, 1-12, 3-20

consequences, 1-14

adding

datafiles, 4-10, 5-22, 5-47

redo logs, 4-12, 5-25

ALTER DATABASE statement, 1-28

CLEAR LOGFILE GROUP clause, 4-16

CLEAR UNARCHIVED LOGFILE clause, 4-12, 5-28

CREATE STANDBY CONTROLFILE clause, 4-15, 5-15

DATAFILE OFFLINE DROP clause, 4-13

ENABLE THREAD clause, 4-12

MOUNT STANDBY DATABASE clause, 3-4, 4-15

OPEN READ ONLY clause, 3-18, 3-19, 4-17

OPEN RESETLOGS clause, 5-28

RESETLOGS parameter, 3-7

ALTER SYSTEM statement

ARCHIVE LOG CURRENT clause, 3-21, 5-42

SWITCH LOGFILE clause, 4-11

altering

control files, 4-12, 5-26

archive destinations, 2-17, 5-31

MANDATORY, 5-31

OPTIONAL, 5-32

ARCHIVE LOG CURRENT clause

ALTER SYSTEM statement, 3-21, 5-42

archive tracing

and standby databases, 4-6

archived redo logs

accessing information about, 4-5, 4-9

and standby databases, 4-5

checking status of, 1-26

destination states, 2-18

destinations

re-archiving to failed, 2-18

multiplexing, 2-16, 5-7

transmitting, 3-13

archiving

destination states, 2-18

to failed destinations, 2-18

---

B

backing up

standby databases, 4-16

tablespaces on a standby database, 4-17

backups

after UNRECOVERABLE operations, 4-14

creating standby database from, 1-20

cumulative incremental, 3-6, 3-14, 3-23

of primary database, 1-20

of standby database, 4-16

---

C

CLEAR LOGFILE GROUP clause

ALTER DATABASE statement, 4-16

CLEAR UNARCHIVED LOGFILE clause

ALTER DATABASE statement, 4-12, 5-28

clearing online logs

implication for standby databases, 4-16

client application failover

configuring, 5-36

commands

standby database, 1-28

COMPATIBLE initialization parameter, 5-9

configuration

of standby environment, 1-19

configuration options

standby databases, 1-2

configuring

client application failover, 5-36

initialization parameter file, 5-6, 5-8, 5-17, 5-19

listener.ora file, 5-5

network files, 2-27, 5-4

tnsnames.ora file, 5-4

control files

altering, 4-12, 5-26

CONTROL_FILES initialization parameter

for primary and standby databases, 2-19

creating, 2-8, 5-15

effect on standby databases, 4-12

refreshing standby database, 4-15, 5-26

CONTROL_FILES initialization parameter, 2-19, 5-2, 5-9

CREATE CONTROLFILE statement

standby database, effect on, 4-12, 5-26

CREATE STANDBY CONTROLFILE clause

ALTER DATABASE statement, 4-15

creating

control files, 5-15

datafiles, 5-22

standby databases, 2-8, 2-12, 2-13, 2-14, 2-32

overview, 1-16

---

D

databases

altering physical structure

standby databases, effect on, 1-27

standby

advantages, 1-2

control files, 4-12, 4-15

creating, procedures for, 2-8, 2-12, 2-13, 2-14, 2-32

datafiles, taking offline, 4-13

direct path operations, 4-13

failover to, 1-12, 1-14, 3-20

initialization parameters, 2-19

manual recovery mode, 1-8, 2-31, 3-4

read-only mode, 1-10, 3-17

redo log files, altering, 4-12

renaming datafiles, 4-11

sustained recovery mode, 1-9

transmitting archived redo logs, 3-13

DATAFILE OFFLINE DROP clause

ALTER DATABASE statement, 4-13

datafiles

adding to primary database, 4-10, 5-22, 5-47

creating, 5-22

deleting, 5-25

renaming, 5-24

effect on standby database, 4-11

DB_FILE_NAME_CONVERT initialization parameter, 2-20, 2-21, 5-2, 5-9

for primary and standby databases, 2-19

DB_FILES initialization parameter, 5-9

DB_NAME initialization parameter, 5-9

deleting

datafiles, 5-25

tablespaces, 5-25

destination states for archived redo logs, 2-18

direct path operations

standby databases, 4-13

---

E

ENABLE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-8

ENABLE THREAD clause

ALTER DATABASE statement, 4-12

---

F

failover

to standby database, 1-12, 1-19, 2-4, 3-20

connection method, 2-4

consequences, 1-14

---

G

gap sequences

applying the logs to standby database, 3-12, 5-13, 5-20

causes of, 3-5

copying the logs in, 3-10, 5-12

description, 1-17

identifying the logs in, 3-9, 5-11, 5-42

preventing, 3-7

---

I

initialization parameter files

configuring, 2-27, 5-6, 5-8, 5-9, 5-17, 5-19

initialization parameters

COMPATIBLE, 5-9

CONTROL_FILES, 2-19, 5-2, 5-9

for primary and standby databases, 2-19

DB_FILE_NAME_CONVERT, 2-20, 2-21, 5-2, 5-9

for primary and standby databases, 2-19

DB_FILES, 5-9

DB_NAME, 5-9

for primary and standby databases, 2-19

LOCK_NAME_SPACE, 5-2, 5-9

LOG_ARCHIVE_DEST, 3-4

LOG_ARCHIVE_DEST_n, 3-4, 5-7, 5-9

LOG_ARCHIVE_DEST_STATE_n, 2-18

LOG_ARCHIVE_FORMAT, 5-7

LOG_ARCHIVE_START, 5-18

LOG_ARCHIVE_TRACE, 4-6

LOG_FILE_NAME_CONVERT, 5-2, 5-18

STANDBY_ARCHIVE_DEST, 2-21, 5-9

USER_DUMP_DEST, 4-6

---

L

life cycle

of a standby database, 1-16

LISTENER.ORA file

configuring, 2-11, 2-13, 5-5

format, 5-5, 5-16

LOCK_NAME_SPACE initialization parameter, 5-2, 5-9

LOG_ARCHIVE_DEST initialization parameter, 3-4

LOG_ARCHIVE_DEST_n initialization parameter, 3-4, 5-8, 5-9

ENABLE option, 5-8

MANDATORY option, 2-17

OPTIONAL option, 2-17, 5-8

REOPEN option, 2-18, 5-8

SERVICE option, 5-8

specifying destinations using, 5-7, 5-8

LOG_ARCHIVE_FORMAT initialization parameter, 5-7

LOG_ARCHIVE_START initialization parameter, 5-18

LOG_ARCHIVE_TRACE initialization parameter, 4-6

LOG_FILE_NAME_CONVERT initialization parameter, 5-2, 5-18

---

M

maintenance

standby database

overview, 1-26

managed recovery

of standby databases, 2-5, 3-13

canceling, 3-16

preparing for, 2-5

starting, 3-14

managed recovery mode, 1-21, 3-13

MANDATORY option

LOG_ARCHIVE_DEST_n initialization parameter, 2-17

manual recovery

of standby databases, 1-17, 2-6

preparing for, 2-6

manual recovery mode, 1-8

monitoring standby databases, 4-2

MOUNT STANDBY DATABASE clause

ALTER DATABASE statement, 3-4, 4-15

multiplexing

archived redo logs, 2-16, 5-7

---

N

network files

configuring, 2-27, 5-4

networks

failure of, 5-40

new features in 8.1.5

standby databases, xiii

new features in 8.16

standby databases, xiii

NOLOGGING clause, 5-28, 5-48

---

O

offline

taking standby database datafiles, 4-13

OPEN READ ONLY clause

ALTER DATABASE statement, 3-18, 3-19, 4-17

OPEN RESETLOGS clause

ALTER DATABASE statement, 5-28

OPTIONAL option

LOG_ARCHIVE_DEST_n initialization parameter, 2-17, 5-8

Oracle Parallel Server (OPS)

and standby databases, 3-22

---

P

preparation

standby database, 2-2

---

R

read-only mode

standby databases, 1-10, 3-17

RECOVER statement

FROM 'location' clause, 4-15

specifying the TIMEOUT option, 5-13

recovery

from network failure, 5-40

redo logs

adding, 4-12, 5-25

clearing, 4-12, 4-16

removing, 4-12, 5-25

resetting, 4-12

refreshing

standby database control file, 4-15, 5-26

removing

redo logs, 5-25

renaming

datafiles, 4-11, 5-24

automatically, 2-21

manually, 2-31

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 2-18, 5-8

RESETLOGS parameter

ALTER DATABASE statement, 3-7

---

S

SERVICE option

LOG_ARCHIVE_DEST_n initialization parameter, 5-8

SQL statements

ALTER DATABASE, 1-28, 4-12, 4-16

ALTER SYSTEM, 4-11

CREATE CONTROLFILE, 4-12

relating to standby database, 1-28

standby databases

activating, 1-12, 1-19, 3-20

advantages, 1-2

altering control files, 4-12, 5-26

archived redo logs

transmitting, 3-13

backing up, 4-16

commands, 1-28

configuration of environment, 1-19, 2-2

configuration options, 1-2

control files

altering, 5-26

creating, 2-8, 5-15

refreshing, 4-15, 5-26

creating

on remote host, 5-14

on same host, 5-2

procedures, 2-8, 2-12, 2-13, 2-14, 2-32

datafiles

creating, 4-10

renaming, 4-11

taking offline, 4-13

description, 1-2

direct path operations, 4-13

effect of altering primary database, 1-27

failover to, 1-12, 3-20

initialization parameters, 2-19, 5-9

invalidating, 3-7

managed recovery mode, 1-9, 3-13

manual recovery mode, 1-8

procedures, 2-31, 3-4

monitoring, 4-2

new features in 8.1.5, xiii

new features in 8.1.6, xiii

preparation for creating, 2-2

read-only mode, 1-10, 3-17

re-creating, 5-44

redo log files

altering, 4-12

responding to changes that affect, 4-9

sustained recovery mode, 1-9

testing, 1-15

transmitting archived redo logs, 3-13

with a time lag

bypassing, 5-56

creating, 5-52

managing, 5-54

rolling back database, 5-55

with no ongoing recovery, 5-46

STANDBY_ARCHIVE_DEST initialization parameter, 2-21, 5-9

sustained recovery mode, 1-9

SWITCH LOGFILE clause

ALTER SYSTEM statement, 4-11

---

T

tablespaces

adding to primary database

effect on standby, 4-10

backing up on a standby database

in read-only mode, 4-17

when shut down, 4-17

deleting, 5-25

TAF

See transparent application failover

testing

standby databases, 1-15

time lag

in standby database, 5-52 to 5-56

TNSNAMES.ORA file, 2-17

configuring, 2-11, 2-12, 5-4

format, 5-5, 5-16

trace files

location of, 4-6

transmitting archived redo logs, 3-13

transparent application failover, 5-37

---

U

UNRECOVERABLE operations, 5-28

backups after, 4-14

USER_DUMP_DEST initialization parameter, 4-6

---

V

V$ARCHIVE_DEST view, 2-33, 5-41

V$ARCHIVED_LOG view, 2-24, 4-5, 5-21, 5-43

V$DATABASE view, 2-9

V$DATAFILE view, 4-14, 5-14, 5-23

V$INSTANCE view, 3-15

V$LOG_HISTORY view, 1-26, 3-16, 4-9, 5-11, 5-20

views

V$ARCHIVE_DEST, 2-33, 5-41

V$ARCHIVED_LOG, 2-24, 4-5, 5-21, 5-43

V$DATABASE, 2-9

V$DATAFILE, 4-14, 5-14, 5-23

V$INSTANCE, 3-15

V$LOG_HISTORY, 1-26, 3-16, 4-9, 5-11, 5-20