Oracle 10g How to optimize backup set size

In 10g, the Rman backup is optimized to no longer back up the data blocks in which the table frees space.

The backed up document is 9i, so it has always been considered that the Rman backup only backs up the blocks where the data was written, and that Rman does not matter if the current block is released, so the Rman backup set tends to grow larger as the space in the data file is constantly occupied.

Sql> SELECT * from V$version;

BANNER

----------------------------------------------------------------

Oracle9ienterpriseedition release9.2.0.4.0-production

Pl/sql Release 9.2.0.4.0-production

CORE 9.2.0.3.0 Production

TNS for Linux:version 9.2.0.4.0-production

Nlsrtl Version 9.2.0.4.0-production

sql> CREATE tablespace Test_rman

2 datafile '/data/oradata/testdata/test_rman01.dbf '

3 size200m;

The table space has been created.

sql> CREATE TABLE T_rman

2 tablespace Test_rman

3 as SELECT *

4 from Dba_objects;

Table has been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

31520 lines have been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

63040 lines have been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

126080 lines have been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

252160 lines have been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

504320 lines have been created.

Sql> INSERT into T_rman

2 SELECT *

3 from T_rman;

INSERT into T_rman

*

Error is on line 1th:

ORA-01653: Table Test.t_rman cannot be extended through 1024 (in table space Test_rman)

Sql> COMMIT;

Submit completed.

To back up the current table space through Rman:

[Oracle@localhost ~]$ Rman Target/

Recovery Manager: Version 9.2.0.4.0-production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

Connect to target database: TESTDATA (dbid=2270762593)

Rman> RUN

2> {

3> ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '/data/backup/testdata/%u ';

4> BACKUP tablespace Test_rman;

5>}

Allocated channel: C1

Channel c1:sid=19 Devtype=disk

Start Backup in 2 July-May-10

Channel C1: Starting full data file backup set

Channel C1: Specifying Data files in Backup set

Enter data file fno=00029 name=/data/oradata/testdata/test_rman01.dbf

Channel C1: Starting segment 1 in 2 July-May-10

Channel C1: Completed segment 1 in 2 July-May-10

Duan Handle=/data/backup/testdata/5clenfku_1_1 Comment=none

Channel C1: Backup set completed, after time: 00:00:07

Completed backup in 2 July-May-10

Start Control File and SPFILE autobackup in 2 July-May-10

Duan Handle=/data/backup/testdata/20100526_c-2270762593-20100527-01 Comment=none

Complete control File and SPFILE autobackup in 2 July-May-10

Channel Freed: C1

Rman> LIST BACKUP of tablespace Test_rman;

Backup set list

===================

More Wonderful content: http://www.bianceng.cn/database/Oracle/