CANNOT ALLOCATE LOG, ARCHIVAL REQUIRED
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: CANNOT ALLOCATE LOG, ARCHIVAL REQUIRED

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I am running 8.1.6 on NT and I kept getting the message from ORacle.exe, it said

    WARNING: THE FOLLOWING ERRROR OCCUR DURING ORACLE REDO LOG ARCHIVAL

    CANNOT ALLOCATE LOG, ARCHIVAL REQUIRED.

    Please advise why I kept this getting this message and how to fix the problem.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Something is not setup correctly with your archiving. Check to make sure you have enough space in log_archive_dest, make sure log_archive_start=true, and that you don't have disk I/O contention between your log_archive_dest and your redo logs.

    See http://metalink.oracle.com/metalink/...p_id=1030505.6 for details.
    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
    Apr 2001
    Location
    London
    Posts
    725
    You may be on manual archiving.

    connect as sysdba and issue:-

    archive log list; - if on manual archiving issue :
    archive log start;



    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Jan 2002
    Posts
    474
    Jeff,

    my archvie is set to TRUE and the location of the archive log is different with the redo log.

    how do we check for disk I/O??? any or thought ????



  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Make sure ur archive destination has sufficient space.
    Another option is add another member to existing redo log group....
    The checkpoint process is still in process of writing to redo log file and other redo log files are still being archived hence oracle is not finding any new redo log file to write.

    regards
    anandkl


    anandkl

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