Database Administration (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center