ORA-00257 archiver error. Connect internal only, until freed

Posted on 2009-02-24
Last Modified: 2013-12-18
I am having an ORA-00257 error when trying to connect to oracle

Can anyone share what all scenarios cause this problem and how we can fix it.I t would be fine if i get multiple fixes for this error..i.e multi scenarios which cause issues.

How to archive set up properly check .

I am using 10gR2 database on OS CentOS 4.4.  what and how to set up archive properly?? the archive file can get huge.

Question by:Pradeep_Tiwari
    LVL 15

    Expert Comment

    by:Haris Djulic
    check the disk space ...

    this is usually error when disk used by oracle is full..

    you should change location for you archive logs to be somewhere else or move them to another server ...
    LVL 16

    Expert Comment

    If you use RMAN to backup, it can manage your archivelogs for you so your disks don't get filled up.

    RMAN> backup database plus archivelogs delete input;

    This will do a full backup of the database and the arvhivelogs, and delete backed up archivelogs.

    LVL 1

    Expert Comment

    couple of immediate options
    1 if you dont want the archive logs delete them  using os command eg rm ....
    and log in to the database as sys "/ as sysdba"
    alter system switch logfile;

    2 move the archive logs from the current position to another mountpoint
    create a soft link  in the current location so that when you backup rman can read them using the soft link.
    log in to the database as sys "/ as sysdba"
    alter system switch logfile;

    run the backup.

    LVL 7

    Expert Comment

    immediately, you should make some space in the archive location so that problem will go and once you have some space in archive location, do a "alter system switch logfile". you can make space, by moving the old archives to other directories, taking the backup and removing or, if you have already backed them up then just remove it using RMAN with command "backup archivelog all delete input"
    or " delete archivelog all completed before 'sysdate-1'; it depends, how much archives you want to retain on this archive location.
    LVL 34

    Expert Comment

    Basically, you need to manage the archived redo logs so this situation doesn't happen again.  You can either use RMAN to delete the ones you don't need, or use an O/S script to either compress then and/or move the older ones to a different disk.

    What kind of backup strategy do you have now?  Do you use RMAN, or something else?

    Author Comment

    I am using RMAN backup with 10gR2 database
    LVL 16

    Accepted Solution

    What I do on my development environment where many archivelogs can be generated each day is to run a scipt every night which backs up the archivelogs and deletes them with RMAN>backup archivelog all delete input;

    This frees up the archivelog location ready for the next day.

    If you take COLD backups nightly, then you simply need to delete the archivelogs and crosscheck them so that RMAN removes them from its repository.

    Let me know if you require any further info.


    Author Comment

    problem is solved

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now