Oracle8
i
Standby Database Concepts and Administration
Release 2 (8.1.6)
A76995-01
Library
Product
Contents
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
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents