--
-- RMAN UNUSED BLOCK COMPRESSION DEMO on Linux EE 10.2.0.3
--
SQL*Plus > 
select * from v$version where banner like 'Oracle Database%' ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod

CREATE TABLESPACE tong_test DATAFILE '+DGROUP1' SIZE 10m ;

SELECT file#, name  FROM v$datafile where name like '%tong_test%' ;

     FILE# NAME
---------- --------------------------------------------------------------------------------
         8 +DGROUP1/tong/datafile/tong_test.258.648825141

select TABLESPACE_NAME, BLOCK_SIZE, EXTENT_MANAGEMENT, ALLOCATION_TYPE, SEGMENT_SPACE_MANAGEMENT 
from dba_tablespaces where tablespace_name = 'TONG_TEST' ;

TABLESPACE_NAME                BLOCK_SIZE EXTENT_MANAGEMENT ALLOCATION_TYPE SEGMENT_SPACE_MANAGEMENT
------------------------------ ---------- ----------------- --------------- ------------------------
TONG_TEST                            8192 LOCAL             SYSTEM          AUTO

select name, value from v$system_parameter where name like 'compat%' ;

NAME           VALUE
-------------- --------------
compatible     10.2.0.1.0

RMAN > 
rman catalog rman_user/rman target /

run { 
set command id to 'DF8_STEP1';
sql "ALTER SYSTEM CHECKPOINT GLOBAL";
BACKUP DATAFILE 8 ; }

CMD > 
asmcmd ls -ls +DGROUP1/tong/datafile/tong_test.258.648825141
Type      Redund  Striped  Time             Sys  Block_Size  Blocks     Bytes     Space  Name
DATAFILE  UNPROT  COARSE   MAR 08 13:00:00  Y          8192    1281  10493952  11534336  tong_test.258.648825141

SQL*Plus > 
SELECT 10493952/1024 KB FROM dual;

10248

CMD > 
ls -lt /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T132015_3x4xmh9z_.bkp
-rw-r-----  1 oracle oinstall 106496 Mar  8 13:20 /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T132015_3x4xmh9z_.bkp

SQL*Plus > 
SELECT 106496/1024 KB FROM dual;

104

SQL*Plus > 
CREATE TABLE tong_tab ( tong_col NUMBER) TABLESPACE tong_test;

BEGIN
 FOR i IN 1..100000 LOOP
  INSERT INTO tong_tab values(i);
 END LOOP;
END;
/
COMMIT;

RMAN > 
run { 
set command id to 'DF8_STEP2';
sql "ALTER SYSTEM CHECKPOINT GLOBAL";
BACKUP DATAFILE 8 ; }

CMD > 
ls -lt /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133235_3x4ybn2d_.bkp
-rw-r-----  1 oracle oinstall 1695744 Mar  8 13:32 /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133235_3x4ybn2d_.bkp

SQL*Plus > 
SELECT 1695744/1024 FROM dual;

1656

DELETE FROM tong_tab;
COMMIT;

RMAN > 
run { 
set command id to 'DF8_STEP3';
sql "ALTER SYSTEM CHECKPOINT GLOBAL";
BACKUP DATAFILE 8 ; }

CMD > 
ls -lt /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133502_3x4yh6h8_.bkp
-rw-r-----  1 oracle oinstall 1695744 Mar  8 13:35 /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133502_3x4yh6h8_.bkp

SQL*Plus > 
TRUNCATE TABLE tong_tab;

RMAN > 
run { 
set command id to 'DF8_STEP4';
sql "ALTER SYSTEM CHECKPOINT GLOBAL";
BACKUP DATAFILE 8 ; }

CMD > 
 ls -lt /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133625_3x4ykt27_.bkp
-rw-r-----  1 oracle oinstall 630784 Mar  8 13:36 /home/oracle/TONG/backupset/2008_03_08/o1_mf_nnndf_TAG20080308T133625_3x4ykt27_.bkp

SQL*Plus > 
SELECT 630784/1024 KB FROM dual;

616