Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNTO TBS behavior in 9i

RE: UNTO TBS behavior in 9i

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Thu, 25 Jan 2007 14:20:38 -0500
Message-ID: <008101c740b5$e8211950$232b650a@nycwkswxp2829>


Bernard, you will not find it, there is no "X" that marks the block. You will RECONSTRUCT a consistent version of

The block by applying all "undo vectors" to a current or a consistent version of the block.  

Mladen Gogala
Sr. Oracle DBA
1500 Broadway, 6th floor
New York, NY 10036
(212) 329-5201
www.vmsinfo.com <http://www.vmsinfo.com/>

The Leader in Integrated Media Intelligence Solutions  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Polarski, Bernard Sent: Thursday, January 25, 2007 9:42 AM To: daniel.fink_at_optimaldba.com; adolph.tony_at_tiscali.de Cc: oracle-l
Subject: RE: UNTO TBS behavior in 9i  

As far as I know, you will find a before image of a block in the case of the first transaction that hits a block in a tablespace set in 'backup mode'.

Subsequent change to the block will only generate undo vectors. So there is at least a case where you copy a full before image of a block.

However this was true for 8i. I would be surprised if it has changed since as hot backup are rather deprecated in favor or Rman.  

Bernard Polarski

Oracle DBA  


--
http://www.freelists.org/webpage/oracle-l


image001.gif
Received on Thu Jan 25 2007 - 13:20:38 CST

Original text of this message

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