ORA-16014: log 3 sequence# 492 not archived

Hi...
we recently installed an Oracle10g on a Redhat box with 2 processors. Everything went pretty smooth, we even made a full import of our old database.
We delete all the users(except system, sys, dbnsmp etc..) from the database and tried to make a new full import. The problem is that at some point of the import the database hangs...

I try to shutdown the database but it says that the database is already in
that process...
So, I do a a shutdown abort, that works ok, and then try to startup the database again, but I get the following error:

ORA-16014: log 3 sequence# 492 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/u02/oradata/database/redo03a.log'
ORA-00312: online log 3 thread 1: '/u03/oradata/database/redo03b.log'

I know how to clear this error(temporary), I just type the following command:

alter database clear unarchived logfile group 3;

after that everything is working again, the problem is that I can't issue a full import because of the redologs got out of space or something...
Also, yesterday we didn't tried a full import, nobody is using the database and
today we are facing the same problem, but with the log 2 any advice on this?
thanks in advance...
regards,
-eduardo s.m. Received on Thu Mar 03 2005 - 09:14:29 CST