GG Register Extract Fails With ORA-00308: Cannot Open Archived Log
(Doc ID 2764312.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
Not able to REGISTER extract with database:
2021-03-26 20:00:20 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT1 because of the following SQL error: OCI Error ORA (status = 12801-ORA-12801: error signaled in parallel query server PZ99, instance orcl(2)
ORA-00308: cannot open archived log '+RECO01/orcl_orcl1/onlinelog/group_22.9721.859997341'
ORA-17503: ksfdopn:2 Failed to open file +RECO01/orcl_orcl1/onlinelog/group_22.9721.859997341
ORA-15012: ASM file '+RECO01/orcl_orcl1/onlinelog/group_22.9721.859997341' does not exist
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 145
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 186
ORA-06512: at line 1
).
Changes
Added Standby Redo Log at some point (v$standby_log).
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |