RAMN备份集大小估算以及11g压缩备份集的测试

实例：

1：排除指定的表空间不备份

RMAN> configure exclude for tablespace newadunion;  --不备份newadunion表空间，加clear清除配置

tablespace NEWADUNION will be excluded from future whole database backups
new RMAN configuration parameters are successfully stored

run{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup database format '/data/backup/rmanback/db_%d_%T_%U';
crosscheck backup;
release channel ch1;
release channel ch2;
}

allocated channel: ch1
channel ch1: sid=98 devtype=DISK

allocated channel: ch2
channel ch2: sid=119 devtype=DISK

Starting backup at 12-6月 -12
file 5 is excluded from whole database backup
file 13 is excluded from whole database backup
file 14 is excluded from whole database backup
file 15 is excluded from whole database backup
file 16 is excluded from whole database backup
file 17 is excluded from whole database backup
file 18 is excluded from whole database backup
file 19 is excluded from whole database backup
file 20 is excluded from whole database backup
file 21 is excluded from whole database backup
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00023 name=/data/oradata/eagaodb/newadunion_log01.dbf
input datafile fno=00022 name=/data/oradata/eagaodb/smsway01.dbf
input datafile fno=00002 name=/data/oradata/eagaodb/eaindex_data02.dbf
input datafile fno=00007 name=/data/oradata/eagaodb/system02.dbf
input datafile fno=00008 name=/data/oradata/eagaodb/wz_data01.dbf
input datafile fno=00010 name=/data/oradata/eagaodb/eaindex_data.dbf
input datafile fno=00003 name=/data/oradata/eagaodb/sysaux01.dbf
channel ch1: starting piece 1 at 12-6月 -12
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00006 name=/log/oracle/undotbs2.dbf
input datafile fno=00001 name=/data/oradata/eagaodb/system01.dbf
input datafile fno=00009 name=/data/oradata/eagaodb/flink_data.dbf
input datafile fno=00004 name=/data/oradata/eagaodb/users01.dbf
input datafile fno=00011 name=/data/oradata/eagaodb/eaindex_idx01.dbf
input datafile fno=00012 name=/data/oradata/eagaodb/chris01.dbf
channel ch2: starting piece 1 at 12-6月 -12
channel ch2: finished piece 1 at 12-6月 -12
piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0cndc5v3_1_1 tag=TAG20120612T165915 comment=NONE
channel ch2: backup set complete, elapsed time: 00:06:36
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
including current control file in backupset
channel ch2: starting piece 1 at 12-6月 -12
channel ch2: finished piece 1 at 12-6月 -12
piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0dndc6bf_1_1 tag=TAG20120612T165915 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:03
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ch2: starting piece 1 at 12-6月 -12
channel ch2: finished piece 1 at 12-6月 -12
piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0endc6bj_1_1 tag=TAG20120612T165915 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:02
channel ch1: finished piece 1 at 12-6月 -12
piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0bndc5v3_1_1 tag=TAG20120612T165915 comment=NONE
channel ch1: backup set complete, elapsed time: 00:11:27
Finished backup at 12-6月 -12

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0cndc5v3_1_1 recid=5 stamp=785782755
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0dndc6bf_1_1 recid=6 stamp=785783151
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0endc6bj_1_1 recid=7 stamp=785783156
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/backup/rmanback/db_EAGAODB_20120612_0bndc5v3_1_1 recid=8 stamp=785782755
Crosschecked 4 objects

released channel: ch1

released channel: ch2

2：监控执行的进度：

SQL> select sid,SERIAL# ,CONTEXT,SOFAR,TOTALWORK,round(SOFAR/TOTALWORK*100,2) "_%"
from v$session_longops where OPNAME like 'RMAN%' and SOFAR<>TOTALWORK and  TOTALWORK<>0;

no rows selected

SQL> /

SID    SERIAL#  CONTEXT      SOFAR   TOTALWORK        _%
----  ----------  ----------     ----------  ---------------     -----