DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2001
    Vadodara, India
    My DB is in Archivelog mode on Oracle 8 (on win NT) and
    I am getting below warning message frequently since last 7 days.


    \orant\bin\oracle80.exe warning - The foolowing error occured during oracle redo log archival

    Oracle Instance ORCL - Can not allocate log,archival required.
    Press ENTER to acknowledge message


    After pressing enter it will continue.

    For which reason this warning messages and any solution for the same?

  2. #2
    Join Date
    Apr 2000
    Edison, NJ
    It means that the log switches are taking place too frequently and the db cannot keep up with the archiving process. This is due to a large # of transactions taking place in the db. The solution is to increase the size of the redo log files. Size them in such a way that there are about 4 log switches every hour.

  3. #3
    Join Date
    Nov 2000
    Your redologs are filling more frequently than Oracle can archive them to archival destination.

    Increase the size of redologs, but this may not solve the problem.
    You can increase the no. log groups also.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.