ORA-00257 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00257 error

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    When I try to open any Oracle tool, I get the ORA-00257 Archive error.
    I came to know that this may be due to insufficent disk space in the destination, so I have freed up my drive too(it has 513MB space now..)

    But I still get the same error??
    Do I need to do anything else?

    I am using Oracle 8.1.6 on Windows NT 4.0.

    Thanks for any advice.
    Shiva.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    From oerr:

    Error: ORA 257
    Text: archiver is stuck.
    -------------------------------------------------------------------------------
    CONNECT INTERNAL only, until freed
    Cause: The ARCH process received an error while trying to archive a redo log
    file.
    If the problem is not resolved soon, the database will stop executing
    transactions.
    The most likely cause of this message is that the destination device
    is out of space to store the redo log file.
    Action: Check the archiver trace file for a detailed description of the
    problem.
    Also, verify that the device specified in the initialization parameter
    ARCHIVE_LOG_DEST is set up properly for archiving.

    ------
    Now that you have freed up some space, you can either turn archiving off or restart archiving (alter system archive log start).
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Thanks for your response.
    But how am I to get into the system at all...all my SQLPLUS, Enterprise manager, everything if frozen with this error??
    I know this may seem silly, but I really have no idea..

    Shiva.


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'm not sure on NT, but you should get to a command prompt (might be able to get in through svrmgrl):
    c:> sqlplus /nolog
    SQL> connect internal
    SQL> alter system archive log start;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width