Re: Oracle IMP Hangs

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 1 Mar 2004 10:36:30 -0500
Message-ID: <9ZGdnVj7ErMYxd7dRVn-sA_at_comcast.com>


"Mike Morris" <morrisma_at_ei.dupont.com> wrote in message news:3b2c6993.0403010625.1e5070ca_at_posting.google.com...
| More help is definately needed!
| I am (fairly obviously) new to oracle.
| The imp process certainly "seems" to hang and has to be killed to
| recover the terminal.
| This is what is in the alert log:
|

you've got diskspace problems, ie., no space left for archive logs:

| Mon Mar 1 09:07:53 2004
| ORACLE Instance cyrel - Can not allocate log, archival required
| Mon Mar 1 09:07:53 2004
| ARCH: Connecting to console port...
| Thread 1 cannot allocate new log, sequence 441
| All online logs needed archiving
| Current log# 2 seq# 440 mem# 0: /u02/oradata/cyrel/redo02.log

this will cause the database to hang (for any transaction) until disk space is available for archving

are you familiar with oracle archiving and managing the archive logs?

;-{ mcs Received on Mon Mar 01 2004 - 16:36:30 CET

Original text of this message