Introduction :
After configuring the dataguard, databases would be in primary role and standby database role. The above mentioned roles can be altered without the loss of data and without resetting logs. The process is achieved through a concept called Switchover.
Error Faced :
ORA-00333: redo log read error block 7608320 count 2048
ORA-00312: online log 21 thread 1: ”
ORA-15079: ASM file is closed
Mon Jan 15 12:03:20 2020
Errors in file <the path of trace file>/<sid>_ooo_23441.trc:
ORA-17611: ksfd: file ‘0’ cannot be accessed, global open closed
Standby became primary SCN: 19212034680
Switchover: Complete – Database mounted as primary
SWITCHOVER: completed request from primary database. <—*switchover is completed
Reason :
The below mentioned command was executed and the above mentioned errors were thrown
“ALTER DATABASE SWITCHOVER TO PRIMARY”.
In the case of switchover, the completion of the switchover has higher priority than the creation of the archive log file.
The Problem in this case is due to that the standby redologs are too large and their archival could not be completed before the completion of switchover.
Fix for the issue :
It is recommended to execute the below commands to reduce the standby redologs archival time, before doing the switchover activity.
alert system switch logfile
OR
alter system archive log current
