- 论坛徽章:
- 0
|
环境 cent6.7+oracle11024+asm+rac nbu8.1 数据量20g左右。,走的是10g光纤网络
发现备份需要40分钟,
备份脚本:
CMD_INPUT="<< EOF
SHOW ALL;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
$RMAN_SEND
BACKUP
$BACKUP_TYPE
SKIP INACCESSIBLE
TAG $BACKUP_TAG
FILESPERSET 5
# recommended format, must end with %t
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' $RMAN_SBT_LIBRARY_PARMS;
$RMAN_SEND
BACKUP
filesperset 20
# recommended format, must end with %t
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
备份日志:
channel ch00: starting piece 1 at 27-FEB-18
channel ch03: finished piece 1 at 27-FEB-18
piece handle=bk_3712_1_969209650 tag=HOT_DB_BK_INC_LVL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch03: backup set complete, elapsed time: 00:04:16
channel ch02: finished piece 1 at 27-FEB-18
piece handle=bk_3713_1_969209835 tag=HOT_DB_BK_INC_LVL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch02: backup set complete, elapsed time: 00:01:30
channel ch00: finished piece 1 at 27-FEB-18
piece handle=bk_3714_1_969209871 tag=HOT_DB_BK_INC_LVL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:01:05
channel ch01: finished piece 1 at 27-FEB-18
piece handle=bk_3710_1_969209650 tag=HOT_DB_BK_INC_LVL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:32:06
Finished backup at 27-FEB-18
released channel: ch00
released channel: ch01
released channel: ch02
released channel: ch03
-rw-rw---- oracle asmadmin 19398656 Feb 27 17:02 /cntrl_3718_1_969210147
-rw-rw---- oracle asmadmin 10485760 Feb 27 17:01 /al_3717_1_969210113
-rw-rw---- oracle asmadmin 92536832 Feb 27 17:01 /al_3716_1_969210067
-rw-rw---- oracle asmadmin 275513344 Feb 27 17:01 /al_3715_1_969210067
-rw-rw---- oracle asmadmin 262144 Feb 27 16:57 /bk_3714_1_969209871
-rw-rw---- oracle asmadmin 19398656 Feb 27 16:57 /bk_3713_1_969209835
-rw-rw---- oracle asmadmin 960233472 Feb 27 16:54 /bk_3712_1_969209650
-rw-rw---- oracle asmadmin 1139456K Feb 27 16:54 /bk_3709_1_969209649
-rw-rw---- oracle asmadmin 4609536K Feb 27 16:54 /bk_3711_1_969209650
-rw-rw---- oracle asmadmin 19600896K Feb 27 16:54 /bk_3710_1_969209650
|
|