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

Thread: Archive log generation

Hybrid View

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    Archive log generation

    Hi All,

    I have a scenario here, which my friend is facing
    Recently one of their database is migrated from 10G to 11G.
    Before migration, per day 10Gb archives logs were generating and after the migration the archive log generation is 100Gb per day. Business transaction is normal and there is no increase.

    Does anybody have some idea what is behind this behaviour of the database ?

    Oracle database version:- 11.2.0.1
    Plat form:- Windows.
    Thanks/Gopu

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by gopu_g View Post
    Hi All,

    I have a scenario here, which my friend is facing
    Recently one of their database is migrated from 10G to 11G.
    Before migration, per day 10Gb archives logs were generating and after the migration the archive log generation is 100Gb per day. Business transaction is normal and there is no increase.

    Does anybody have some idea what is behind this behaviour of the database ?

    Oracle database version:- 11.2.0.1
    Plat form:- Windows.
    Ask him to check if Supplemental Logging is enabled..
    Code:
    SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    thanks for the Suggestion.

    Please see the output.

    Code:
    SQL> select SUPPLEMENTALLOGDATA_MIN from v$database;
    
    SUPPLEME
    --------
    NO
    Last edited by gopu_g; 08-27-2011 at 12:17 AM.
    Thanks/Gopu

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