Database run in archive log mode

oracle

I'm using Oracle 11g on RHEL 5.
I've created one database with no archivelog.
After doing offline migration from SQLSERVER to ORACLE, I've changed this database to run in archive log mode.

My database is running normally and I'm sure that there is no change to the database, but I wonder why it generates many archive files (about 1GB a day).

Do you have any idea?

Regards,

Sarith

Best Answer

for a busy production database, 1GB of logs is quite small (I have databases with 100GB of logs or more per day). Anyway, if you want to know, what is in the logs, you should have a look at the Oracle LogMiner:

http://www.oracle.com/technology/oramag/oracle/05-jul/o45dba.html

Jochen