RAC primary+Single standby日志传输错误一则
来源:互联网 发布:淘宝宝贝规格不显示 编辑:程序博客网 时间:2024/05/30 23:49
环境:
最近用grid control部署了一套RAC primary+Single standby环境,如下
角色 实例名 IP
主集群数据库1 racdb_racdb1 192.168.2.101
主集群数据库2 racdb_racdb2 192.168.2.102
rac-scan ip:192.168.2. 201
物理备用 racsdb 192.168.2.200
现象:
部署时没有问题,可是当部署完成后,在standby库日志中出现如下错误:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 29-8月 -2012 07:16:35
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: 操作超时
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.102)(PORT=41124))
WARNING: inbound connection timed out (ORA-3136)
在broker中出现的错误:
racsdb ORA-16191: Primary log shipping client not logged on standby
racdb(racdb2) ORA-16737: the redo transport service for standby database "racsdb" has an error
在实例racdb1执行 alter system switch logfile命令,日志如下:
Wed Aug 29 10:01:19 2012
Thread 1 advanced to log sequence 429 (LGWR switch)
Current log# 1 seq# 429 mem# 0: +DATA/racdb/onlinelog/group_1.261.765379725
Current log# 1 seq# 429 mem# 1: +FRA/racdb/onlinelog/group_1.257.765379727
Wed Aug 29 10:01:24 2012
LNS: Standby redo logfile selected for thread 1 sequence 429 for destination LOG_ARCHIVE_DEST_3
Wed Aug 29 10:01:33 2012
Archived Log entry 957 added for thread 1 sequence 428 ID 0x2d79fb01 dest 1:
在实例racdb2执行 alter system switch logfile命令,日志如下:
Wed Aug 29 10:06:04 2012
Thread 2 advanced to log sequence 474 (LGWR switch)
Current log# 4 seq# 474 mem# 0: +DATA/racdb/onlinelog/group_4.266.765380287
Current log# 4 seq# 474 mem# 1: +FRA/racdb/onlinelog/group_4.260.765380289
Wed Aug 29 10:06:15 2012
Archived Log entry 958 added for thread 2 sequence 473 ID 0x2d79fb01 dest 1:
Wed Aug 29 10:06:17 2012
Error 1017 received logging on to the standby
--------------------------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
--------------------------------------------------------------------------------
FAL[server, ARC4]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance racdb2 - Archival Error. Archiver continuing.
分析解决:
根据错误提示,很可能是由于密码文件的问题,为了确认问题,在主备库重建密码文件
分别在主库两实例执行:
orapwd file=orapwracdb1 password=oracle123 force=y ignorecase=y
orapwd file=orapwracdb2 password=oracle123 force=y ignorecase=y
备库执行:
orapwd file=orapwracsdb password=oracle123 force=y ignorecase=y
然后再检查alter日志,日志传输正常。
- RAC primary+Single standby日志传输错误一则
- Oracle11gR2 RAC primary+Single standby DG配置实践
- Data Guard Physical Standby 11.2 RAC Primary to RAC Standby using a second network (Doc ID 1349977.1
- Data Guard Physical Standby 11.2 RAC Primary to RAC Standby using a second network (Doc ID 1349977.1
- 监控primary/standby数据库
- oracle 10g rac standby 归档日志自动删除脚本
- Configuring Oracle 11.2.0.3 3-Nodes RAC Primary to 2-Nodes RAC Physical Standby DataGuard on OL
- 日志不得应用情况切换强制standby改变状态为primary
- RAC搭建standby
- RAC数据库建立STANDBY
- RAC DATAGUARD primary listener
- Oracle Study之--Logical Standby日志应用错误案例
- RAC环境STANDBY数据库只能有一个实例在进行日志恢复工作
- Oracle 11R2 rac dataguard日志无法传输到备库
- PostgreSQL 数据库的 primary、standby 架设
- Reinstate Failed Primary Database into Physical Standby
- RAC + DG ORA-01105 ORA-01677 standby file name convert parameters differ from other instance 错误
- RAC + DG ORA-01105 ORA-01677 standby file name convert parameters differ from other instance 错误
- uva 10300 Ecological Premium
- PHP strtotime()函数
- ScrollView中嵌套ListView是,嵌套在里面的ListView不能完全显示解决方法
- 蓝牙模块加电的另外一种方式
- Linux命令之切换到root用户
- RAC primary+Single standby日志传输错误一则
- 仿人人滑动式菜单
- COCOS2D中对精灵的操作、对图片的各种操作
- sql将数据列表变成字符串(数组)的最佳方法
- 下拉框组件在IE8下的问题解决
- A Versatile TreeView for WPF
- 配置log4j.properties
- 相机的渲染
- cocos2d对动画的各种操作