archivelog error

From: Phil <pguan_at_sansia.net>
Date: Mon, 23 Apr 2001 12:28:00 -0700
Message-ID: <3AE48240.E88A44D1@sansia.net>

Hi,

I am not a DBA and know a little about Oracle. We have a DB with archive log enabled, for some testing purpose, we messed up archivelog file. I truned off the archivelog and cannot trun it on, and cannot open the database. This is a test database and has no data on it. Anyone can help me? Thank you.

Regards,
Phillip

Here are some info.

SVRMGR> archive log list;

Database log mode              No Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/admin/sunrcat/arch
Oldest online log sequence     234
Current log sequence           236

SVRMGR> alter database archivelog;
alter database archivelog
*

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

SVRMGR> recover database;

ORA-00283: recovery session canceled due to errors
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 58791 time 04/19/2001

07:49:23
ORA-00312: online log 2 thread 1:
'/u01/oracle/oradata/sunrcat/redo02.log'

SVRMGR> alter database open;
alter database open
*

ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 58800 time 04/19/2001 07:49:23
ORA-00312: online log 2 thread 1:
'/u01/oracle/oradata/sunrcat/redo02.log' SVRMGR> SVRMGR> select * from v$log;

GROUP#     THREAD#    SEQUENCE#  BYTES      MEMBERS    ARC
STATUS           FIRST_CHAN FIR

ST_TIM

---------- ---------- ---------- ---------- ---------- ---
---------------- ---------- ---
------
         2          1        236    1048576          1 NO
CURRENT               58363 19-
APR-01
         3          1        234    1048576          1 YES
INACTIVE              57660 18-

APR-01
2 rows selected.

SVRMGR> select * from v$logfile;
GROUP# STATUS MEMBER

-------

2 /u01/oracle/oradata/sunrcat/redo02.log

3 /u01/oracle/oradata/sunrcat/redo03.log

2 rows selected. Received on Mon Apr 23 2001 - 14:28:00 CDT