DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008

    Archive log issues.

    This question is Not Answered.(Mark as assumed answered)
    1830597 Newbie
    1830597 Apr 17, 2014 10:03 AM

    All of a sudden, we are experiencing 100x the number of archived logs switch

    Does anyone have ideas on how to identify what is causing so many archived logs?


    OS Windows

    2008 R2


  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    I am guessing that this is you as well. To add to what was said on the other post, you probably
    want to check for new cron, dbms_job and dbms_scheduler jobs. If you are licensed, try
    running either an ASH report or an AWR report. You can also look at log miner to see what
    changes are in the redo.

    this space intentionally left blank

  3. #3
    Join Date
    Feb 2014

    Did you check the archive_lag_target whether there is a change there?
    Did you check the v$archived_log if there is a decrease in size of your logfiles assuming that you are in achivelog mode?
    Did you, for some reason create/recreate redologfiles and made them smaller?
    Is there any development department at your company and did you contact them to see if there are made any changes or if there is added any programming regarding packages, procedures, triggers..... that are involving a lot of updates?
    Do you have auditing on your database and did it, by any change increase rapidly?
    Was your database is in force logging mode and if not do you have a lot of nologging tables, tablespaces, queries and did you check whether the database was put into force logging mode?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.