Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Current online redolog corrupt!!!

Re: Current online redolog corrupt!!!

From: ls cheng <g-e-n-o_at_europe.com>
Date: 25 Oct 2001 12:38:24 -0700
Message-ID: <b352e1b3.0110251138.9aaf2b9@posting.google.com>


try

alter database clear logfile 'LOGFILE_NAME'

if you are lucky you might be gte over it

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ttfnce1jcrpqf8_at_corp.supernews.com>...
> "À̱âÅÂ(Kitae Lee)" <kitaelee_at_itnc.co.kr> wrote in message
> news:0oQB7.111$cI6.156340_at_news.bora.net...
> > Hi,
> >
> > My DB lost current online redo log.
> >
> > If "startup" the DB, get message ORA-00333.
> >
> > My DB has three redo log groups.
> >
> > That redo log is not mirred.
> >
> > My system is running in Archive Mode.
> >
> > But, I have any cold backups.
> >
> > What can I do?
> >
> > Help me.
> >
> >
> >
> If you have cold backups and have the archive logs you can recover
> If you have hot backups and have the archive logs you can recover
> If you don't have any backup and also don't have any export, this will be
> the end of your database.
>
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA
>
>
>
> Then you are SOL
Received on Thu Oct 25 2001 - 14:38:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US