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: how is v$backup populated in mount stage?

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

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 4 Nov 2004 03:29:08 -0800
Message-ID: <d4d6f278.0411040329.9686b8f@posting.google.com>


> Scenario: instance is in mount stage using a control file that was
> either copied (rman) when database had no tablespaces or all
> tablespaces in backup mode.
>
> Queries against v$backup always return correct status (ACTIVE or
> opposite) even when control files are switched back and forth.
>
> It sure seems like the query is tacking a peek at the header of each
> datafile and getting the backup status from there instead of from the
> control file (where I was expecting it to be from ... aka potentially
> incorrect).
>
> Not complaining -- the info being returned is correct. Probably just
> my understanding of mount stage needs refining.
>
> Under what conditions/circumstances does oracle in mount stage
> actually look at datafiles?

Anyone? I can post examples and test cases and will eventually but thought some of the gang here might already have an answer. Received on Thu Nov 04 2004 - 05:29:08 CST

Original text of this message

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