【翻译自mos文章】当 使用DCD 和TCPS时,rman duplicate hang住
来源:互联网 发布:网络的拼音怎么写的 编辑:程序博客网 时间:2024/05/01 04:14
当 使用DCD 和TCPS时,rman duplicate hang住。
来源于:
RMAN Duplicate hangs when using DCD and TCPS (文档 ID 1676197.1)
适用于:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
症状:
在datafile copy 阶段,RMAN active duplicate for standby hang住。SSL Oracle Net 和Dead Connection Detection (DCD) 正在使用。
这个hang 是 间歇性的(intermittent),也就是说,有时duplicate 是能工作的,在其他时候,会hang住 很多天,直到进程从操作系统和database中kill掉。
rman debug 揭示了下面的信息会repeat:
RMAN-06731: command backup:x% complete, time left HH:MM:SS
样例RMAN debug输出如下:
RMAN-12016: using channel ORA_DISK_8RMAN-08580: channel ORA_DISK_1: starting datafile copyRMAN-08522: input datafile file number=00012 name=+OFD_DATA/ofmim01q/datafile/ofm_tbs_oaam_indx.272.810048785...RMAN-08581: channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:16RMAN-08592: output file name=+OFN_DAT/ofmiy01q/datafile/ofm_ias_iau.373.842790419 tag=TAG20140321T065222RMAN-08581: channel ORA_DISK_7: datafile copy complete, elapsed time: 00:00:16RMAN-06731: command backup:94.1% complete, time left 00:21:05// // RMAN-06731 and % complete repeats here// Process is completely stalled RMAN-06731: command backup:94.1% complete, time left 00:21:05
在primary database上,我们可以看到8个session hang住,等待事件"remote db file write" 的wait time会简单的增加
SQL> select SID ,SERIAL# , INST_ID , USERNAME, OSUSER || '@' || MACHINE OSINFO, SUBSTR(PROGRAM,0,20) PROGRAM, 2 TO_CHAR(LOGON_TIME,'yyyy-mm-dd hh24:mi:ss') LOGON_TIME, EVENT, SECONDS_IN_WAIT SIW from gv$session where type <> 'BACKGROUND' and PROGRAM like 'rman%' 3 ORDER BY USERNAME, INST_ID, SID; SID SERIAL# INST_ID USERNAME OSINFO PROGRAM LOGON_TIME EVENT SIW---- ------- ------- -------- ----------------- -------------------- -------------------- ------------------------------ ---------- 632 5635 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:27 SQL*Net message from client 34 758 2535 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:30 SQL*Net message from client 4 948 441 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:35 remote db file write 520361010 369 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:36 remote db file write 355321073 215 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:37 remote db file write 529351136 291 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:37 remote db file write 540141199 753 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:38 remote db file write 416511325 1595 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:39 remote db file write 427301388 2121 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:39 remote db file write 507711451 1351 2 SYS oracle@auq5583l rman@auq5583l (TNS V 2014-04-08 17:29:40 remote db file write 47650
hang住的进程必须被从databae和os级别kill掉。
原因:
Unfortunately expire_time + TCPS combination is not supported by oracle as NTZ layer(used for TCPS communication) uses routines that not async-signal-safe.
Using async-signal-safe routines can cause unpredictable results like hang, crash etc.
解决方案:
Do not use DCD with SSL Oracle Net. Remove sqlnet.expire_time from the sqlnet.ora file or set it to 0 (zero).
If you need to keep the connection alive due to firewall issues, consider using the operating system's TCP KEEPALIVE parameters instead. eg:
TCP_KEEPIDLE (the amount of time until the first keepalive packet is sent)
TCP_KEEPCNT (the number of probes to send)
TCP_KEEPINTVL (the interval between keepalive packets)
Otherwise, if you need to use DCD, you must use non-SSL Oracle Net.
- 【翻译自mos文章】当 使用DCD 和TCPS时,rman duplicate hang住
- 【翻译自mos文章】当指定asm disk 为FRA时,11.2.0.3的dbua hang住
- 【翻译自mos文章】当点击完 finish按钮后,dbca 或者dbua hang住
- 【翻译自mos文章】使用dbua升级到70%左右时,os hang
- 【翻译自mos文章】11gR2 OUI 在 PREREQUISITE CHECKS 时 hang住
- 【翻译自mos文章】rman 标准版和企业版的兼容性
- 【翻译自mos文章】当relink Oracle 软件时,用的是哪个linker 和 compiler?
- 【翻译自mos文章】在11gR2 rac中启用Dead Connection Connection(DCD)功能
- 【翻译自mos文章】使用buffer memory 参数来调整rman的性能。
- 【翻译自mos文章】为什么在备份过程中rman不使用unused block 压缩功能
- 【翻译自mos文章】对rman 压缩的彻底理解
- 【翻译自mos文章】由于sys.audses$的cache值太小导致的RAC hang
- [翻译自mos文章]当job_queue_processes=0 时,cjq 进程依然启动
- 【翻译自mos文章】当控制文件的备份丢失时,怎么restore database
- 【翻译自mos文章】使用aum( Automatic Undo Management) 时遇到 ORA-01555错误--- 原因和解决方案。
- 翻译mos文章rman复原的先决条件
- [翻译自mos文章] 当linux kernel和kmod-oracleasm升级之后,CRS不能发现voting disk.
- 【翻译自mos文章】怎么找到OGG Director Server使用的数据库和用户名?
- esayyui的layout嵌套布局可以解决fit自适应的位置偏移问题
- android canvas探究
- 天声人語 20150830
- 日经春秋 20150830
- 日经社説 20150830 戦後70年の視角 資本主義を鍛え世界に変革の姿を
- 【翻译自mos文章】当 使用DCD 和TCPS时,rman duplicate hang住
- 社説 20150830 ギリシャ総選挙 チプラス氏は延命できるのか
- 社説 20150830 休眠預金法案 公正性の確保へ審議を尽くせ
- 1 数据结构类-最近公共祖先LCA问题
- 从零开始学Java之出入门卫管理系统(四)
- 第一章线程管理
- 欢迎使用CSDN-markdown编辑器
- ubuntu14.10上编译Android5.0.2源码
- UBUNTU 查看 JAVA安装路径