Home » RDBMS Server » Server Administration » too many archive log generation (oracle 11.2.0.1 RAC of two nodes,solaris10)
too many archive log generation [message #547799] Fri, 16 March 2012 12:54 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
on weekends we have too many archive logs generated .i have taken the data of a week and found that average archive log generated from monday to friday is 7 files per day but on satuarday and sunday the average is 60 files and FG1 gets full. on weekends we have all type of backups running like incremental,archival and logical backups and on sunday we have full physical backup

Can anyone guide what is the reason of too many archive log files generations at weekends. is it due to hot and logical backups , if yes then how ?


please guide

Regards

Report message to a moderator

Re: too many archive log generation [message #547800 is a reply to message #547799] Fri, 16 March 2012 12:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone guide what is the reason of too many archive log files generations at weekends.
DML results in REDO
DBMS_LOGMNR can reveal what is be changed.

>is it due to hot and logical backups , if yes then how ?
NO! backups are READONLY operations

Report message to a moderator

Re: too many archive log generation [message #547802 is a reply to message #547799] Fri, 16 March 2012 13:15 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
Are you putting your daabase into backup mode at any point?

Report message to a moderator

Re: too many archive log generation [message #547808 is a reply to message #547799] Fri, 16 March 2012 15:43 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
And what are the sizes of the archive log files?

Report message to a moderator

Re: too many archive log generation [message #547830 is a reply to message #547808] Sat, 17 March 2012 01:54 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
@John Watson, all backups run on satuarday i.e Incr_backup start at 4 pm and lasts for 23 hours and logical backup are of two types 1. schema level backup and table level backups , they run at 1225 pm on satuarday and 12 pm we also run archival backup and full physical backup run at 4 pm on sunday. these are in cronatb


@Joy_division, size is 66 gb


Regards

Report message to a moderator

Re: too many archive log generation [message #547831 is a reply to message #547830] Sat, 17 March 2012 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
@Joy_division, size is 66 gb


Each log file!?

Regards
Michel

Report message to a moderator

Re: too many archive log generation [message #547833 is a reply to message #547831] Sat, 17 March 2012 02:31 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
@ Michel , No, for all log files , each file is of 1G (this is for last weekend)


Regards

Report message to a moderator

Re: too many archive log generation [message #547834 is a reply to message #547833] Sat, 17 March 2012 02:33 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Are you putting your daabase into backup mode at any point?

Report message to a moderator

Re: too many archive log generation [message #547840 is a reply to message #547834] Sat, 17 March 2012 03:15 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
we are not putting our database in backup mode at any point as we are using rman

Report message to a moderator

Re: too many archive log generation [message #547886 is a reply to message #547840] Sun, 18 March 2012 03:17 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
No comments , any way i got my problem solved and reason was Automated Maintenance Task i. segment advisor which in the process create tables against tables containing LOB which is an oracle bug
and many redo files generated

follow this link for detail,
http://www.dbi-services.com/index.php/blog/entry/compression-advisor-excessive-redo-log-file-generation

hope someone have the same issue so might be helpful

Regards

Report message to a moderator

Previous Topic: problem with size during database creation
Next Topic: Undo tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 22:19:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.