| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Managing Archived Redo Logs
To piggyback on John's reply, one of our 8173 test systems filled the
archive destination over the weekend during a application upgrade.
Now the Unix directory was fill for less than 90 minutes and the
database was hung/halted for less than 45 minutes but 10s of thousands
of line of the following were written to the alert log:
ARC2: Beginning to archive log# 9 seq# 160 ARC2: Failed to archive log# 9 seq# 160 ARC2: Beginning to archive log# 10 seq# 161 ARC2: Failed to archive log# 10 seq# 161
As the database spawned 9 ARCn processes and continued to attempt to write out filled redo logs. If this goes on too long you are also at risk of filling the 'background_dump_dest' directory as well.
Mike Hand
-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]
Sent: Wednesday, July 23, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Managing Archived Redo Logs
Just to add that you _can_ be informed of this if you monitor the alert log. The following errors are logged (from a live system, and way back from 7.3.4!)
Thread 1 advanced to log sequence 69529
Current log# 1 seq# 69529 mem# 0: /u090/oradata/XXXX/REDO0101.DBF
Current log# 1 seq# 69529 mem# 1: /u091/oradata/XXXX/REDO0102.DBF
...skipping...
ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata/XXXX/REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata/XXXX/REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata/XXXX/arch/arch1_69616.log'ARCH:
ORA-00312: online log 1 thread 1: '/u090/oradata/XXXX/REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata/XXXX/REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata/XXXX/arch/arch1_69616.log'Mon May 13 05:36:57 2002
John Kanagaraj
This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Received on Wed Jul 23 2003 - 14:37:59 CDT
 |
 |