Home » RDBMS Server » Server Administration » maxloghistory
maxloghistory [message #53818] Sun, 13 October 2002 12:26 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Hi,
This site helped me enormously on occassions, and now I hope somebody can help me again.
As a new (not too experienced dba) I inhereted a few sites in my new job. I noticed in an oracle 8.0.6.1.0 database the following:
When I do "alter database backup controlfile to trace;" command, i see that MAXLOGHISTORY is at the value of 1463, I do not know where this number comes from.
But when I look at v$archived_log, the number of records is 1320.
Now, everyday, about 5 archived redo logs are created.
Thus it mean that in a few weeks time I have a big problem because the oracle system will only "know" of 1463 redologs?
I do not understand it.
Can somebody please explain?
Thanks !

Report message to a moderator

Re: maxloghistory [message #53830 is a reply to message #53818] Mon, 14 October 2002 07:00 Go to previous messageGo to next message
noor
Messages: 20
Registered: October 2002
Junior Member
Hello,

You will not have a problem when you reach 1463 redologs (archived redologs). In the sys.v_$archived_log, you will see only the last 1463 archived logs.

Hope this helps ...

NOOR

http://www.islamway.com/eng/html/invitation.php

Report message to a moderator

Re: maxloghistory [message #53834 is a reply to message #53830] Mon, 14 October 2002 10:08 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
It certainly helps! I was a bit scared you know.
Thank's a lot !

Report message to a moderator

Previous Topic: setting log_archive_duplex_dest to a network path fails
Next Topic: how to update part of the column data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:29:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.