[oracle-l] ORA-00394 online log reused while attempting to archive it

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Mon, 26 Jan 2004 17:07:15 +0100
Message-ID: <30FB69E987A8D611B45900104BC18D4729A783@PDCQ>

Hi List,

Quick question:

In my alert log I have the following error:

ORA-00394 online log reused while attempting to archive it

Cause: An attempt was made to reuse an online log file that is being archived.

Action: The online log file has been overwritten; it cannot be archived.

Am I right to assume that my recovery will fail (when needed) and that my standby environment needs to be refreshed?

TIA Jack

-----Original Message-----

From: Craig Healey [mailto:c.healey_at_hhsuk.com] Sent: Monday, January 26, 2004 4:59 PM
To: oracle-l_at_freelists.org
Subject: [oracle-l] Re: DBMS_IJOB.REMOVE

OK, sorry, that would have been the obvious thing to do first :-( In my defence, erm, well, it was Friday...  

Craig
-----Original Message-----

From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]

First hit on MetaLink for 'dbms_ijob' is a good place to start.

Jared  

---

---

This message and any files transmitted with it are confidential and intended solely for the use of the intended recipient(s), and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use in reliance upon, this information by persons or groups other than the intended recipient(s) is prohibited. Statements and opinions expressed in this message may not represent those of the company.   

Any queries regarding this message please notify system.administrator_at_hhsuk.com  

Swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com)

---

---

Received on Mon Jan 26 2004 - 10:07:15 CST