Re: Oracle IMP Hangs
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