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
    Oct 2000
    Posts
    24

    Question Cannot allocate log. Archival required

    Hi Everybody,

    Happy Hoildays


    I running oracle 8.03 on winnt 4.0 box and get the following error message

    ORACLE Instance md - Cannot allocate log. Archival required
    Press to acknowledge message


    Can any one help please

    Thanks in advance


    Vinay

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    You need to add more redo log groups. The current redo logs are full and have not been archived when the systems is trying to use the log.

    Add new log group and it should resolve the issue.

  3. #3
    Join Date
    Oct 2000
    Posts
    24
    how do I add redo log files. I can not even log into the database

  4. #4
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    Did u try through svrmgrl uyility

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    sounds like LOG_ARCHIVE_START is set to false? is it, if it is you need to manually archive your logs, you should set this to true unless you have a specific reason to set it to false
    I'm stmontgo and I approve of this message

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