What happens when the archive log directory becomes full in Oracle Database 10g?

dvarian

I'm still learning my way around Oracle Database. How does it handle it if the archive log directory becomes full?

Answer this Question

Answers

3 total
jimlynch
Vote Up (20)

I was not able to find information related to this directly. You might want to check out Oracle's support center, however. There's probably some info there related to this that could prove helpful to you.

http://www.oracle.com/us/support/index.html

Christopher Nerney
Vote Up (19)

Here's a blog post by an Oracle Certified Professional that seems to address this issue. The post is three years old, but it probably is applicable today. He lists six steps you can take.

http://parthokonar.wordpress.com/2009/08/26/archive-log-full-in-oracle/

Good luck, dvarian.

rtrembley
Vote Up (16)

After the directory becomes full, the next time database tries to write an archive log it will suspend database activity, and will stay suspended until there is enough space available for a new file.  If you are looking for a decent beginners guide to Database, there is a book that Oracle Press puts out called, creatively, Oracle Database 10g, A Beginners Guide.  You might find it useful.  

Ask a question

Join Now or Sign In to ask a question.
Big data analytics are driving rapid growth for public cloud computing vendors with revenues for the top 50 public cloud providers shooting up 47% in the fourth quarter last year to $6.2 billion, according to Technology Business Research Inc.
Red Hat is looking to advance the Docker Linux container application for wider enterprise use.
Updating its platform for the hyper-connected cloud era, Tibco has equipped the new version of its flagship application-integration software with the ability to communicate with external applications.
Software asset management and software license management aren't just for on-premises assets. Find out how they can help you ensure compliance with software policies and agreements across mobile devices as well.
Enterprise search software provider LucidWorks has introduced a package based on its open-source Apache Solr search engine that will allow administrators and business analysts to extract more information from IT system logs.
In today's accessible technology roundup: A new group for accessible technology professionals is formed, Texas middle schoolers design an app for the blind to navigate indoor spaces and web developers are warned against relying too much on ARIA
In today's accessible technology roundup: The W3C makes ARIA an official recommendation, Apple adds a new accessibility feature to iOS 7.1 and why Google’s removal of link underlines could hurt accessibility
Serena Software founder Doug Troxel is teaming up with private equity firm HGGC to purchase the application development software vendor from Silver Lake Partners. Terms of the deal, which was announced Monday, were not disclosed.
With Google Glass starting to pick up steam, Sony doesn't want to get left too far behind.
When it comes to shutting down out-of-date, risky or unnecessary applications, James Gordon, vice president of technology and operations at Needham Bank, doesn't mess around.

White Papers & Webcasts

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+