DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archive log issues.

  1. #1
    Join Date
    Aug 2008
    Posts
    123

    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?



    oracle: 11.2.0.1

    OS Windows

    2008 R2

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

    https://community.oracle.com/message/12384844#12384844

  3. #3
    Join Date
    Feb 2014
    Posts
    22
    Hi,

    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