Hi,
It doesn't work. Thanks.
Chuck Hamilton wrote:
> 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 - 15:13:24 CDT
