一、环境
database |
db_unique_name |
net service name |
SID |
os version |
DB version |
primary |
jgsb |
jg_pd |
jgsb |
oracle linux 6.7 x64 |
11.2.0.4 |
physical standby |
jgsbdg |
jg_st |
jgsb |
centOS 6.5 x64 |
11.2.0.4 |
二、安装步骤
1、主库设置为 force logging 模式
SQL> alter database force logging;
--验证:
SQL> select force_logging from v$database;
2、主库添加standby redo日志文件
select group#,thread#,members,status,bytes/1024/1024 m from v$log;
select group#,type,member from v$logfile order by 2;
添加规则:大小和 online redo 相同,比 online redo group 多一组。
alter database add standby logfile thread 1 group 21('+DATA') size 300m;
alter database add standby logfile thread 1 group 22('+DATA') size 300m;
alter database add standby logfile thread 1 group 23('+DATA') size 300m;
alter database add standby logfile thread 1 group 24('+DATA') size 300m;
alter database add standby logfile thread 1 group 25('+DATA') size 300m;
alter database add standby logfile thread 1 group 26('+DATA') size 300m;
alter database add standby logfile thread 1 group 27('+DATA') size 300m;
alter database add standby logfile thread 1 group 28('+DATA') size 300m;
alter database add standby logfile thread 2 group 31('+DATA') size 300m;
alter database add standby logfile thread 2 group 32('+DATA') size 300m;
alter database