Saturday, May 2, 2020


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 later
Oracle 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
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


No comments:

Post a Comment

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...