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

Thread: Ora-00257

  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Ora-00257

    I got an error message when I connect to oracle 8i, which is about ora-00257. I took a look at the error message. It said the archiver desitination is full. I checked the disk storage. Yes, it was full and then I freed them by deleting the old archiving logs. When I see there are enough space for archiving,I connected to the database. Unfortunately, the same error came up again. Should I delete all the archiving logs and make the archiving destination available 100% or I have to restart the database?
    If I try to restart the database, there are a archiving process suspending.

    Thanks in advance.

  2. #2
    Join Date
    May 2001
    Posts
    73
    Do 'alter system archive log current'
    OCP 7.3,8.0,8i,9i

  3. #3
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182
    sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;

    if archive log destination is full the above command it sets/starts archiving to secondary destination i.e which we are specifying so that you wonot get any error
    J Gangadhar

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    Even after u free space in archive destination, oracle will still not be able to open the failed destination.

    use the below command

    ALTER SYSTEM ARCHIVE LOG START;

    and Arch process will start archiving the redologs to the same destination

    regards
    anandkl
    anandkl

  5. #5
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;
    You need the REOPEN at the end, or else it won't start achiving. (and it's log_archive_dest, not archive_log_dest...)

    Code:
    ALTER SYSTEM SET log_archive_dest='location=/u01/oradata/archive reopen';
    ALTER SYSTEM ARCHIVE LOG ALL;

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