Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. ORA-00257: archiver error; number of archive log files to retain

    ORA-00257: archiver error; number of archive log files to retain

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    When attempting to view tablespace via util o /14/1 these messages are displayed:
    ERROR:
    ORA-00257: archiver error. Connect internal only, until freed.

    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
    where <logon> ::= <username>[/<password>][@<connect_identifier>] [edition=value] | /
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
    where <logon> ::= <username>[/<password>][@<connect_identifier>] [edition=value] | /
    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

    Cause:
    The directory storing oracle files was full.

    Resolution:
    Free disk space e.g. by removing old archive log files.

    Additional Information

    Archive log files would be used to recover using a hot backup. You would restore the database from the most recent cold backup and then apply the archive log files created since that cold backup.
    Thus, you need to keep all of the archive log files which have been written since your most recent cold backup. Log files older than the cold backup can be removed.

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ORA-00257: archiver error
      • ORA-00376 and ORA-01110 error message in Aleph logs
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved