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 32 weeks 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

rtrembley 32 weeks 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

Christopher Nerney 32 weeks 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 32 weeks 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

Answer this Question

Ask a question

ESB Persists As Application Integration Tool

The tried-and-true enterprise service bus--long the foundation of now-dated service oriented architecture deployments--is back in style thanks to the increasing need to integrate disparate applications. The secret to ESB's future success, some say, is a close tie to API management tools.

Spiceworks' free management software gets integrated MDM

Spiceworks has teamed up with Fiberlink to add mobile device management functionality to the next version of its free network and IT management software.

SAP offers mobile device management for €1 per month on Amazon's cloud

A new cloud version of SAP's Afaria mobile device management software offers IT departments a more convenient way of controlling mobile devices.

Google revamps admin console for Apps and other enterprise products

Google is rolling out a new IT administration console for its Apps email and collaboration cloud suite and for other enterprise products such as Maps Coordinate and Chrome OS devices.

How app wrapping works

BYOD brings out the classic problem between control of corporate information and individual freedom. It kicks it up to a whole new level because the devices belong to the users, but at least some of the apps and information belong to the company and as such need protection and policy enforcement.

BMC set to go private in $6.9 billion deal

BMC has agreed to be acquired by a private investment consortium headed by Bain Capital and Golden Capital, in a deal worth about US$6.9 billion.

A10 airs Thunder line of ADCs, along with more DDoS protection

A10 Networks this morning announced a new line of application delivery controllers -- distinct from the existing AX series -- dubbed "Thunder," saying that the new units offer more capacity in a smaller footprint.

IBM launches an appliance for the 'Internet of things'

Preparing its customers to join the emerging 'Internet of things', IBM has released a new appliance built to manage and route a voluminous amount of machine-to-machine small data messages

OASIS: MQTT to be the protocol for the Internet of Things

Setting the foundation for what may be a multitrillion-dollar marketplace, OASIS (the Organization for the Advancement of Structured Information Standards) has declared MQTT (the Message Queuing Telemetry Transport) as its messaging protocol of choice for the emerging Internet of Things.

Barracuda swims with other big fish in ADC market

Barracuda Networks dove into the application delivery controller market Tuesday, announcing both physical and virtual editions of a new ADC platform designed to blend the company's existing load balancing and security offerings with optimization capability.