Try this in svrmgrl:
shutdown immediate
startup mount
alter database archivelog;
alter database open;
"Phil" <pguan_at_sansia.net> wrote in message
news:3AE48240.E88A44D1_at_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:56:25 CDT