没有合适的资源?快使用搜索试试~ 我知道了~
ORACLE LINUX 11G RAC 单实例DATAGUARD.docx
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 33 浏览量
2022-11-17
11:43:14
上传
评论
收藏 2.86MB DOCX 举报
温馨提示
试读
17页
。。。
资源推荐
资源详情
资源评论
ORACLE LINUX 11G RAC 单实例 DATAGUARD
环境说明:
源库:
双节点 RAC:
CPU:12
MEM:8G
操作系统:Linux 2.6.18-194.el5
10.135.33.170 11grac1.fawcar.com.cn 11grac1
10.135.33.171 11grac2.fawcar.com.cn 11grac2
10.135.33.172 11grac1-vip.fawcar.com.cn
10.135.33.173 11grac2-vip.fawcar.com.cn
DB_NAME=oem
11grac1-vip
11grac2-vip
db_unique_Name=oem
DATAGUARD目标库:
单实例
CPU:4
MEM:6G
操作系统:Linux 2.6.18-194.el5
10.135.161.241
DB_NAME=oem
db_unique_name=dgtest
安装步骤
一、
源库设置强制归档:
二、
源库设置参数,设置完毕后参数如下所示
DB_NAME=oem
DB_UNIQUE_NAME=oem
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem'
LOG_ARCHIVE_DEST_2='SERVICE=oem_dg LGWR AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem_dg'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=4
DB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATA/oem/dataf
ile/'
LOG_FILE_NAME_CONVERT= '/oradata/oem_dg/','+DATA/oem/
STANDBY_FILE_MANAGEMENT=AUTO
执行如下命令设置:
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(oem,oem_dg)'
scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=/dbfs_backup/oem
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem' scope=both
sid='*';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=oem_dg LGWR AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem_dg'
scope=both sid='*';
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile
sid='*';
alter system set log_archive_max_processes=4 scope=both sid='*';
alter system set fal_server=oem_dg scope=both sid='*';
alter system set
DB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATA/oem/dataf
ile/' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT=
'/oradata/oem_dg/,'+DATA/oem/' scope=spfile sid='*';
alter system set standby_file_management=AUTO scope=both sid='*';
三、
重启源库,设置为归档模式。
srvctl stop database–d oem –o immediate;
srvctl start database –d oem
注:
重启 11grac2 报错:
srvctl stop database–d oem –o immediate;
srvctl start database –d oem
+ASM2
ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match
euid], [504], [500], [], [], [], [], [], [], [], [], []
查看是 grid 用户下的的$oracle_home 目录的权限改变了,全都变成了oracle:oinstall,
修改成 grid:oinstall 后,ASM 启动正常。
启动实例 2 时候报错:
NOTE: Deferred communication with ASM instance
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
每个节点上$ORACLE_HOME/bin/oracle,$GRID_HOME/bin/oracle 权限应该一样,是
6751:
-rwsr-s—x
检查 11grac2 的这两个文件,发现 GRID_HOME/bin/oracled 的权限为:
-rwxrwxrwx 1 grid oinstall 203973009 Jul 30 21:43 oracle
修改:
chmod 6751 oracle
为:
-rwsr-s--x 1 grid oinstall 203973009 Jul 30 21:43 oracle
启动 11grac2 实例,正常。
四、
源库检查修改的参数:
数据库重启完毕,检查修改的参数是否正确:
set linesize 500 pages 0
col value for a90
col name for a50
select name, value
from v$parameter
where name in ('db_name','db_unique_name','log_archive_config',
'log_archive_dest_1','log_archive_dest_2',
'log_archive_dest_state_1','log_archive_dest_state_2',
'remote_login_passwordfile',
'log_archive_format','log_archive_max_processes','fal_s
erver','db_file_name_convert',
'log_file_name_convert', 'standby_file_management');
剩余16页未读,继续阅读
资源评论
春哥111
- 粉丝: 1w+
- 资源: 5万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功