首页 » ORACLE » limit backup filesize with rman maxpiecesize (限制备份文件大小相关参数)

limit backup filesize with rman maxpiecesize (限制备份文件大小相关参数)

今天检查服务器上的rman 备份发现新上线的系统备份单文件已经到了11G大小,记的在shell脚本中限制了看来没起作用,才发现maxpiecesize的位置不同效果也不同,而且MAXSETSIZE还有这样的限制

看我的实验,转载请声明出处http://www.anbob.com/?p=1093

实验1


[oracle@orazhang ~]$ vi rmanfullbak.sh

#!/bin/bash
### every day backup full database#####

source /home/oracle/.bash_profile
cd $ORACLE_HOME/bin

./rman target / msglog=/home/oracle/rman_bk_L0_`date '+%Y%m%d%H%M%S'`.log <<EOF
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

allocate channel c1 type disk maxpiecesize=200M;
backup  format '/u01/app/oracle/backfile/whole_%d_%T_%s_%p.bak' database;
release channel c1;
}
CROSSCHECK backup;
delete noprompt expired backupset of database ;
delete noprompt obsolete ;
exit;
EOF

篇幅原因不再贴备份过程

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
74      Full    245.46M    DISK        00:02:36     2011-09-08 17:15:34
List of Datafiles in backup set 74
File LV Type Ckp SCN    Ckp Time            Name
---- -- ---- ---------- ------------------- ----
1       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
2       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/test.dbf
3       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf
4       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf
5       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf
6       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/tt.dbf
7       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
8       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf
9       Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/tt1.dbf
10      Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_indextbs_729vx06v_.dbf
12      Full 1340530630 2011-09-08 17:12:58 /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf

Backup Set Copy #1 of backup set 74
Device Type Elapsed Time Completion Time     Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK        00:02:36     2011-09-08 17:15:34 YES        TAG20110908T171258

List of Backup Pieces for backup set 74 Copy #1
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
74      1   AVAILABLE   /u01/app/oracle/backfile/whole_ORCL_20110908_84_1.bak
75      2   AVAILABLE   /u01/app/oracle/backfile/whole_ORCL_20110908_84_2.bak

[oracle@orazhang backfile]$ ll -h
total 253M
-rw-r----- 1 oracle oinstall 7.2M Sep  8 17:15 c-1246063822-20110908-00
-rw-r----- 1 oracle oinstall 199M Sep  8 17:15 whole_ORCL_20110908_84_1.bak
-rw-r----- 1 oracle oinstall  48M Sep  8 17:15 whole_ORCL_20110908_84_2.bak

限制成功,分成了2个备份集

实验2


修改shell

run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
configure channel device type disk maxpiecesize=200M;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

allocate channel c1 type disk;
backup  format '/u01/app/oracle/backfile/whole_%d_%T_%s_%p.bak' database;
release channel c1;
}

--备份成功

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
76      Full    244.66M    DISK        00:02:29     2011-09-08 17:31:31
BP Key: 77   Status: AVAILABLE  Compressed: YES  Tag: TAG20110908T172902
Piece Name: /u01/app/oracle/backfile/whole_ORCL_20110908_86_1.bak
List of Datafiles in backup set 76
File LV Type Ckp SCN    Ckp Time            Name
---- -- ---- ---------- ------------------- ----
1       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
2       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/test.dbf
3       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf
4       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf
5       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf
6       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/tt.dbf
7       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
8       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf
9       Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/tt1.dbf
10      Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_indextbs_729vx06v_.dbf
12      Full 1340531077 2011-09-08 17:29:02 /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf

[oracle@orazhang backfile]$ ll -h
total 253M
-rw-r----- 1 oracle oinstall 7.2M Sep  8 17:31 c-1246063822-20110908-01
-rw-r----- 1 oracle oinstall 245M Sep  8 17:31 whole_ORCL_20110908_86_1.bak

并非全局限制,限制没起作用

实验3


RMAN> configure channel device type disk maxpiecesize=200M;

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> backup  format '/u01/app/oracle/backfile/whole_%d_%T_%s_%p.bak' database;

Starting backup at 2011-09-08 17:36:01
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/ORCL/datafile/tt.dbf
input datafile fno=00012 name=/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf
input datafile fno=00010 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_indextbs_729vx06v_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/test.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf
channel ORA_DISK_1: starting piece 1 at 2011-09-08 17:36:02
channel ORA_DISK_1: finished piece 1 at 2011-09-08 17:38:17
piece handle=/u01/app/oracle/backfile/whole_ORCL_20110908_88_1.bak tag=TAG20110908T173601 comment=NONE
channel ORA_DISK_1: starting piece 2 at 2011-09-08 17:38:17
channel ORA_DISK_1: finished piece 2 at 2011-09-08 17:38:42
piece handle=/u01/app/oracle/backfile/whole_ORCL_20110908_88_2.bak tag=TAG20110908T173601 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:40
Finished backup at 2011-09-08 17:38:42

Starting Control File and SPFILE Autobackup at 2011-09-08 17:38:42
piece handle=/u01/app/oracle/backfile/c-1246063822-20110908-02 comment=NONE
Finished Control File and SPFILE Autobackup at 2011-09-08 17:38:43

[oracle@orazhang backfile]$ ll -h
total 253M
-rw-r----- 1 oracle oinstall 7.2M Sep  8 17:38 c-1246063822-20110908-02
-rw-r----- 1 oracle oinstall 199M Sep  8 17:38 whole_ORCL_20110908_88_1.bak
-rw-r----- 1 oracle oinstall  48M Sep  8 17:38 whole_ORCL_20110908_88_2.bak

在交互式中rman 中同实验一,生成了两个文件,限制成功

实验4

RMAN> backup MAXSETSIZE 200m database;

Starting backup at 2011-09-08 17:52:19
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/08/2011 17:52:19
RMAN-06183: datafile or datafile copy larger than MAXSETSIZE: file# 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf

RMAN> report schema;

Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    540      SYSTEM               ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
2    100      TEST                 ***     /u01/app/oracle/oradata/ORCL/datafile/test.dbf
3    460      SYSAUX               ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf
4    60       USERS                ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf
5    100      EXAMPLE              ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf
6    406      TT                   ***     /u01/app/oracle/oradata/ORCL/datafile/tt.dbf
7    100      TBSLOGMNR            ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
8    20       SMAILTBS             ***     /u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf
9    10       TT                   ***     /u01/app/oracle/oradata/ORCL/datafile/tt1.dbf
10   300      INDEXTBS             ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_indextbs_729vx06v_.dbf
12   398      UNDOTBS2             ***     /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf

RMAN> backup MAXSETSIZE 550m database;

Starting backup at 2011-09-08 17:53:27
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
channel ORA_DISK_1: starting piece 1 at 2011-09-08 17:53:27
channel ORA_DISK_1: finished piece 1 at 2011-09-08 17:54:02
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/2qmm230n_1_1 tag=TAG20110908T175327 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00010 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_indextbs_729vx06v_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/test.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
channel ORA_DISK_1: starting piece 1 at 2011-09-08 17:54:02
channel ORA_DISK_1: finished piece 1 at 2011-09-08 17:54:17
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/2rmm231q_1_1 tag=TAG20110908T175327 comment=NONE
--此处省略N个字(恩格斯?no)

[oracle@orazhang backfile]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@orazhang dbs]$ ll -h
total 643M
-rw-r----- 1 oracle oinstall  91M Sep  8 17:53 2qmm230n_1_1
-rw-r----- 1 oracle oinstall 3.9M Sep  8 17:54 2rmm231q_1_1
-rw-r----- 1 oracle oinstall  85M Sep  8 17:54 2smm2329_1_1
-rw-r----- 1 oracle oinstall  42M Sep  8 17:55 2tmm233c_1_1
-rw-r----- 1 oracle oinstall  17M Sep  8 17:55 2umm2345_1_1

打赏

目前这篇文章有3条评论(Rss)评论关闭。

  1. Vern Gallipo | #1
    2011-12-21 at 13:13

    It’s excellent page, I was looking for something like this

  2. ice+cream+machine | #2
    2011-09-09 at 15:23

    以后经常来看版主老师的博客

    我喜欢你。

  3. solar-panel | #3
    2011-09-09 at 15:00

    呵呵,内容写的很到位,感觉很好,收藏一下,谢谢版主。我是经常来拜访你的访问者之一哦,今天忍不住留言了。