Database Administration (MOSC)

MOSC Banner

Redo Log File Size Increasing

edited Mar 28, 2010 11:14PM in Database Administration (MOSC) 13 commentsAnswered
  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

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