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
Christopher Nerney
Vote Up (25)

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.

jimlynch
Vote Up (25)

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

rtrembley
Vote Up (22)

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.
Teradata has bought the assets of Revelytix and Hadapt in a bid to grow out its capabilities for the Hadoop big-data processing framework.
Beginning this fall, French primary school students will have the option of learning computer science
Bank of America illegally copied US$300 million worth of Tibco's enterprise software for use in a massive IT project at its Merrill Lynch subsidiary, Tibco alleges in a lawsuit.
A new GitHub repo is collecting the life lessons that one can learn from programming
If it weren't enough of a challenge for IT architects and system managers to glue enterprise systems together, they must also now worry about connecting their systems to mobile and Web applications as well.
The .NET framework is an excellent platform if you’re a developer. Less so if you’re a system administrator. Deployment of .NET applications from the developer’s machines to a server environment just about always leads to a yellow screen of death while you sort out version and configuration issues. With ASP.NET vNext, things are about to get a whole lot better.
Supercomputer vendor Cray is trying to make the Lustre file system easier to work with, allowing users to copy material from the file system into a multilayered storage archiving system.
Apache Mesos, a software package for managing large compute clusters that's been credited with helping Twitter to kill its Fail Whale, is being primed for use in the enterprise.
A couple of things became clear during SAP co-founder Hasso Plattner's keynote at the Sapphire conference Wednesday: SAP remains fully committed to the Hana in-memory computing platform, as well as its push into SaaS (software as a service).
As it preps Oracle Enterprise Manager to run private clouds, Oracle has released an update to the management software that offers the ability for organizations to offer production-ready databases as a service.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+