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: Help recovering from hotbackup

Re: Help recovering from hotbackup

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 20 Dec 2002 22:44:19 -0000
Message-ID: <3e03a3a8_2@mk-nntp-1.news.uk.worldonline.com>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:DwvM9.6750$jM5.18883_at_newsfeeds.bigpond.com...
>
> "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
> =-----
>

Howard,

Go easy, please.

What happens if you lose all the online redo logs (yes I know they are supposed to be multiplexed)?

Yes, you can recover the database, but surely you lose the last few minutes worth of updates?

Regards,
Paul Received on Fri Dec 20 2002 - 16:44:19 CST

Original text of this message

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