RMAN active duplicate hanging on restore control file (Doc ID 2073604.1) (Standby duplicate)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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
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"
SOLUTION
The workaround for the issue is:
1. On the dataguard (auxiliary) side, add the following line to the sqlnet.ora
DISABLE_OOB=on
2. Re-execute the duplicate command again
DISABLE_OOB=on
2. Re-execute the duplicate command again
No comments:
Post a Comment