Can not allocate log, archival required
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Can not allocate log, archival required

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    Can not allocate log, archival required

    Hi

    One of my database runs in no archive log mode..but in the alert log i am seeing teh following message

    ARCH: Connecting to console port...
    Thread 1 cannot allocate new log, sequence 8
    All online logs needed archiving

    can anybody explain why this thing is goin no ??

    regards
    Hrishy

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I noticed some starnge things too..

    when i say

    SVRMGR> archive log list
    Database log mode Archive Mode
    Automatic archival Disabled
    Archive destination /apps/home/ora817/dbs/arch
    Oldest online log sequence 5
    Next log sequence to archive 8
    Current log sequence 8

    but in the parameter file it is somethin like this

    # Uncommenting the lines below will cause automatic archiving if archiving has
    # been enabled using ALTER DATABASE ARCHIVELOG.
    # log_archive_start = true
    # log_archive_dest_1 = "location=/apps/home/admin/tixh/arch"
    # log_archive_format = arch_%t_%s.arc

    regards
    Hrishy

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Hrishy,
    Are you sure this database is in NOARCHIVELOG mode? I believe it is in ARCHIVELOG.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sanjay

    Please see my above paraneter file and teh archive log list they surely tell me different stories..whats goin on ?

    regards
    Hrishy

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    It is running in ARCHIVELOG mode. You will have to set it manually to NOARCHIVELOG.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sanjay

    Thanks..well i must confess..just todau i learnt something new ..i was under the impression that modes of operation of the database was mentioned in the init.ora file..whereas switching modes has nouthing to do with init.ora...

    i can switch modes like this

    alter databse archivelog

    alter database noarchivelog..

    and teh archive log files are being generated at $ORACLE_HOME/dbs directory..even though this directory is not mentioned in the init.ora file

    regards
    Hrishy

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by hrishy
    Hi
    SVRMGR> archive log list
    Database log mode Archive Mode
    Automatic archival Disabled
    Archive destination /apps/home/ora817/dbs/arch
    Oldest online log sequence 5
    Next log sequence to archive 8
    Current log sequence 8

    As automatic archiving is disabled you have to manually archive to archive log destination.

    You must also check the parameter file that it is reading when starting the instance. You could also specify the parameter file to be used, to avoid doubts on which is being used.

    HTH.
    Last edited by ggnanaraj; 03-12-2003 at 01:35 AM.

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Is there any view through which i can check the location and the name of parameter file did my database use when it started up ?soemthing like show parameter paranmeter file

    regards
    Hrishy

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by hrishy
    and teh archive log files are being generated at $ORACLE_HOME/dbs directory..even though this directory is not mentioned in the init.ora file

    regards
    Hrishy
    I guess that is the default archive directory for *nix
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  10. #10
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    $ORACLE_HOME/dbs is the location that Oracle will use to retrieve the pfile during startup unless otherwise explicitly specified
    (i.e. startup pfile=/path1/path..n/mypfile.ora)

    As for the current parameters in effect for this startup of the database, refer to the v$parameter view.
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

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