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

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN: What blocks are backed up with a full backup?

RMAN: What blocks are backed up with a full backup?

From: Keith Moore <kmoore7_at_jcpenney.com>
Date: Thu, 03 Apr 2003 08:43:54 -0800
Message-ID: <F001.0057979D.20030403084354@fatcity.com>


Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know that it backs up all blocks that have "ever been used", but I'm trying to figure out exactly what that means. My first thought was that it backs up all blocks below the HWM, but I analyzed the tables and that is not the case.

Sometimes it backs up more blocks than exist below the HWM for the tables and sometimes it backs up fewer blocks than those below the HWM.

We are doing this to determine what we can do to reduce the size of the backup.

Anyone have an idea how this works?

Keith


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Keith Moore
  INET: kmoore7_at_jcpenney.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 03 2003 - 10:43:54 CST

Original text of this message

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