Redo Logfile and Archiving Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Redo Logfile and Archiving Problem

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    Redo Logfile and Archiving Problem

    I have an Oracle 9.2.0.6. database running on Solaris in archivelogmode.

    For some reason the UNDO tablespace is filling up and doesn't seem to empty, while the redo logfiles (after filling up) don't write to the archivelogs leading to a standstill of the instance. There is still loads of disk space that the archivelogs could be written to and the init ora parameters are set to sensible values.

    After restarting the instance, the UNDO tablespace is still pretty full.

    Could this have something to do with very large transactions that continue to process data beyond the capacity of the UNDO tablesoace and the redo logfiles, or what could possibly cause this?

  2. #2
    Join Date
    Jun 2005
    Posts
    31

    Re: Redo Logfile and Archiving Problem

    Originally posted by Peer Jones
    I have an Oracle 9.2.0.6. database running on Solaris in archivelogmode.

    For some reason the UNDO tablespace is filling up and doesn't seem to empty, while the redo logfiles (after filling up) don't write to the archivelogs leading to a standstill of the instance. There is still loads of disk space that the archivelogs could be written to and the init ora parameters are set to sensible values.
    select * from v$log;
    show parameter arch;
    archive log all;
    select * from v$log;
    archive log start;

    Any Errors in the alert-log ?

    After restarting the instance, the UNDO tablespace is still pretty full.

    Could this have something to do with very large transactions that continue to process data beyond the capacity of the UNDO tablesoace and the redo logfiles, or what could possibly cause this?
    Very likely - You never should run "special" (huge) transactions without ESTIMATING the archivelog-amount and undo-space required, if you don't have sufficient experience, than you need to test it in a fully-sized pre-production environment.

    Please read the chapter about "Undo-Segments" in the CONCEPTS-Manual - this manually is REALLY GREAT to achive understanding.

    Are you running the new automated undo-management or the old Rollback-Segments (both have advantages ...)

    show parameter undo

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Thanks for the reply, but I've just checked all parameters and found out that the 'change session' statements hadn't been written to the spfile, so that the problem started when the instance was restarted.
    It works now.
    Bye
    Peer

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