目录
1
引言
______________________________________________________________4
2
概述
______________________________________________________________4
3
环境准备
_________________________________________________________5
3.1 设定初始化参数 ______________________________________________________5
3.2 将数据库置为归档模式 ________________________________________________5
3.3 创建 stream 管理用户 _________________________________________________6
3.3.1 创建主环境 stream 管理用户 _______________________________________________6
3.3.2 创建从环境 stream 管理用户 _______________________________________________7
3.4 配置网络连接 ________________________________________________________7
3.4.1 配置主环境 tnsnames.ora___________________________________________________7
3.4.2 配置从环境 tnsnames.ora___________________________________________________8
3.5 启用追加日志 ________________________________________________________8
3.6 创建 DBlink_______________________________________________________9
3.6.1 创建主数据库数据库链____________________________________________________9
3.6.2 创建从数据库数据库链____________________________________________________9
3.7 创建流队列 ________________________________________________________9
3.7.1 创建 Master 流队列 _______________________________________________________9
3.7.2 创建 Backup 流队列______________________________________________________10
3.8 创建捕获进程 _____________________________________________________10
3.9 实例化复制数据库 _________________________________________________10
3.10 创建传播进程 ___________________________________________________11
3.11 创建应用进程 ___________________________________________________11
3.12 启动 STREAM__________________________________________________12
3.13 停止 STREAM__________________________________________________13
3.14 清除所有配置信息 _______________________________________________13
4
测试场景
_______________________________________________________14
4.1 建一张表测试 _____________________________________________________14
4.2 表中插入一行数据 _________________________________________________14
评论1