error occured during oracle redo log archival
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: error occured during oracle redo log archival

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    My DB is in Archivelog mode on Oracle 8 (on win NT) and
    I am getting below warning message frequently since last 7 days.


    -------message

    \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

    ----------end

    After pressing enter it will continue.

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

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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
    Posts
    224
    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