Re: RMAN backup size is almost bigger twice than all of tablespace used size?
Date: Wed, 15 Nov 2023 23:25:53 +0800
Message-ID: <CABpiuuQEo60HfthhGp-gzKzHS4Wp+TJYRKHR5=Gej+mUsfdE4Q_at_mail.gmail.com>
Yes, the app developer colleague always deleted the table's history data interval by some day to make his business tablespace used-ratio being lower than 75%.
The previous behaviour caused this issue?
Best Regards
Quanwen Zhao
Pierre Labrousse <Pierre.Labrousse_at_digora.com> 于2023年11月15日周三 23:17写道:
> Hey,
>
> Rman only takes into account formatted blocks and not blocks never used,
> so if you drop or truncate a table its blocks are considered formatted and
> take into backupset even blocks are empty, this generally explains the size
> difference
>
> Best.
>
> *Pierre **LABROUSSE*
> * Consultant DBA ORACLE (OCM 10g/11g/12c)*
> *M*obile +33 (0)7 56 05 27 38
> *pierre.labrousse
> <https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d>**_at_
> <https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d>**digora.co
> <https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d>m
> <https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com>*
>
> ------------------------------
> *De :* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> de
> la part de Quanwen Zhao <quanwenzhao_at_gmail.com>
> *Envoyé :* mercredi 15 novembre 2023 15:14
> *À :* ORACLE-L <oracle-l_at_freelists.org>
> *Objet :* RMAN backup size is almost bigger twice than all of tablespace
> used size?
>
> Hello everyone!
>
> Recenty I've notice that there has oracle product system with 19.13, RMAN
> backup size is almost bigger twice than all of tablespace used size?
>
> Such as, all of tablespace used size is 600 GB and total size is 2500 GB,
> RMAN backup size (generated backup sets) is 1300 GB.
>
> Generally speaking, RMAN backup size is almost equal to all of tablespace
> used size.
>
> Firstly I suspect oracle recyclebin has occupied the massive data but the
> parameter recyclebin is off.
>
> Now I have to infer business tablespace has produced plenty of table
> fragments or HWM (High Water Mask) or discontinuous free data blocks.
>
> How to troubleshoot it for me? Any suggestion would be very appreciated!
>
> Best Regards
> Quanwen Zhao
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2023 - 16:25:53 CET