DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Can not allocate log, archival required

Threaded View

  1. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I assume you have automatic archiving enabled for your database.

    Have you checked the disk space on your archlog destination? It might be full. If so, make some room in it and archiving will continue.

    If this isn't the case or if emptying the archlog destination doesn't help, try the following:

    ALTER SYSTEM ARCHIVE LOG STOP;
    ALTER SYSTEM ARCHIVE LOG START;

    In any case, you won't loose any data becouse of this error. In fact, this error actually prevents you from potentialy loosing data in case media recovery will be needed in the future....
    Last edited by jmodic; 01-14-2003 at 07:04 AM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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