最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
oracle报错RMAN active duplicate hanging on restore control file
时间:2016-08-30 编辑:简简单单 来源:一聚教程网
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)
相关文章
- Oracle 删除大量表记录操作介绍 09-27
- oracle11g调整sga方法详解 09-20
- Oracle如何在SQL语句中运用 09-19
- Oracle控制文件丢失恢复归档模式代码示例 07-07
- Oracle中的序列SEQUENCE代码解析 05-27
- oracle中dblink查看、创建、使用以及删除代码实例 04-28