Solved: Restore Of Standby Control File On Standby DB In ExaCS Failing With ERROR (ORA-600, RMAN-03002)

This Blog Post Covers the Issue & fix while Performing a Restore of Standby Control File using RMAN on Standby Database on Exadata Cloud Service OCI, as a part of Hybrid Data Guard (Standby/Dataguard) Configuration.

Note: To Know More About Why should DBAs Learn Cloud, How to upgrade From DBA To Oracle Cloud DBA and Which Cloud Certification Useful for DBAs Join Our FREE Masterclass by Click here

Data Guard

Data Guard provides a complete set of services that create, maintain, manage one or more standby databases to enable production Oracle databases to survive disasters and data corruption. Data Guard maintains these standby databases as copies of the production database. If the primary database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production unit, minimizing the downtime associated with the outage.

Hybrid Data Guard

Hybrid Data Guard is an Effective and Cost-Efficient Disaster Recovery Deployment technique. In Normal Data guard both Primary and Standby databases Either available on Cloud or on On-premise while in Hybrid Data Guard On-premise data center worked as a Primary database and Database in the cloud works as a Standby database or vice-versa.

Issue  

While Restoring the Standby Controlfile using RMAN on Standby Database on Exadata Cloud Service on OCI was failing.

ORA-17627: ORA-03113: end-of-file on communication channel
Session ID: 1302 Serial number: 4989
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn’t exist
ORA-17627: ORA-03113: end-of-file on communication channel

In Alert Log On Standby

When I Checked Alert logs on Standby Database found this:

Conversion to standby controlfile pending for restored file
No controlfile conversion
Errors in file /u02/app/oracle/diag/rdbms/standby_lhr32b/standby3/trace/standby3_ora_38328.trc (incident=49677) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [1868], [0x000000000], [], [], [], [], [], [], [], [], [], [] Incident details in: /u02/app/oracle/diag/rdbms/standby_lhr32b/standby3/incident/incdir_49677/standby3_ora_38328_i49677.trc
Dumping diagnostic data in directory=[cdmp_20191229111506], requested by (instance=3, osid=38328), summary=[incident=49677].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sweep [inc][49677]: completed
Sweep [inc2][49677]: completed

Checks & Fix 

1) Checked following patch “22153958: [DB12201-OTHER] HIT ORA-600 [1868] ON RMAN DUPLICATE” was already applied as part of Patch 29958812

2) Finally, I followed similar issue on MOS Note# 2230068.1  RMAN Duplicate From On-Premise DB Is Failing With ORA-600 and in sqlnet.ora on standby DB added DISABLE_OOB=on

 I was able to restore the standby control file after this 

References

• RMAN Duplicate From On-Premise DB Is Failing With ORA-600 (Doc ID: 2230068.1)
• What is DISABLE_OOB (Out Of Band Break)? (Doc ID: 373475.1)
• RMAN active duplicate hanging on restore control file (Doc ID: 2073604.1)
• Oracle Net Performance Tuning (Doc ID: 67983.1)

Related/Further Readings

• Check out theData Guard In Oracle Cloud Infrastructure (OCI): Overview & Concepts
• Check out the Overview of Oracle Exadata Cloud Service
• Read about Oracle Exadata Cloud Service Architecture
• Learn more about Oracle Exadata Deployment Options

Next Task For You

If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.