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 (27)

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 (26)

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 (24)

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.
Red Hat wants a piece of the enterprise mobile app market, so it has acquired Irish company FeedHenry for approximately €63.5 million (US$82 million).
VMware has upgraded desktop management tool Mirage with bandwidth control features and also published APIs to allow sharing of the data it collects.
Red Hat Satellite, the software for managing fleets of servers running Red Hat Enterprise Linux, can now also manage copies of RHEL that run in the cloud as well.
Chef, a popular open source software program for managing the configuration settings of servers, software and other IT components, now can reach deeper into the data center with the help of some intertwined services from Microsoft, VMware and Amazon Web Services (AWS).
Tibco's board of directors has begun a review of "strategic and financial alternatives," which presumably include a sale, the middleware vendor has confirmed following a news report of its plans.
Use your coding powers to raise money for a worthy cause, no ice water involved
Splunk's new App for Stream will give IT departments more insight into their infrastructures by collecting network traffic on response times, network performance and database queries.
It seems like there’s an app for everything these days, except when there isn’t
Watch out Oracle, Pivotal is offering a lighter alternative to the Java Enterprise Edition (JEE) stack.
SAP will resell software from Apigee in a move to help customers and partners build mobile applications, products and services that securely tap data from SAP systems.