Re:ORA-00257 :Urgent

From: <dgoulet_at_vicr.com>
Date: Wed, 17 Jan 2001 14:38:06 -0500
Message-Id: <10744.126921@fatcity.com>

Ajay,

ORA-00257 means the archiver is stuck. To correct:

connect internal via svrmgrl
run "archive log list"
look for where the archiver belives it's sending the log files, ex:

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /ora1/archive/active/  <--- here we are
Oldest online log sequence     168479
Next log sequence to archive   168481
Current log sequence           168481

4) check out this area, is it out of space? If so, do whatever you usually do to clean it out, the archiver will resume by itself.

____________________Reply Separator____________________

Subject: ORA-00257 :Urgent
Author: "Ajay Khandelwal" <ajay_at_tems.com> Date: 1/17/2001 10:50 AM

Hi Guys,
while trying to connect to one of my database users getting ora-00257 can't conn connect only as internal acr error. I checked the disk space which looks ok. what should be the possible fix.
TIA
-Ajay

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ajay Khandelwal
INET: ajay_at_tems.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 17 2001 - 13:38:06 CST