Linux 环境下 Oracle 数据库 DataGuard 安装部署手册
目
1
引言
...................................................................................................................................................... 1
1.1
编写目的
.......................................................................................................................................... 1
1.2
适用范围
....................................................................................................................................... 1
2
功能
...................................................................................................................................................... 1
2.1
功能简介
....................................................................................................................................... 1
3
运行环境
.............................................................................................................................................. 1
3.1
硬件环境
....................................................................................................................................... 1
3.2
软件环境
....................................................................................................................................... 2
4
安装部署前规划
.................................................................................................................................. 2
4.1
服务器和
IP
地址规划
................................................................................................................... 2
4.2
服务器磁盘分区规划
................................................................................................................... 2
5
操作系统安装
...................................................................................................................................... 2
6 ORACLE
安装配置
......................................................................................................................... 5
6.1
下载安装文件
............................................................................................................................... 5
6.2
安装前配置
................................................................................................................................... 6
6.3 ORACLE11GR2
软件安装
............................................................................................................... 11
6.4
配置监听
....................................................................................................................................... 23
6.5
创建
ORACLE
数据库
................................................................................................................... 29
7
配置
DATAGUARD............................................................................................................................. 41
7.1
修改主节点
TNSNAMES.ORA
文件
............................................................................................... 41
7.2
拷贝配置文件到从节点
............................................................................................................... 42
7.3
启动从节点的监听
....................................................................................................................... 44
7.4
创建
ORACLE
目录
....................................................................................................................... 45
7.5
正式配置
DATAGUARD................................................................................................................... 45
7.6
修改参数文件为
SPFILE................................................................................................................... 53
7.7
添加
STANDBY LOGFILE................................................................................................................... 54
7.8
重启主备数据库
........................................................................................................................... 55
8
测试
DATAGUARD............................................................................................................................. 57
8.1
测试日志传送
............................................................................................................................... 57
8.2
测试数据同步
............................................................................................................................... 58
8.3
检查日志应用
............................................................................................................................... 59
9
附
.DATAGUARD
主备库重启方法
................................................................................................. 59
评论