Re: how is v$backup populated in mount stage?

Comments embedded.

• Original Message ----- From: "John Hurley" <johnbhurley_at_sbcglobal.net> Newsgroups: comp.databases.oracle.server Sent: Friday, November 05, 2004 9:43 AM Subject: Re: how is v$backup populated in mount stage?

>> > I have specific test cases that show oracle in a mount state
"appears"
>> > to read and get this information from data files (since swapping
in
>> > and out control files does not change what is returned).
>> >
>> > Oracle documentation as such tends to infer that only the
pfile/spfile
>> > and control files are processed in mount stage.
>> >
>> > I am beginning to think that based on queries made at mount
stage,
>> > some parts of oracle software may look beyond the pfile/spfile
and
>> > control files.
>
>> On what? What precisely is your problem? What precisely are your
>> observations? What precisely is the point?
>
> What observations do you not understand? The sentences directly above
> your reply along with my original post are pretty clear.
>

The quote from Howard was in reference to the part of YOUR text you so judiciously snipped, mainly regarding the opening of a TAR simply because you don't understand some concept of how Oracle functions:

> > Probably will open a tar eventually if no one can shed any more light
> > on this.

It had nothing to do with the portion to which YOU erroneously (and intentionally) atribute it. See the full post from Howard at the end of this to illustrate your attempted literary 'sleight of hand'. So, why is THAT portion of your post missing???

> If you do not have any relevant knowledge to contribute why respond?
>

That you cannot comprehend the responses from Howard J. Rogers is not his fault, as he has provided PLENTY of relevant knowledge to your 'problem'. Your ludicrous and inane suggestion of opeing a TAR proves you cannot grasp the concepts Howard has put forth. Possibly the subject is too deep for you.

>> If you are just idly curious, then best take it Oracle since they
get paid
>> for that sort of thing.
>
> I already said that.

Here is the original post you chose to edit in an effort to discredit Howard J. Rogers. I believe all will see the manipulation you're trying to pull off and call you on it, as I did:

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<418ad8c3$0$32443$afc38c87_at_news.optusnet.com.au>...
> "John Hurley" <johnbhurley_at_sbcglobal.net> wrote in message
> news:d4d6f278.0411041708.259f2da9_at_posting.google.com...
> >> It's obvious that the information about whether something is in hot
> >> backup
> >> mode or not is stored within the data files themselves. If it were
> >> otherwise, then crashing your instance in the middle of a hot backup
> >> would
> >> not result in 'file 6 needs media recovery' errors, because having
> >> noticed
> >> file 6's checkpoint change number was out of synch, the control file
> >> would
> >> have been able to say 'but don't worry about it, because I know that file
> >> is
> >> in hot backup mode'.
> >>
> >> The fact is, you *do* get such error messages, therefore the control file
> >> cannot be the source of information about whether something is in hot
> >> backup
> >> mode or not.
> >
> > Proving something (or not) with specific test cases rather than
> > deducing and speculating based on your example above is my preference.
>
> Well, it's not a deduction or speculation. Try dumping some blocks...
>
> >> Since no-one these days should be doing O/S-style backups, however, the
> >> issue is akin to worrying about angelic hosts, terpsichore, and small
> >> sharp
> >> metal objects.
> >
> > You lost me with those remarks.
>
> They're just words. They have meaning. You shouldn't be lost.
>
> > My observation is based on some funny things noticed in an RMAN backup
> > and recovery scenario I am looking at.
>
> Well then: post the details of that instead of just posting an apparently
> frivolous question about internals that is not worth worrying about!
>
> Capture the "funny things" and post them here.
>
> > I have specific test cases that show oracle in a mount state "appears"
> > to read and get this information from data files (since swapping in
> > and out control files does not change what is returned).
> >
> > Oracle documentation as such tends to infer that only the pfile/spfile
> > and control files are processed in mount stage.
> >
> > I am beginning to think that based on queries made at mount stage,
> > some parts of oracle software may look beyond the pfile/spfile and
> > control files.
> >
> > If that's the case, what queries cause these actions under what
> > circumstances seems to be an undocumented feature.
> >
> > It's somewhat of a puzzle that I thought some people might have solved
> > or have specific knowledge of.
> >
> > Probably will open a tar eventually if no one can shed any more light
> > on this.
>
> On what? What precisely is your problem? What precisely are your
> observations? What precisely is the point?
>
> If you are just idly curious, then best take it Oracle since they get paid
> for that sort of thing.
>
> HJR
David Fitzjarrell Received on Fri Nov 05 2004 - 13:31:15 CST