ORA-600[krsr_sna_io_finish:CNT], ORA-600[krsr_sna_io_finish] Occur at Standby...

刘泽宇

现象：
ORA-600[krsr_sna_io_finish:CNT], ORA-600[krsr_sna_io_finish] occur in RFS process at standby database.

alert log

2019-04-11T11:49:11.450125+09:00
Errors in file <PATH>/trace/<SID>_rfs_5572.trc  (incident=12469):
ORA-00600: internal error code, arguments: [krsr_sna_io_finish], [0],[2054], [2062], [], [], [], [], [], [], [], []
Incident details in: <PATH>/incdir_12469/<SID>_rfs_5572_i12469.trc

2019-04-11T17:50:01.634642+09:00
Errors in file <PATH>/trace/<SID>_rfs_7568.trc  (incident=13740):
ORA-00600: internal error code, arguments: [krsr_sna_io_finish:CNT], [2],[1], [], [], [], [], [], [], [], [], []
Incident details in: <PATH>/incdir_13740/<SID>_rfs_7568_i13740.trc
改动：
This problem can occur when setting SYNC NOAFFIRM to log_archive_dest_n at primary database.

原因：
This symptom was investigated by a developer under Bug:29646661 and concluded as duplicate of Bug:30788973.



处理方法：
To avoid this symptom, there are three options.

1. Set SYNC AFFIRM to log_archive_dest_n at primary database.

2. Change protection mode to maximize performance, then set ASYNC to log_archive_dest_n at primary database.