Oracle DG 搭建 生产版

Oracle DG 搭建

https://blog.youkuaiyun.com/onlyshenmin/article/details/81069263?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

1.环境介绍

hostname	ip	db_unique_name	net service name
db1	172.23.17.227	db1	orcl
db2	172.23.17.228	db2	orcl

2.DG部署

编辑

2.1.主机db1建立主库orcl

https://www.cnblogs.com/lei01/p/10688036.html

主机db1静默安装数据库软件

主机db1静默创建监听程序

主机db1静默安装数据库

主机db2静默安装数据库软件

主机db2静默创建监听程序

2.2.主库开启归档

主库开启归档并设置强制日志 force logging

--干净的关闭数据库
SQL> shutdown immediate
--以mount模式启动
SQL> startup mount
--切换到归档模式
SQL> alter database archivelog;
--开启强制日志
SQL> alter database force logging;
--打开数据库
SQL> alter database open;
--查看归档
SQL> archive log list;
--查看是否为强制日志
SQL> select force_logging from v$database;

2.3.主库添加Standby Redo Log

--查看Redo和Standby Redo
SQL> select * from v$logfile;											
--仅仅显示Online Redo，不显示Standby Redo
SQL> select * from v$log;		
--将日志组大小调整到500M
--添加三组日志
SQL>alter database add logfile group 4 ('/data/app/oracle/oradata/orcl/redo04.log') size  500M;
SQL>alter database add logfile group 5 ('/data/app/oracle/oradata/orcl/redo05.log') size  500M;
SQL>alter database add logfile group 6 ('/data/app/oracle/oradata/orcl/redo06.log') size  500M;	
--将日志组切换至inactive并删除旧日志组
SQL>alter system switch logfile;
--删除旧日志组
SQL>alter database drop logfile group 1;
SQL>alter database drop logfile group 2;
SQL>alter database drop logfile group 3;
--重新添加
SQL>alter database add logfile group 1 ('/data/app/oracle/oradata/orcl/redo01.log') size  500M;
SQL>alter database add logfile group 2 ('/data/app/oracle/oradata/orcl/redo02.log') size  500M;
SQL>alter database add logfile group 3 ('/data/app/oracle/oradata/orcl/redo03.log') size  500M;	
--删除多余日志组
SQL>alter system switch logfile;
SQL>alter database drop logfile group 4;
SQL>alter database drop logfile group 5;
SQL>alter database drop logfile group 6;							
--新增一组大小为500M的Standby Redo，这里的group号不得与Online redo重复
SQL> alter database add standby logfile group 21 '/u01/app/oracle/oradata/orcl/standby21.log' size 500M;
SQL> alter database add standby logfile group 22 '/u01/app/oracle/oradata/orcl/standby22.log' size 500M;
SQL> alter database add standby logfile group 23 '/u01/app/oracle/oradata/orcl/standby23.log' size 500M;
SQL> alter database add standby logfile group 24 '/u01/app/oracle/oradata/orcl/standby24.log' size 500M;

2.4.从主库创建pfile文件

主库

#创建pfile文件
SQL>create pfile from spfile;
#修改篇file文件

[oracle@db1 dbs]$ more initorcl.ora 
orcl.__db_cache_size=8355053568
orcl.__java_pool_size=67108864
orcl.__large_pool_size=100663296
orcl.__oracle_base='/data/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_