Redo Log File Size Increasing
Hi
I am using 8 Redo groups and each group having two files.
Each file size 100 MB.
Right now I am getting the below error in production environment:
Thread 1 cannot allocate new log, sequence 963
Checkpoint not complete
Current log# 7 seq# 962 mem# 0: +DATA_PREPAID/gsmpredb/redo07.log
Current log# 7 seq# 962 mem# 1: +DATA_PREPAID/gsmpredb/redo07a.log
Thread 1 advanced to log sequence 963 (LGWR switch)
Current log# 1 seq# 963 mem# 0: +DATA_PREPAID/gsmpredb/redo01.log
Current log# 1 seq# 963 mem# 1: +DATA_PREPAID/gsmpredb/redo01a.log
Thread 1 cannot allocate new log, sequence 964
Checkpoint not complete
Current log# 1 seq# 963 mem# 0: +DATA_PREPAID/gsmpredb/redo01.log
Current log# 1 seq# 963 mem# 1: +DATA_PREPAID/gsmpredb/redo01a.log
I am using 8 Redo groups and each group having two files.
Each file size 100 MB.
Right now I am getting the below error in production environment:
Thread 1 cannot allocate new log, sequence 963
Checkpoint not complete
Current log# 7 seq# 962 mem# 0: +DATA_PREPAID/gsmpredb/redo07.log
Current log# 7 seq# 962 mem# 1: +DATA_PREPAID/gsmpredb/redo07a.log
Thread 1 advanced to log sequence 963 (LGWR switch)
Current log# 1 seq# 963 mem# 0: +DATA_PREPAID/gsmpredb/redo01.log
Current log# 1 seq# 963 mem# 1: +DATA_PREPAID/gsmpredb/redo01a.log
Thread 1 cannot allocate new log, sequence 964
Checkpoint not complete
Current log# 1 seq# 963 mem# 0: +DATA_PREPAID/gsmpredb/redo01.log
Current log# 1 seq# 963 mem# 1: +DATA_PREPAID/gsmpredb/redo01a.log
0