Index
A
B
C
D
E
F
G
I
J
L
M
N
O
P
Q
R
S
T
U
V
A
- 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
B
- 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
C
- 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
D
- 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
E
- 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
F
- 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
G
- 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
I
- 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
J
- JOB_QUEUE_PROCESSES dynamic parameter, 5-17
L
- 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
M
- 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
N
- 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
O
- 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
P
- 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
Q
- 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
R
- 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
S
- 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
T
- 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
U
- 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
- 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