Archive log generation
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:- 220.127.116.11
Plat form:- Windows.
Ask him to check if Supplemental Logging is enabled..
Originally Posted by gopu_g
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.
thanks for the Suggestion.
Please see the output.
SQL> select SUPPLEMENTALLOGDATA_MIN from v$database;
Last edited by gopu_g; 08-27-2011 at 12:17 AM.
Click Here to Expand Forum to Full Width