Index
A B C D E F G H I J L M N O P Q R S T U V
A
- 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
B
- 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
C
- 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
D
- 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
E
- 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
F
- 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
G
- 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
H
- hot backup operations
- copy of the primary database, 4-11
- creating a logical standby database, 4-11
I
- 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
J
- JOB_QUEUE_PROCESSES dynamic parameter, A-7
L
- 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
M
- 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
N
- 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
O
- 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
P
- 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
Q
- 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
R
- 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
S
- 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
T
- 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
U
- 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
- 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