Index

A

ABORT_GLOBAL_INSTANTIATION procedure 8.2.5
ABORT_SCHEMA_INSTANTIATION procedure 8.2.5
ABORT_SYNC_INSTANTIATION procedure 8.2.5
ABORT_TABLE_INSTANTIATION procedure 8.2.5
ADD_TABLE_PROPAGATION_RULES procedure 2.2.6
ADD_TABLE_RULES procedure 2.2.6
ADD SUPPLEMENTAL LOG 1.3.6.2
ADD SUPPLEMENTAL LOG DATA 1.3.6.3
ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1.3.6.5
ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE
- conditional log groups 1.3.6.3
- unconditional log groups 1.3.6.2
alert log
- Streams best practices 15.2.6
ALTER_APPLY procedure 2.2.6
- removing the tag value 10.6.2.2
- setting the tag value 10.1, 10.4, 10.6.2.1
ALTER DATABASE statement
- ADD SUPPLEMENTAL LOG DATA clause 1.3.6.5
- DROP SUPPLEMENTAL LOG DATA clause 1.3.6.6
ALTER TABLE statement
- ADD SUPPLEMENTAL LOG DATA clause
  - conditional log groups 1.3.6.3
  - unconditional log groups 1.3.6.2
- ADD SUPPLEMENTAL LOG GROUP clause
  - conditional log groups 1.3.6.3
  - unconditional log groups 1.3.6.2
- DROP SUPPLEMENTAL LOG GROUP clause 1.3.6.4
ANYDATA data type
- queues
  - creating 6.1
apply process
- apply handlers 1.2.5
- apply user
  - best practices 18.1.1
- best practices
  - configuration 18.2
  - operation 18.3
- conflict resolution 9
- creating 7.1
- data types applied
  - heterogeneous environments 11.1.2.2
- DML changes
  - heterogeneous environments 11.1.2.3
- DML handlers
  - heterogeneous environments 11.1.2.1.5
- error handlers
  - heterogeneous 11.1.2.1.7
- errors
  - best practices 18.2.2, 18.3.1
- heterogeneous environments 11.1.2, 11.2.3
  - database links 11.1.2.1.1
  - Oracle Database Gateways 11.1.2.1.1
- LOBs 14.4.1
- message handlers
  - heterogeneous environments 11.1.2.1.6
- oldest SCN
  - point-in-time recovery 12.6.3
- parallelism
  - best practices 18.2.1
- substitute key columns
  - heterogeneous environments 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
- tags 10.4
  - monitoring 10.7.2
  - removing 10.6.2.2
  - setting 10.6.2.1
- update conflict handlers
  - monitoring 9.8.2
ARCHIVELOG mode 1.3.3
- capture process 5.1.1

B

backups
- online
  - Streams 10.3
- Streams best practices 15.2.4
batch processing
- capture process best practices 16.2.3
best practices
- Streams replication
  - alert log 15.2.6
  - apply 18
  - apply errors 18.2.2, 18.3.1
  - apply process configuration 18.2
  - apply process operation 18.3
  - apply process parallelism 18.2.1
  - apply user 18.1.1
  - archive log threads 15.3.1
  - automate configuration 15.1.2
  - backups 15.2.4
  - batch processing 16.2.3
  - capture 16
  - capture process configuration 16.1
  - capture process operation 16.2
  - capture process parallelism 16.1.2
  - capture process’s queue 15.2.3
  - capture user 16.1.1
  - checkpoint retention 16.1.3
  - conflict resolution 18.1.3
  - database configuration 15.1
  - database operation 15.2
  - data dictionary build 16.2.2
  - DDL replication 1.2.6
  - destination database 18.1
  - global name 15.2.1
  - heartbeat table 16.2.1
  - instantiation SCN 18.1.2
  - Oracle Real Application Clusters (Oracle RAC) databases 15.3
  - performance 15.2.2
  - prepare for instantiation 16.2.2
  - propagation 17
  - propagation latency 17.1.2
  - queue-to-queue propagation 17.1.1
  - removing 15.2.7
  - restarting propagation 17.2.1
  - SDU 17.1.3
  - statistics collection 15.2.5
  - synchronous capture configuration 16.3
bi-directional replication 1.2.3, 1.2.7

C

capture process
- ARCHIVELOG mode 5.1.1
- best practices
  - batch processing 16.2.3
  - configuration 16.1
  - data dictionary build 16.2.2
  - operation 16.2
  - prepare for instantiation 16.2.2
- capture user
  - best practices 16.1.1
- configuring 5
- creating 5.1
- DBID
  - changing 12.4
- downstream capture 1.2.2, 2.2.2.1
  - creating 5.1
- global name
  - changing 12.4
- heterogeneous environments 11.1.1
- local capture 1.2.2, 2.2.2.1
- log sequence number
  - resetting 12.6.1
- parallelism
  - best practices 16.1.2
- parameters
  - merge_threshold 12.3.2.1
  - message_tracking_frequency 12.2
  - split_threshold 12.3.2.1
- preparing for 5.1.1
- supplemental logging 1.3.6, 8.2.3
change cycling
- avoidance
  - tags 10.5
checkpoint retention
- best practices 16.1.3
column lists 9.6.1.2
COMPARE_OLD_VALUES procedure 9.4.1, 9.7.4
COMPARE function 13.3.2, 13.6
- perform_row_dif parameter 13.6.2
comparing database objects 13.6
conflict resolution 9
- best practices 18.1.3
- column lists 9.6.1.2
- conflict handlers 9.3, 9.4, 9.5, 9.6
  - custom 9.6.2
  - modifying 9.7.2
  - prebuilt 9.6.1
  - removing 9.7.3
  - setting 9.7.1
- data convergence 9.6.1.4
- DISCARD handler 9.6.1.1.2
- MAXIMUM handler 9.6.1.1.3
  - latest time 9.6.1.1.3
- MINIMUM handler 9.6.1.1.4
- OVERWRITE handler 9.6.1.1.1
- resolution columns 9.6.1.3
- time-based 9.6.1.1.3
conflicts
- avoidance 9.5
  - delete 9.5.2.2
  - primary database ownership 9.5.1
  - sequences 9.5.2.1
  - uniqueness 9.5.2.1
  - update 9.5.2.3
- delete 9.2.3
- detection 9.4
  - identifying rows 9.4.2
  - monitoring 9.8.1
  - stopping 9.4.1, 9.7.4
- DML conflicts 9.1
- foreign key 9.2.4
- transaction ordering 9.3
- types of 9.2
- uniqueness 9.2.2
- update 9.2.1, 9.2.2, 9.2.3, 9.2.4
CONVERGE procedure 13.3.3, 13.8
CREATE_APPLY procedure 2.2.6, 7.1
- tags 10.1, 10.4
CREATE_CAPTURE procedure 5.1, 5.1.2.2
CREATE_COMPARISON procedure 13.3.2, 13.6
CREATE_PROPAGATION procedure 6.2
CREATE_SYNC_CAPTURE procedure 5.2.3

D

data
- comparing 13.3.2, 13.6
  - custom 13.6.5
  - cyclic 13.6.4
  - purging results 13.10
  - random 13.6.3
  - rechecking 13.9
  - subset of columns 13.6.1
- converging 13.3.3, 13.8
  - session tags 13.8.3
  - tags 13.3.3
database links 1.3.2
databases
- adding for replication 4.2.2, 4.3.2, 4.3.4
data types
- heterogeneous environments 11.1.2.2
DBA_APPLY_CONFLICT_COLUMNS view 9.8.2
DBA_APPLY_INSTANTIATED_OBJECTS view 8.6.2
DBA_APPLY_TABLE_COLUMNS view 9.8.1
DBA_APPLY view 10.7.2
DBA_CAPTURE_PREPARED_DATABASE view 8.6.1
DBA_CAPTURE_PREPARED_SCHEMAS view 8.6.1
DBA_CAPTURE_PREPARED_TABLES view 8.6.1
DBA_COMPARISON_COLUMNS view 13.3.2, 13.7.3
DBA_COMPARISON_ROW_DIF view 13.3.2
DBA_COMPARISON_SCAN_VALUES view 13.7.7
DBA_COMPARISON_SCAN view 13.3.2, 13.7.4, 13.7.5, 13.7.6
DBA_COMPARISON view 13.3.2, 13.7, 13.7.5, 13.7.6
DBA_RECOVERABLE_SCRIPT_BLOCKS view 12.8
DBA_RECOVERABLE_SCRIPT_ERRORS view 12.8
DBA_RECOVERABLE_SCRIPT_PARAMS view 12.8
DBA_RECOVERABLE_SCRIPT view 12.8
DBA_SYNC_CAPTURE_PREPARED_TABS view 8.6.1
DBID (database identifier)
- capture process
  - changing 12.4
DBMS_APPLY_ADM package 1.2.1.3, 2.2.6
DBMS_CAPTURE_ADM package 1.2.1.3, 2.2.6, 5
DBMS_COMPARISON package 13.3.2, 13.3.3
- buckets 13.1.2
- comparing database objects 13.6
  - custom 13.6.5
  - cyclic 13.6.4
  - purging results 13.10
  - random 13.6.3
  - rechecking 13.9
  - subset of columns 13.6.1
- converging database objects 13.8
  - session tags 13.8.3
- monitoring 13.7
- parent scans 13.1.3
- preparation 13.4
- root scans 13.1.3
- scans 13.1.1
- Streams replication 13.12
- using 13
DBMS_PROPAGATION_ADM package 6
DBMS_STREAMS_ADM package 1.1.2, 1.2.1.3, 2.2.6, 5, 6
- creating a capture process 5.1
- creating an apply process 7.1
- creating a propagation 6.2
- preparation for instantiation 8.2.1
- tags 10.2
DBMS_STREAMS package 10.6
DDL replication
- best practices 1.2.6
directory objects 2.2.3
- creating 4.2.2
DISCARD conflict resolution handler 9.6.1.1.2
DML handlers
- LOB assembly 14.4.2
downstream capture 1.2.2, 2.2.2.1
- archived-log 1.2.2
- configuring 2.2.5
- log file transfer 1.3.7
- real-time 1.2.2, 1.3.8
- standby redo logs 1.3.8
DROP_COMPARISON procedure 13.11
DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1.3.6.6
DROP SUPPLEMENTAL LOG GROUP clause 1.3.6.4

E

ENQUEUE procedure 14.2
error handlers
- LOB assembly 14.4.2
error queue
- heterogeneous environments 11.1.5
Export
- Oracle Streams 8.5.1

F

flashback queries
- Streams replication 12.7

G

GET_MESSAGE_TRACKING function 12.2
GET_SCN_MAPPING procedure 12.6.2, 12.7
GET_TAG function 10.6.1.2, 10.7.1
global name
- best practices 15.2.1
- capture process
  - changing 12.4
GRANT_REMOTE_ADMIN_ACCESS procedure 5.1.3.1, 5.1.3.2.1

H

heartbeat table
- Streams best practices 16.2.1
heterogeneous information sharing 11
- non-Oracle to non-Oracle 11.3
- non-Oracle to Oracle 11.2
  - apply process 11.2.3
  - capturing changes 11.2.1
  - instantiation 11.2.4
  - user application 11.2.1
- Oracle to non-Oracle 11.1
  - apply process 11.1.2
  - capture process 11.1.1
  - database links 11.1.2.1.1
  - data types applied 11.1.2.2
  - DML changes 11.1.2.3
  - DML handlers 11.1.2.1.5
  - error handlers 11.1.2.1.7
  - errors 11.1.5
  - instantiation 11.1.2.4
  - message handlers 11.1.2.1.6
  - staging 11.1.1
  - substitute key columns 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
  - transformations 11.1.3
hub-and-spoke replication 1.2.1.2, 1.2.3, 1.2.7, 10.5.2
- configuring 2.2.7

I

Import
- Oracle Streams 8.5.1
- STREAMS_CONFIGURATION parameter 8.3.2.3
initialization parameters
- LOG_ARCHIVE_DEST_n 1.3.4
- LOG_ARCHIVE_DEST_STATE_n 1.3.4
instantiation 2.2.2.6, 8
- aborting preparation 8.2.5
- database 8.4.2
- Data Pump 8.3
- example
  - Data Pump export/import 8.3.3
  - RMAN CONVERT DATABASE 8.4.2.2
  - RMAN DUPLICATE 8.4.2.1
  - RMAN TRANSPORT TABLESPACE 8.4.1
  - transportable tablespace 8.4.1
- heterogeneous environments
  - non-Oracle to Oracle 11.2.4
  - Oracle to non-Oracle 11.1.2.4
- monitoring 8.6
- Oracle Streams 8.5.1
- preparation for 8.2
- preparing for 8.1, 8.2.4
- RMAN 8.4
- setting an SCN 8.5
  - DDL LCRs 8.5.2
  - export/import 8.5.1
- supplemental logging specifications 8.1
instantiation SCN
- best practices 18.1.2
- setting 2.2.6

L

LCRs
- See: logical change records
LOB assembly 14.4.2
LOBs
- Oracle Streams 14.4
  - apply process 14.4.1
LOG_ARCHIVE_DEST_n initialization parameter 1.3.4
LOG_ARCHIVE_DEST_STATE_n initialization parameter 1.3.4
logical change records (LCRs)
- constructing 14.2
- enqueuing 14.2
- executing 14.3
  - DDL LCRs 14.3.2
  - row LCRs 14.3.1
- LOB columns 14.4, 14.5
  - apply process 14.4.1
  - requirements 14.4.3
- LONG columns 14.5
  - requirements 14.5
- LONG RAW columns 14.5
  - requirements 14.5
- managing 14
- requirements 14.1
- tracking 12.2
- XMLType 14.4
log sequence number
- Streams capture process 12.6.1
LONG data type
- Oracle Streams 14.5
LONG RAW data type
- Oracle 14.5

M

MAINTAIN_GLOBAL procedure 2.2, 2.2.4.1
MAINTAIN_SCHEMAS procedure 2.2, 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.7
MAINTAIN_SIMPLE_TTS procedure 2.2, 2.2.5.1
MAINTAIN_TABLES procedure 2.2, 2.2.4.3
MAINTAIN_TTS procedure 2.2, 2.2.5.1
MAXIMUM conflict resolution handler 9.6.1.1.3
- latest time 9.6.1.1.3
MEMORY_MAX_TARGET initialization parameter 1.3.5.1
MEMORY_TARGET initialization parameter 1.3.5.1
MERGE_STREAMS_JOB procedure 12.3.2.2
MERGE_STREAMS procedure 12.3.2.2
merge streams 12.3
message_tracking_frequency capture process parameter 12.2
message tracking 12.2
MINIMUM conflict resolution handler 9.6.1.1.4
monitoring
- apply process
  - update conflict handlers 9.8.2
- comparisons 13.7
- conflict detection 9.8.1
- instantiation 8.6
- tags 10.7
  - apply process value 10.7.2
  - current session value 10.7.1

N

n-way replication 1.2.1.3, 1.2.3, 1.2.7, 10.5.1

O

objects
- adding for replication 4.2.1, 4.3.1, 4.3.3
oldest SCN
- point-in-time recovery 12.6.3
one-way replication 1.2.7
optimizer
- statistics collection
  - best practices 15.2.5
Oracle Database Gateways
- Oracle Streams 11.1.2.1.1
Oracle Data Pump
- Import utility
  - STREAMS_CONFIGURATION parameter 8.3.2.3
- instantiations 8.3.3
- Streams instantiation 8.3
Oracle Real Application Clusters
- Streams best practices 15.3
  - archive log threads 15.3.1
  - global name 15.3.2
  - propagations 15.3.3
  - queue ownership 15.3.4
Oracle Streams
- conflict resolution 9
- DBMS_COMPARISON package 13.12
- Export utility 8.5.1
- heterogeneous information sharing 11
- Import utility 8.5.1
- instantiation 8.1, 8.5.1
- LOBs 14.4
- logical change records (LCRs)
  - managing 14
- LONG data type 14.5
- Oracle Database Gateways 11.1.2.1.1
- point-in-time recovery 12.6
- replication 1
  - adding databases 4.2.2, 4.3.2, 4.3.4
  - adding objects 4.2.1, 4.3.1, 4.3.3
  - adding to 4
  - best practices
  - configuring 2, 3
  - managing 12
  - sequences 9.5.2.1
- rules 1.1.2
- sequences 9.5.2.1
- tags 10
- XMLType 14.4
Oracle Streams Performance Advisor 15.2.2
OVERWRITE conflict resolution handler 9.6.1.1.1

P

performance
- Oracle Streams 15.2.2
point-in-time recovery
- Oracle Streams 12.6
POST_INSTANTIATION_SETUP procedure 2.2, 2.2.4.1, 2.2.5.1
PRE_INSTANTIATION_SETUP procedure 2.2, 2.2.4.1, 2.2.5.1
PREPARE_GLOBAL_INSTANTIATION procedure 8.2, 8.2.4
PREPARE_SCHEMA_INSTANTIATION procedure 8.2, 8.2.4
PREPARE_SYNC_INSTANTIATION function 8.2, 8.2.4
PREPARE_TABLE_INSTANTIATION procedure 8.2, 8.2.4
propagation
- best practices 17
  - broken propagations 17.2.1
  - configuration 17.1
  - propagation latency 17.1.2
  - propagation operation 17.2
  - queue-to-queue propagation 17.1.1
  - restarting propagation 17.2.1
  - SDU 17.1.3
propagation jobs
- managing 6.2
propagations
- creating 6, 6.2
- managing 6.2
PURGE_COMPARISON procedure 13.10

Q

queues
- ANYDATA
  - creating 6.1
- commit-time 11.2.2
- creating 6
- size
  - best practices 15.2.3
- transactional 11.2.2
queue-to-queue propagation
- best practices 17.1.1

R

RECHECK function 13.9
RECOVER_OPERATION procedure 12.8
Recovery Manager
- CONVERT DATABASE command
  - Streams instantiation 8.4.2.2
- DUPLICATE command
  - Streams instantiation 8.4.2.1
- Streams instantiation 8.4
- TRANSPORT TABLESPACE command
  - Streams instantiation 8.4.1
replication
- adding databases 4.2.2, 4.3.2, 4.3.4
- adding objects 4.2.1, 4.3.1, 4.3.3
- adding to 4
- bi-directional 1.2.1, 2.2.2.4
- configuration errors
  - recovering 12.8
- configuring 2, 3
  - apply handlers 1.2.5
  - ARCHIVELOG mode 1.3.3
  - bi-directional 1.2.3, 1.2.7
  - database 2.2.4.1
  - database links 1.3.2
  - DBMS_STREAMS_ADM package 2.2
  - DDL changes 1.2.6, 2.2.2.5
  - directory objects 2.2.3
  - downstream capture 1.2.2, 2.2.2.1, 2.2.5
  - hub-and-spoke 1.2.3, 1.2.7, 2.2.7
  - initialization parameters 1.3.4
  - instantiation 2.2.2.6
  - local capture 1.2.2, 2.2.2.1
  - log file transfer 1.3.7
  - multiple-source environment 3.2
  - n-way 1.2.3, 1.2.7
  - one-way 1.2.7
  - Oracle Enterprise Manager Cloud Control 2.1
  - Oracle Streams pool 1.3.5
  - preparation 1
  - schemas 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.7
  - scripts 2.2.2.2
  - single-source environment 3.1
  - standby redo logs 1.3.8
  - supplemental logging 1.3.6
  - tables 2.2.4.3
  - tablespace 2.2.5.1
  - tablespaces 2.2.5.1
  - tags 2.2.2.4.1
- hub-and-spoke 1.2.1, 10.5.2
- managing 12
- n-way 1.2.1, 10.5.1
- one-way 1.2.1, 2.2.2.4
- Oracle Streams 1
  - best practices
  - configuring 2.2.6
  - hub-and-spoke 1.2.1.2
  - managing 12
  - n-way 1.2.1.3
  - two-database 1.2.1.1, 2.2.6
- sequences 9.5.2.1
- split and merge 12.3
resolution columns 9.6.1.3
rule-based transformations 1.2.4
rules 1.1.2
- system-created
  - tags 10.2

S

SDU
- Streams best practices 17.1.3
sequences 9.5.2.1
- replication 9.5.2.1
SET_DML_HANDLER procedure 9.6.2
SET_GLOBAL_INSTANTIATION_SCN procedure 8.5, 8.5.2
SET_MESSAGE_TRACKING procedure 12.2
SET_SCHEMA_INSTANTIATION_SCN procedure 8.5, 8.5.2
SET_TABLE_INSTANTIATION_SCN procedure 2.2.6, 8.5
SET_TAG procedure 10.1, 10.6.1.1
SET_UP_QUEUE procedure 6.1
SET_UPDATE_CONFLICT_HANDLER procedure 9.6.1
- modifying an update conflict handler 9.7.2
- removing an update conflict handler 9.7.3
- setting an update conflict handler 9.7.1
SGA_TARGET initialization parameter 1.3.5.2
SPLIT_STREAMS procedure 12.3.2.2
split streams 12.3
staging
- heterogeneous environments 11.1.1
START_APPLY procedure 2.2.6
statistics
- Oracle Streams 15.2.2
STREAMS_CONFIGURATION parameter
- Data Pump Import utility 8.3.2.3
- Import utility 8.3.2.3
Streams pool
- MEMORY_MAX_TARGET initialization parameter 1.3.5.1
- MEMORY_TARGET initialization parameter 1.3.5.1
- SGA_TARGET initialization parameter 1.3.5.2
STRMMON 15.2.2
supplemental logging 1.3.6
- column lists 9.6.1.2
- instantiation 8.1
- preparation for instantiation 8.2.3, 8.2.4
synchronous capture
- best practices
  - configuration 16.3
- configuring 2.2.6, 5.2
- preparing for 5.2.1
system change numbers (SCN)
- oldest SCN for an apply process
  - point-in-time recovery 12.6.3

T

tags 2.2.2.4.1, 10
- ALTER_APPLY procedure 10.1, 10.4
- apply process 10.4
- avoiding change cycling 2.2.6
- change cycling
  - avoidance 10.5
- CONVERGE procedure 13.8.3
- converging data 13.3.3
- CREATE_APPLY procedure 10.1, 10.4
- examples 10.5
- getting value for current session 10.6.1.2
- hub-and-spoke replication 10.5
- managing 10.6
- monitoring 10.7
  - apply process value 10.7.2
  - current session value 10.7.1
- n-way replication 10.5
- online backups 10.3
- removing value for apply process 10.6.2.2
- rules 10.2
  - include_tagged_lcr parameter 10.2
- SET_TAG procedure 10.1
- setting value for apply process 10.6.2.1
- setting value for current session 10.6.1.1
tracking LCRs 12.2
transformations
- heterogeneous environments
  - Oracle to non-Oracle 11.1.3
- rule-based 1.2.4
transportable tablespace
- Streams instantiation 8.4.1
two-database replication 1.2.1.1
- configuring
  - synchronous capture 2.2.6

V

V$STREAMS_MESSAGE_TRACKING view 12.2
V$STREAMS_POOL_ADVICE view 1.3.5.3
V$STREAMS_TRANSACTION view 8.2.4

X

XMLType
- logical change records (LCRs) 14.4