About our redo log group and file size?
Dear all
Please see the message in alert log as below
Thu Sep 19 13:40:42 2024
Thread 1 cannot allocate new log, sequence 86613
Private strand flush not complete
Current log# 1 seq# 86612 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 86613 (LGWR switch)
Current log# 2 seq# 86613 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Archived Log entry 86605 added for thread 1 sequence 86612 ID 0x605ba7cc dest 1:
Thu Sep 19 14:10:13 2024
ALTER SYSTEM ARCHIVE LOG
Thu Sep 19 14:10:13 2024
Thread 1 cannot allocate new log, sequence 86614
Private strand flush not complete
Current log# 2 seq# 86613 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 86614 (LGWR switch)