Hello,
experts
Today,I suddenly found that RMAN full backup of Oracle DB's size is much larger than all of tablespaces total used.
My check process is as follows,
Firstly,there has tablespace info below,
SYS@orcl29> SELECT
2 tablespace_name "Tablespace",
3 d.STATUS "Status",
4 TO_CHAR((a.bytes / 1048576),'99,999,990.900') "Total MB",
5 TO_CHAR(((a.bytes - DECODE(f.bytes, NULL, 0, f.bytes)) / 1048576),'99,999,990.900') "Used MB",
6 TO_CHAR((((a.bytes - DECODE(f.bytes, NULL, 0, f.bytes)) / 1048576)*100) / (a.bytes / 1048576),'999,999.9') "Used (%)"
7 FROM
8 (sys.dba_tablespaces d JOIN sys.sm$ts_avail a USING (tablespace_name))
9 LEFT OUTER JOIN sys.sm$ts_free f USING (tablespace_name)
10 ORDER BY 5;
Tablespace Status Total MB Used MB Used (%)
-------------------- ---------- --------------- --------------- ----------
MIS_BASE ONLINE 1,000.000 2.000 .2
UNDOTBS1 ONLINE 57,069.000 1,658.688 2.9
SZD_BASE_V2 ONLINE 647,200.000 61,399.000 9.5
SYSTEM ONLINE 6,144.000 693.625 11.3
SZD_BAR_V2 ONLINE 3,072.000 562.000 18.3
SZD_PERFORMANCE_V2 ONLINE 2,048.000 842.000 41.1
USERS ONLINE 2,048.000 1,406.813 68.7
SYSAUX ONLINE 161,633.813 150,122.125 92.9
8 rows selected.
So,used total size of all of tablespaces is as follows,
SYS@orcl29> select (2.000+1658.688+61399.000+693.625+562.000+842.000+1406.813+150122.125)/1024 SUM_USED_GB from dual;
SUM_USED_GB
-----------
211.607667
and total size is as follows,
SYS@orcl29> select (1000.000+57069.000+647200.000+6144.000+3072.000+2048.000+2048.000+161633.813)/1024 SUM_TOTAL_GB from dual;
SUM_TOTAL_GB
------------
859.584778
Secondly,there has RMAN full backup info below,
![(OJ{5}G(~VIH69K]$%G`C1P.png](https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/jive_attachments/5/6/9/56916454egami.png)
[oracle@orcl29 2017-11-17]$ ls -lrth
total 654G
-rw-r----- 1 oracle oinstall 15G Nov 17 22:31 archivelog_ORCL29_12877_1_idsjqurd.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:34 archivelog_ORCL29_12876_1_icsjqurd.bak
-rw-r----- 1 oracle oinstall 15G Nov 17 22:36 archivelog_ORCL29_12874_1_iasjqurd.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:37 archivelog_ORCL29_12875_1_ibsjqurd.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:44 DATA_level0_ORCL29_12881_1_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:45 DATA_level0_ORCL29_12879_1_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:46 DATA_level0_ORCL29_12878_1_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:46 DATA_level0_ORCL29_12880_1_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:53 DATA_level0_ORCL29_12881_2_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:53 DATA_level0_ORCL29_12879_2_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:54 DATA_level0_ORCL29_12878_2_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 22:54 DATA_level0_ORCL29_12880_2_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:02 DATA_level0_ORCL29_12881_3_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:02 DATA_level0_ORCL29_12878_3_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:02 DATA_level0_ORCL29_12879_3_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:03 DATA_level0_ORCL29_12880_3_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:09 DATA_level0_ORCL29_12881_4_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:10 DATA_level0_ORCL29_12879_4_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:10 DATA_level0_ORCL29_12878_4_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:11 DATA_level0_ORCL29_12880_4_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:16 DATA_level0_ORCL29_12881_5_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:17 DATA_level0_ORCL29_12878_5_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:17 DATA_level0_ORCL29_12879_5_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:18 DATA_level0_ORCL29_12880_5_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:22 DATA_level0_ORCL29_12881_6_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:23 DATA_level0_ORCL29_12878_6_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:23 DATA_level0_ORCL29_12879_6_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:24 DATA_level0_ORCL29_12880_6_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:28 DATA_level0_ORCL29_12881_7_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:29 DATA_level0_ORCL29_12878_7_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:29 DATA_level0_ORCL29_12879_7_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:30 DATA_level0_ORCL29_12880_7_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:34 DATA_level0_ORCL29_12881_8_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:34 DATA_level0_ORCL29_12878_8_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:35 DATA_level0_ORCL29_12879_8_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 6.8G Nov 17 23:36 DATA_level0_ORCL29_12881_9_ihsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:36 DATA_level0_ORCL29_12880_8_igsjqv92.bak
-rw-r----- 1 oracle oinstall 9.3G Nov 17 23:37 DATA_level0_ORCL29_12880_9_igsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:40 DATA_level0_ORCL29_12878_9_iesjqv91.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:41 DATA_level0_ORCL29_12879_9_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 11G Nov 17 23:43 DATA_level0_ORCL29_12879_10_ifsjqv92.bak
-rw-r----- 1 oracle oinstall 16G Nov 17 23:43 DATA_level0_ORCL29_12878_10_iesjqv91.bak
-rw-r----- 1 oracle oinstall 6.7G Nov 17 23:44 DATA_level0_ORCL29_12878_11_iesjqv91.bak
-rw-r----- 1 oracle oinstall 13M Nov 17 23:44 archivelog_ORCL29_12883_1_ijsjr36q.bak
Please help me for analyze it,thanks
Best Regards,
Quanwen Zhao