Re: How to apply archive logs on an cold backup

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:41357b42$0$1876$afc38c87_at_news.optusnet.com.au...
> Bob Jones wrote:
>
> >
> > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> > news:41351d6f$0$9811$afc38c87_at_news.optusnet.com.au...
> >> Bob Jones wrote:
> >>
> >> >
> >> > "robson" <dbanewbie_at_yahoo.com.br> wrote in message
> >> > news:514f866a.0408311326.68c5d22d_at_posting.google.com...
> >> >> i have the database with archive log and one cold backup.
> >> >> how to apply archive log in cold backup?
> >> >>
> >> >> thanks,
> >> >> robson
> >> >
> >> > You can specify "RECOVER DATABASE...USING BACKUP CONTROLFILE". This
> >> > will allow you roll forward to a point of your desire.
> >>
> >> Please don't post complete nonsense.
> >>
> >
> > Okay, let's see who is posting nonsense here.
> >
> >> The 'using backup controlfile' clause should only be specified if
that's,
> >> strangely enough, actually what you're using. Unless he restores his
> >> control files from backup, it would be lunacy to use the clause.
> >>
> >
> > How do you know it was not an option for OP to use a backup controlfile?
>
> "Option". Show me where in your post you indicated that you were giving
the
> original poster an 'option'. Or that you'd detailed all the other
different
> ways he could recover that did NOT involve using a backup control file and
> issuing a resetlogs.
>

I don't need to give OP all the options for recovery. That was not what he asked for. His question was very specific - HOW TO APPLY ARCHIVE LOGS TO A COLD BACKUP. Which part of that don't you understand?

>
> > Please explain how I mislead people by giving such a simple direct
answer
> > to a simple question.
>
> Because the correct answer to his question is: the temperature of your
> backups makes no difference to how you recover your database. Therefore,
> all the standard recovery methods are available.
>

This is a correct statement but not the answer to OP's question.

> Your answer was misleading because it told him how to perform ONE type of
> recovery without once mentioning the multiple other types, and without
> mentioning the severe risks and inconveniences incurred by his using it.
>
> I suppose you could indeed call your answer simple. It is after all the
root
> of the word 'simpleton'.
>
> > I think nothing is more misleading than providing
> > answers irrelevant to the question.
>
> Then do yourself and everyone else a favour by not doing so.
>

Yes, I prefer simplicity. Unnecessary complexity is the cause of most screwups. You should go back and read OP's question again. Received on Wed Sep 01 2004 - 13:51:07 CDT