Home » RDBMS Server » Server Administration » Archive log files generation (Oracle 11gr2,RHL 5)
Archive log files generation [message #606058] Sat, 18 January 2014 12:40 Go to next message
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
Re: Archive log files generation [message #606066 is a reply to message #606058] Sat, 18 January 2014 14:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Change the archive log destination.

Re: Archive log files generation [message #606067 is a reply to message #606058] Sat, 18 January 2014 14:06 Go to previous messageGo to next message
cookiemonster
Messages: 10961
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.
Re: Archive log files generation [message #606069 is a reply to message #606067] Sat, 18 January 2014 14:14 Go to previous messageGo to next message
BlackSwan
Messages: 22801
Registered: January 2009
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!
Re: Archive log files generation [message #606070 is a reply to message #606058] Sat, 18 January 2014 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Concepts

Re: Archive log files generation [message #606086 is a reply to message #606070] Sun, 19 January 2014 12:15 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you all for your answers and link.
Previous Topic: OCI can't Initialized
Next Topic: Oracle home directory full
Goto Forum:
  


Current Time: Mon Sep 22 21:25:32 CDT 2014

Total time taken to generate the page: 0.09324 seconds