rman只备份使用过的数据块~也就是数据库里使用了多少的空间备份的空间就有多大~
但是请看:
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 28 12:08:44 2006
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select sum(bytes)/1024/1024/1024 GB from dba_data_files;
GB
----------
63.1022949
SQL> select sum(bytes)/1024/1024/1024 GB from dba_free_space;
GB
----------
57.7880249
但是备份出来的文件:
-rw-r----- 1 oracle dba6291456000 Nov 28 11:17 UDA_full_20061128_947_1.bck
-rw-r----- 1 oracle dba6291456000 Nov 28 11:18 UDA_full_20061128_946_1.bck
-rw-r----- 1 oracle dba6291456000 Nov 28 11:23 UDA_full_20061128_946_2.bck
-rw-r----- 1 oracle dba6291456000 Nov 28 11:23 UDA_full_20061128_947_2.bck
-rw-r----- 1 oracle dba6291456000 Nov 28 11:28 UDA_full_20061128_946_3.bck
-rw-r----- 1 oracle dba6276358144 Nov 28 11:29 UDA_full_20061128_947_3.bck
-rw-r----- 1 oracle dba6291456000 Nov 28 11:32 UDA_full_20061128_946_4.bck
-rw-r----- 1 oracle dba633634816 Nov 28 11:32 UDA_full_20061128_946_5.bck
备份脚本:
run {
allocate channel c1 device type disk maxpiecesize=6000M;
allocate channel c2 device type disk maxpiecesize=6000M;
backup database format \'/data/dbbak/rmanbak/%d_full_%T_%s_%p.bck\' FILESPERSET = 100;
sql \'alter system switch logfile\';
release channel c1;
release channel c2;
}
何故???大家看看
最初由 xzh2000 发布
[B]http://xzh2000.itpub.net/post/96/64549
看看是否满足未使用块压缩的条件? [/B]
■ The COMPATIBLE initialization parameter is set to 10.2
compatible
string
10.2.0.1.0
■ There are currently no guaranteed restore points defined for the database
???不懂
■ The datafile is locally managed
SQL> select tablespace_name,extent_management from dba_tablespaces;
TABLESPACE_NAME
EXTENT_MAN
------------------------------ ----------
SYSTEM
LOCAL
UNDOTBS1
LOCAL
SYSAUX
LOCAL
TEMP
LOCAL
USERS
LOCAL
BILLDATA
LOCAL
CASHDATA
LOCAL
PAYMENT
LOCAL
BILLIDX
LOCAL
CASHIDX
LOCAL
TICKETDATA
LOCAL
TABLESPACE_NAME
EXTENT_MAN
------------------------------ ----------
AAA
LOCAL
PERFSTAT
LOCAL
■ The datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backup
yes
■ The backup set is being created on disk.
yes