Error ORA-00333, ORA-15079, ORA-17611 during Dataguard Switchover
(Doc ID 2474154.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- ORA-00333, ORA-15079, ORA-17611 errors were reported in alert log of new Primary database during switchover. As the result, SRL archive is failed, but switchover completed normally.
Mon Oct 15 17:03:16 2018
RFS[7]: Assigned to RFS process (PID:28478)
RFS[7]: Selected log 21 for thread 1 sequence 329 dbid xxxxxxxxxx branch 986576390
:
Mon Oct 15 17:03:16 2018
ALTER DATABASE SWITCHOVER TO PRIMARY (<sid>)
:
Mon Oct 15 17:03:19 2018
Errors in file <the path of trace file>/<sid>_ooo_39541.trc:
ORA-00333: redo log read error block 7608320 count 2048
ORA-00312: online log 21 thread 1: ''
ORA-15079: ASM file is closed
Mon Oct 15 17:03:20 2018
Errors in file <the path of trace file>/<sid>_ooo_39541.trc:
ORA-17611: ksfd: file '0' cannot be accessed, global open closed
Mon Oct 15 17:03:20 2018
Online log <the path of online redo log>/redo1101.log: Thread 1 Group 1 was previously cleared
:
Online log <the path of online redo log>/redo2206.log: Thread 2 Group 12 was previously cleared
Standby became primary SCN: 16212061483
Switchover: Complete - Database mounted as primary
SWITCHOVER: completed request from primary database. <---*switchover is completed
- After database opened, SRL archive was retried and succeeded.
Starting ORACLE instance (normal) (OS id: 37815)
:
Mon Oct 15 17:55:00 2018
Archived Log entry 8 added for thread 1 sequence 329 ID 0x3715a651 dest 1:
Mon Oct 15 17:55:00 2018
Archived Log entry 9 added for thread 1 sequence 329 ID 0x3715a651 dest 2:
Changes
Error occurred when executing dataguard switchover using SQL "ALTER DATABASE SWITCHOVER TO PRIMARY".
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 |