OraFAQ Forum: Server Administration » Archive log files generation

Home » RDBMS Server » Server Administration » Archive log files generation (Oracle 11gr2,RHL 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Archive log files generation [message #606058]

Sat, 18 January 2014 12:40

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

Archive log destination is getting filled fastly in /u01 mount point .Rather than moving archive log files to some other mount point where space is available and removing the old archive log files from archive log destination to free up the space , is there any other way to stop archive log files getting generated and fix this issue ?

Regards,
jack

Report message to a moderator

Re: Archive log files generation [message #606066 is a reply to message #606058]

Sat, 18 January 2014 14:06

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Change the archive log destination.

Report message to a moderator

Re: Archive log files generation [message #606067 is a reply to message #606058]

Sat, 18 January 2014 14:06

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Only if you have a process that is modifying more data than necessary to get the job done. Otherwise it's generating the amount of archive log necessary for your workload and you're just going to have to allocate more space.

Report message to a moderator

Re: Archive log files generation [message #606069 is a reply to message #606067]

Sat, 18 January 2014 14:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is there any other way to stop archive log files getting generated and fix this issue ?
ARCHIVE LOG files come from REDO.
REDO comes from DML.
eliminate DML & then no more archive log files are generated; so make database READ ONLY & problem is solved!

Report message to a moderator