RMAN active duplicate hanging on restore control file

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)
One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.