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

how is v$backup populated in mount stage?

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 3 Nov 2004 08:47:13 -0800
Message-ID: <d4d6f278.0411030847.60e3baac@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? Received on Wed Nov 03 2004 - 10:47:13 CST

Original text of this message

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