ARG: Help recovering from hotbackup

[Chucky]

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.

Can anyone offer any suggestions?

Thx,
CC



-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
[url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

[Howard J. Rogers]

"Chucky" <chuck.carson@syrrx.com> wrote in message
news:3E027239.1090004@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

==----------

> [url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers

=-----

[Paul Brewer]

"Howard J. Rogers" <howardjr2000@yahoo.com.au> wrote in message
news:DwvM9.6750$jM5.18883@newsfeeds.bigpond.com...

>
> "Chucky" <chuck.carson@syrrx.com> wrote in message
> news:3E027239.1090004@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

> ==----------

> > [url]http://www.newsfeed.com[/url] 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

[Howard J. Rogers]

> Howard,

>
> Go easy, please.
>
> What happens if you lose all the online redo logs (yes I know they are
> supposed to be multiplexed)?

Actually, there's only ever one online log (OK, maybe briefly two, whilst
one's being checkpointed). The other 'online logs' have of course already
been backed up. That's what ARCH does.

> Yes, you can recover the database, but surely you lose the last few

minutes

> worth of updates?
>

Entirely true. But so what? That's not an argument for backing up the
online logs, is it? It's rather an argument for multiplexing.

Suppose you backup the online logs, against all Oracle's advice, RMAN's
in-built capabilities, and my repeated entreaties not to. That was last
night. How is restoring a 9-hour old 'online log' going to help you *not*
lose the last transactions that were contained in the real-life online logs?

If you lose your online logs, you have absolutely no alternative but to do a
'recover until cancel', cancel when it prompts you for what you know to be
the missing logs, and then open resetlogs. At which point you get your
online logs back... but, yes, missing the last dollop of redo, and hence
with some lost transactions.

The *only* thing you can do to prevent that is multiplex.

Backing up the online logs doesn't help at all.

Cheers
HJR

> Regards,
> Paul
>
>
>

[Paul Brewer]

"Howard J. Rogers" <howardjr2000@yahoo.com.au> wrote in message
news:osNM9.7412$jM5.20748@newsfeeds.bigpond.com...

> > Howard,
> >
> > Go easy, please.
> >
> > What happens if you lose all the online redo logs (yes I know they are
> > supposed to be multiplexed)?

>
> Actually, there's only ever one online log (OK, maybe briefly two, whilst
> one's being checkpointed). The other 'online logs' have of course already
> been backed up. That's what ARCH does.
>

> > Yes, you can recover the database, but surely you lose the last few

> minutes

> > worth of updates?
> >

>
> Entirely true. But so what? That's not an argument for backing up the
> online logs, is it? It's rather an argument for multiplexing.
>
> Suppose you backup the online logs, against all Oracle's advice, RMAN's
> in-built capabilities, and my repeated entreaties not to. That was last
> night. How is restoring a 9-hour old 'online log' going to help you *not*
> lose the last transactions that were contained in the real-life online

logs?

>
> If you lose your online logs, you have absolutely no alternative but to do

a

> 'recover until cancel', cancel when it prompts you for what you know to be
> the missing logs, and then open resetlogs. At which point you get your
> online logs back... but, yes, missing the last dollop of redo, and hence
> with some lost transactions.
>
> The *only* thing you can do to prevent that is multiplex.
>
> Backing up the online logs doesn't help at all.
>
> Cheers
> HJR
>
>
>

> > Regards,
> > Paul
> >
> >
> >

>
>

Howard,

Sorry, I didn't phrase the question properly. I meant to ask: 'What happens
if you lose all the (multiplexed) members of the current online redo log'?

But you have already answered the question.

Thanks,
Paul