Switch logfile hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Switch logfile hangs

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Switch logfile hangs

    Hi

    When we repeatedly give switch logfile command, DB is hanging after some 7 or 8 successful switches.

    But if we give manual checkpoint, log is switching. Then again it is hanging after some 5 or 6 successful runs.



    Database version 9.2.0.5
    Solaris

    log_checkpoint_interval 98000000
    log_checkpoint_timeout 3600
    log_checkpoints_to_alert TRUE

    Thanks

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    How big is the log file? And what is Checkpoint Interval..?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    and define hanging

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    Logfile size is 200mb, 4 groups of 2 members,
    Wait on--- switch logfile command.

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Quote Originally Posted by davey23uk
    and define hanging
    Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?
    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
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    Apr 2003
    Posts
    353
    Quote Originally Posted by SANJAY_G
    Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?

    It never completes. The wait clearly says "Waiting on log swich command"

    No. there is no data being written to the disk. I am manually giving switch log file command.

    Thanks

  8. #8
    Join Date
    Jun 2006
    Posts
    6
    pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.

  9. #9
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by RayaguruSD
    pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.
    Read the post first.... Will the manul switch work if the archivelog destionation is full..?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  10. #10
    Join Date
    Apr 2003
    Posts
    353
    If I give manual checkpoint, the hanging session completes with switch logfile command.

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