Home » RDBMS Server » Server Administration » Arhive log file suddenly increased
Arhive log file suddenly increased [message #188327] Fri, 18 August 2006 01:34 Go to next message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi all

I got a strange questions,
my oracle database 8.0.2 got archive log file more than normal day, However, when I asked my user for usage, they didn't do heavy transaction on system. I check the alert log for finding problem, but it didn't show error in alert log, everything is looks normal. what make this happen? my db only have hot backup everyday without problem! any one have experience on this case!

ths

Marco

Report message to a moderator

Re: Arhive log file suddenly increased [message #188393 is a reply to message #188327] Fri, 18 August 2006 06:34 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Are any of your tablespaces in backup mode?

Report message to a moderator

Re: Arhive log file suddenly increased [message #188427 is a reply to message #188327] Fri, 18 August 2006 09:09 Go to previous messageGo to next message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi Frank

No backup mode in tablespace! tks!

Marco Embarassed

Report message to a moderator

Re: Arhive log file suddenly increased [message #188429 is a reply to message #188427] Fri, 18 August 2006 09:18 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Your best option would be to enable logminer to see what is in those log files.

Report message to a moderator

Previous Topic: how to resolve the error?
Next Topic: enabling archivelog mode in oracle 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:18:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.