redo log file

Posted by Roshan on Sep 01, 2016; 12:41pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/redo-log-file-tp1277.html

Hi,

when I am opening the database, it is taking time. I checked the alert log as shown below:

ORA11G_test>tail -f alert_CICLONE.log
  Current log# 1 seq# 5253 mem# 0: /u02/clone/CI/onlinelog1/redo_g1_m1.log
  Current log# 1 seq# 5253 mem# 1: /u02/clone/CI/onlinelog2/redo_g1_m2.log
Thu Sep 01 16:50:36 2016
Thread 1 advanced to log sequence 5254 (LGWR switch)
  Current log# 2 seq# 5254 mem# 0: /u02/clone/CI/onlinelog1/redo_g2_m1.log
  Current log# 2 seq# 5254 mem# 1: /u02/clone/CI/onlinelog2/redo_g2_m2.log
Thu Sep 01 16:50:49 2016
Thread 1 advanced to log sequence 5255 (LGWR switch)
  Current log# 3 seq# 5255 mem# 0: /u02/clone/CI/onlinelog1/redo_g3_t2_m1.log
  Current log# 3 seq# 5255 mem# 1: /u02/clone/CI/onlinelog2/redo_g3_t2_m2.log
Thu Sep 01 16:51:17 2016
Thread 1 cannot allocate new log, sequence 5256
Checkpoint not complete
  Current log# 3 seq# 5255 mem# 0: /u02/clone/CI/onlinelog1/redo_g3_t2_m1.log
  Current log# 3 seq# 5255 mem# 1: /u02/clone/CI/onlinelog2/redo_g3_t2_m2.log


Do I need to increase the size of redo?
SQL> select group#,sequence#,bytes,archived,status from v$log;

    GROUP#  SEQUENCE#      BYTES ARC STATUS
---------- ---------- ---------- --- ----------------
         1       5261  104857600 NO  CURRENT
         2       5258  104857600 NO  ACTIVE
         3       5259  104857600 NO  ACTIVE
         4       5260  104857600 NO  ACTIVE