Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

up vote 1 down vote accepted

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

share|improve this answer
    
Hi Jochen, I wonder why arhcive logs are generated if there is no change the my database? –  Sarith Sep 8 '09 at 9:12
    
Hello Sarith, every commit in the database generates a log - so I'm pretty sure there have been changes in the database. May be there are running some internal jobs, or changes from remote systems. A look into the logminer should give you some hints, where the changes are coming from. –  user12786 Sep 17 '09 at 12:05

Archive Logs are the Oracle equivalent of the Transaction Log in SQLServer. They should be a vital part of your backup strategy.

They are more correctly known as archived redo logs.

Oracle has a set of rotating log files that it uses to store the statements executed on the database. These existing in both archive and non archive mode.

In archive mode a redo log can only be reused once it has been archived. These are the files that you are seeing.

I'd suggest using RMAN to manage both your backups and archive log maintenance.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.