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.
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3 instance=standby3 device type=DISK
channel ORA_DISK_1: using network backup set from service PRIMARY
channel ORA_DISK_1: restoring control file
PSDRPC returns significant error 600.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command
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
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1471 instance=standby3 device type=DISK
channel ORA_DISK_1: using network backup set from service PRIMARY
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output file name=+DATAC1/standby_lhr32b/CONTROLFILE/control.ctl
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.
Leave a Reply