-
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
-
Originally Posted by gopu_g
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|