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

ITworld Answers

Ask a Question

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

dvarian 1 year ago

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

Tags: archive log, oracle database

Topic: Application Management

Answer this Question

Login or register to post answers
Permalink

Answers

3 total

Christopher Nerney 1 year ago

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.

Share this answer
Permalink

jimlynch 1 year ago

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

Share this answer
Permalink

rtrembley 1 year ago

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.

Share this answer
Permalink

Answer this Question

Ask a question

Choosing the best license for your open source software project

Getting the right license for your open source project can mean the difference between success and failure for your software.

HP brings converged infrastructure smarts to its servers

Tapping into the immense powers of system automation, Hewlett-Packard has released an appliance that will streamline the management of large numbers of HP servers in a data center.

Red Hat serves middleware to cloud developers

In a move to jump ahead of other PaaS (platform as a service) providers in the enterprise space, Red Hat will augment its OpenShift offering with a suite of middleware to ease the process of deploying cloud-based applications.

5 ways devops can benefit IT

Devops is about getting the people responsible for creating applications to work more closely with the people who maintain apps in production. The goal? Faster delivery, better quality apps.

Pentaho addresses data blending with updated business analytics platform

Once you've addressed storing and visualizing your data assets, the next step in harnessing the power of big data is blending operational data with data from other sources. Pentaho is seeking to smooth the path for organizations looking to do so with its new Business Analytics 5.0 platform.

Apple steps up their app store reviewing speed

App review times for both new and updated apps have been a major pain point for developers targeting the iOS/OSX platforms. With review times reaching upwards of 20 days, the consequences of submitting an app with a major flaw are serious. Lately however, review times have been down right speedy.

Salesforce.com mobile app developers gain security tools

Good Technology has integrated its Dynamics Secure Mobility Platform with Salesforce.com's Mobile SDK to help developers build mobile applications that are more secure and easily managed.

Amazon Web Services improves GovCloud management

Users of Amazon Web Services' GovCloud can now take advantage of CloudFormation, which aims to make it easier to manage more complex environments.

Software AG acquires JackBe for mashup tooling, real-time analytics

Software AG is adding mashup and real-time analytic capabilities to its lineup with the acquisition of JackBe. Terms of the deal, which was announced Thursday, were not disclosed.

Opscode adds networking to Chef management capabilities

Opscode has teamed up with Cisco Systems and Arista Networks to add networking features and has expanded its collaboration with Microsoft to broaden Windows integration for its renamed Enterprise Chef platform.