最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
oracle报错RMAN active duplicate hanging on restore control file
时间:2022-06-29 09:32:34 编辑:袖梨 来源:一聚教程网
12.1.0.2之后,duplicate target database for standby from active database的时候,总是hang死在restore controlfile的情况。这个由于Bug 19664695引起。(Bug22468652和Bug 20721271最终都可以归结到Bug 19664695上去。)
解决方法是在ORACLE_HOME和GRID_HOME的sqlnet.ora文件中都设置DISABLE_OOB=on 。详情可参考 RMAN active duplicate hanging on restore control file (Doc ID 2073604.1)
*** RMAN active duplicate hanging on restore control file (Doc ID 2073604.1) ***
#################
#
# APPLIES TO:
#
#################
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
Duplicate command gets hung while restoring the control file
RMAN-08016: channel ORA_AUX_DISK_1: starting datafile backup set restore
RMAN-08169: channel ORA_AUX_DISK_1: using network backup set from service SNPS
RMAN-08021: channel ORA_AUX_DISK_1: restoring control file
source database has an inactive session in there waiting on "SQL*Net break/reset to client"
#################
#
# CAUSE
#
#################
BUG 20721271 DUPLICATE FOR STANDBY FROM ACTIVE DATABASE HANGS WHILE RESTORING CONTROL FILE
This bug has been marked as a duplicate of bug 19664695.
BUG 19664695 12C RMAN WALLET ORA-01031: INSUFFICIENT PRIVILEGES
#################
#
# SOLUTION
#
#################
At the time of this writing, bug 19664695 is open and being worked on by development.
The workaround, until a permanent fix is available, is to:
1. On the dataguard (auxiliary) side, add the folowing line to the sqlnet.ora
DISABLE_OOB=on
2. Re-execute the duplicate command again
NOTE: Turning this parameter on disables the ability to send and receive "break" messages using urgent data provided by the underlying protocol. This would apply to all protocols used by the client.
For additional information, see:
What is DISABLE_OOB (Out Of Band Break)? (Note 373475.1)
相关文章
- 光遇11.5每日任务怎么做 光遇11月5日每日任务做法攻略 11-05
- 《龙腾世纪:影障守护者》出售物品方法介绍 11-05
- 《怪物猎人:荒野》接任务位置介绍 11-05
- 机甲战士5氏族修改器在哪下载 11-05
- 鸣潮武器投影怎么玩 11-05
- 鸣潮盈梦速行怎么玩 11-05