Re: Help recovering from hotbackup

"Chucky" <chuck.carson_at_syrrx.com> wrote in message news:3E027239.1090004_at_syrrx.com...
>
> We are trying to restore from a hotbackup, we have all datafiles, the
> trace control file, and all archive logs. However, we did not back up
> the redo logs. We are trying to rebuild the control file and it is
> complaining about the redo logs.
>

I'm *sure* I've answered this at length just two days ago.

You don't have a backup of the online redo logs because they are never, ever, ever, ever, ever backed up. Doing so is meaningless and completely unnecessary, and under certain circumstances can induce data loss.

When you run the controlfile trace script, you need to make sure that it is the RESETLOGS version (assuming 9i -and if it isn't 9i, I explained in my earlier post precisely how to edit the single script produced in 8i so that it is a resetlogs variant). The resetlogs command re-creates missing online redo logs for you.

And I'm guessing that you still haven't downloaded the backup and recovery document I wrote, and posted about here two days ago either, because the issue is covered there (I'm sure).

Resetlogs, laddie. Resetlogs.

Regards
HJR
> Can anyone offer any suggestions?
>
> Thx,
> CC
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Thu Dec 19 2002 - 20:56:51 CST