Re: Current online redolog corrupt!!!

If the thing is genuinely lost (and I have neither the time nor the inclination to check out error numbers for their precise text message), then you are in deep doo-doo.

The first thing you should do is take a backup.

The next thing you should do is restore all data files, but not the controlfile nor any online redo logs you might have floating around, from the last backup you've taken (you have taken backups, I hope?!).

Then you get to the MOUNT state (startup mount [pfile=...]).

Then you issue the command 'recover database until cancel', and when it prompts to apply redo, type the word 'auto'. All archives and online logs will be applied, automatically, until it can't read the contents of the offending log, at which point the recovery process will crash out with an error.

Then you issue the 'recover database until cancel' command once more, and when it prompts to apply the last log (presumably your current one), you type the word 'cancel'.

Then, you issue the command alter database open resetlogs, and the database should open. You'll have lost all transactions that were in the missing redo log.

Finally, you ask yourself why your online redo logs are not mirrored, and invest a little time and disk space in rectifying that problem pronto.

And given the resetlogs, you now have no valid backups nor archives, so its time to shut the entire database down cleanly, and perform a full, closed database backup.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"À̱âÅÂ(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.

>

>

>