ORA-00308: cannot open archived log '/archivelog/DWHA/1_679737_517288279.arc
edited Jan 2, 2012 9:30PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
Hello,
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit:
Thread 1 cannot allocate new log, sequence 679737
Thread 1 advanced to log sequence 679737 (LGWR switch)
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
Current log# 2 seq# 679737 mem# 1: /data/ora/DWHA/u02/redo/redo_2b.dbf
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
Current log# 2 seq# 679737 mem# 1: /data/ora/DWHA/u02/redo/redo_2b.dbf
ORA-00308: cannot open archived log '/archivelog/DWHA/1_679737_517288279.arc'
I have an error :
Thread 1 cannot allocate new log, sequence 679737
Thread 1 advanced to log sequence 679737 (LGWR switch)
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit:
Thread 1 cannot allocate new log, sequence 679737
Thread 1 advanced to log sequence 679737 (LGWR switch)
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
Current log# 2 seq# 679737 mem# 1: /data/ora/DWHA/u02/redo/redo_2b.dbf
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
Current log# 2 seq# 679737 mem# 1: /data/ora/DWHA/u02/redo/redo_2b.dbf
ORA-00308: cannot open archived log '/archivelog/DWHA/1_679737_517288279.arc'
I have an error :
Thread 1 cannot allocate new log, sequence 679737
Thread 1 advanced to log sequence 679737 (LGWR switch)
Current log# 2 seq# 679737 mem# 0: /data/ora/DWHA/u01/redo/redo_2a.dbf
0