DDVE 备份Oracle数据库消重比在3倍以上:
1、安装 ddrman47_ntx64(Oracle RMAN agent.exe)
安装路径:D:\oracle\product\ddboost\
2、配置Windows环境变量:
setx -m RMAN_AGENT_HOME D:\oracle\product\ddboost\
3、配置DDVE(SSH到DDVE 5.0上操作)
user add shouma role none password <输入密码>
ddboost user assign shouma
ddboost storage-unit create unit_shouma user shouma
user password aging set shouma max-days-between-change 99999
4、注册DDVE
C:\> ddutil -C
Data Domain server name:172.16.10.110
DD Boost username:shouma
Password: <输入密码>
Re-enter password: <输入密码>
Successfully set the DD Boost credentials in the lockbox.
5、使用RMAN命令注册DD
rman target /
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576,
SBT_LIBRARY=D:\oracle\product\ddboost\bin\libddobk.dll,
ENV=(STORAGE_UNIT=unit_shouma, BACKUP_HOST=172.16.10.110,
RMAN_AGENT_HOME=D:\oracle\product\ddboost)';
send 'set username shouma password <输入密码> servername 172.16.10.110';
RELEASE CHANNEL C1;
}
6、配置Oracle RMAN的备份通道
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'
PARMS 'BLKSIZE=1048576,
SBT_LIBRARY=D:\oracle\product\ddboost\bin\libDDobk.dll,
ENV=(STORAGE_UNIT=unit_shouma,
BACKUP_HOST=172.16.10.110,
RMAN_AGENT_HOME=D:\oracle\product\ddboost)';
7、将 SBT_TAPE 配置为默认设备:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
8、配置RMAN参数:
CONFIGURE DEVICE TYPE SBT_TAPE Backup TYPE to BACKUPSET PARALLELISM 8;
Configure controlfile autobackup on;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './shouma/%d_%F.ctl';
9、开始备份
run {
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './shouma/%d_%F.ctl';
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup database
format './shouma/backup_full/level_full_%d_%T_%s';
backup archivelog all format './shouma/backup_full/arch_%d_%U' ;
}
## 以下为日志:
RMAN> run {
2> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
3> CONFIGURE CONTROLFILE AUTOBACKUP ON;
4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './shouma/%d_%F.ctl';
5> crosscheck archivelog all;
6> delete noprompt expired archivelog all;
7> backup database
8> format './shouma/backup_full/level_full_%d_%T_%s';
9> backup archivelog all format './shouma/backup_full/arch_%d_%U' ;
10> }
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './shouma/%d_%F.ctl';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './shouma/%d_%F.ctl';
new RMAN configuration parameters are successfully stored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1624 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1622 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1625 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=1630 devtype=DISK
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08409_0973160971.001 recid=18721 stamp=1066785365
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00001_1067295160.001 recid=18728 stamp=1067295186
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00002_1067295160.001 recid=18729 stamp=1067296942
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00003_1067295160.001 recid=18730 stamp=1067296943
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00004_1067295160.001 recid=18731 stamp=1067324235
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00005_1067295160.001 recid=18732 stamp=1067378411
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00006_1067295160.001 recid=18733 stamp=1067381059
Crosschecked 7 objects
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08389_0973160971.001 recid=18701 stamp=1066612505
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08390_0973160971.001 recid=18702 stamp=1066636672
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08391_0973160971.001 recid=18703 stamp=1066643702
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08392_0973160971.001 recid=18704 stamp=1066649609
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08393_0973160971.001 recid=18705 stamp=1066656114
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08394_0973160971.001 recid=18706 stamp=1066663562
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08395_0973160971.001 recid=18707 stamp=1066669745
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08396_0973160971.001 recid=18708 stamp=1066677638
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08397_0973160971.001 recid=18709 stamp=1066687227
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08398_0973160971.001 recid=18710 stamp=1066688326
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08399_0973160971.001 recid=18711 stamp=1066698968
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08400_0973160971.001 recid=18712 stamp=1066726015
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08401_0973160971.001 recid=18713 stamp=1066732348
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08402_0973160971.001 recid=18714 stamp=1066739281
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08403_0973160971.001 recid=18715 stamp=1066746036
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08404_0973160971.001 recid=18716 stamp=1066750885
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08405_0973160971.001 recid=18717 stamp=1066756737
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08406_0973160971.001 recid=18718 stamp=1066768202
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08407_0973160971.001 recid=18719 stamp=1066773653
validation failed for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08408_0973160971.001 recid=18720 stamp=1066779343
Crosschecked 20 objects
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1624 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1622 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1625 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=1630 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
18701 1 8389 X 07-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08389_0973160971.001
18702 1 8390 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08390_0973160971.001
18703 1 8391 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08391_0973160971.001
18704 1 8392 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08392_0973160971.001
18705 1 8393 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08393_0973160971.001
18706 1 8394 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08394_0973160971.001
18707 1 8395 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08395_0973160971.001
18708 1 8396 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08396_0973160971.001
18709 1 8397 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08397_0973160971.001
18710 1 8398 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08398_0973160971.001
18711 1 8399 X 08-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08399_0973160971.001
18712 1 8400 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08400_0973160971.001
18713 1 8401 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08401_0973160971.001
18714 1 8402 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08402_0973160971.001
18715 1 8403 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08403_0973160971.001
18716 1 8404 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08404_0973160971.001
18717 1 8405 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08405_0973160971.001
18718 1 8406 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08406_0973160971.001
18719 1 8407 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08407_0973160971.001
18720 1 8408 X 09-MAR-21 D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08408_0973160971.001
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08389_0973160971.001 recid=18701 stamp=1066612505
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08390_0973160971.001 recid=18702 stamp=1066636672
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08391_0973160971.001 recid=18703 stamp=1066643702
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08392_0973160971.001 recid=18704 stamp=1066649609
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08393_0973160971.001 recid=18705 stamp=1066656114
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08394_0973160971.001 recid=18706 stamp=1066663562
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08395_0973160971.001 recid=18707 stamp=1066669745
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08396_0973160971.001 recid=18708 stamp=1066677638
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08397_0973160971.001 recid=18709 stamp=1066687227
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08398_0973160971.001 recid=18710 stamp=1066688326
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08399_0973160971.001 recid=18711 stamp=1066698968
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08400_0973160971.001 recid=18712 stamp=1066726015
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08401_0973160971.001 recid=18713 stamp=1066732348
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08402_0973160971.001 recid=18714 stamp=1066739281
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08403_0973160971.001 recid=18715 stamp=1066746036
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08404_0973160971.001 recid=18716 stamp=1066750885
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08405_0973160971.001 recid=18717 stamp=1066756737
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08406_0973160971.001 recid=18718 stamp=1066768202
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08407_0973160971.001 recid=18719 stamp=1066773653
deleted archive log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC08408_0973160971.001 recid=18720 stamp=1066779343
Deleted 20 EXPIRED objects
Starting backup at 16-MAR-21
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=1624 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=1622 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=1625 devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=1630 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: sid=1627 devtype=SBT_TAPE
channel ORA_SBT_TAPE_5: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: sid=1629 devtype=SBT_TAPE
channel ORA_SBT_TAPE_6: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: sid=1628 devtype=SBT_TAPE
channel ORA_SBT_TAPE_7: Data Domain Boost API
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: sid=1619 devtype=SBT_TAPE
channel ORA_SBT_TAPE_8: Data Domain Boost API
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00007 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\APMEDSURGERY.DBF
channel ORA_SBT_TAPE_1: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_2: starting full datafile backupset
channel ORA_SBT_TAPE_2: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\APMEDICU.DBF
channel ORA_SBT_TAPE_2: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_3: starting full datafile backupset
channel ORA_SBT_TAPE_3: specifying datafile(s) in backupset
input datafile fno=00008 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\APMEDSURGERY2.DBF
channel ORA_SBT_TAPE_3: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_4: starting full datafile backupset
channel ORA_SBT_TAPE_4: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\APMEDCOMM.DBF
channel ORA_SBT_TAPE_4: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_5: starting full datafile backupset
channel ORA_SBT_TAPE_5: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\UNDOTBS01.DBF
channel ORA_SBT_TAPE_5: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_6: starting full datafile backupset
channel ORA_SBT_TAPE_6: specifying datafile(s) in backupset
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\SYSAUX01.DBF
channel ORA_SBT_TAPE_6: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_7: starting full datafile backupset
channel ORA_SBT_TAPE_7: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\SYSTEM01.DBF
channel ORA_SBT_TAPE_7: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_8: starting full datafile backupset
channel ORA_SBT_TAPE_8: specifying datafile(s) in backupset
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCARE\USERS01.DBF
channel ORA_SBT_TAPE_8: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_5: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6095 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:00:07
channel ORA_SBT_TAPE_6: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6096 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:00:07
channel ORA_SBT_TAPE_7: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6097 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:07
channel ORA_SBT_TAPE_8: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6098 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:00:07
channel ORA_SBT_TAPE_4: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6094 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:22
channel ORA_SBT_TAPE_3: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6093 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_2: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6092 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:42
channel ORA_SBT_TAPE_1: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/level_full_DOCARE_20210316_6091 tag=TAG20210316T234903 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:07
Finished backup at 16-MAR-21
Starting backup at 16-MAR-21
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=18729 stamp=1067296942
channel ORA_SBT_TAPE_1: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_2: starting archive log backupset
channel ORA_SBT_TAPE_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=3 recid=18730 stamp=1067296943
channel ORA_SBT_TAPE_2: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_3: starting archive log backupset
channel ORA_SBT_TAPE_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=18731 stamp=1067324235
channel ORA_SBT_TAPE_3: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_4: starting archive log backupset
channel ORA_SBT_TAPE_4: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=18732 stamp=1067378411
channel ORA_SBT_TAPE_4: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_5: starting archive log backupset
channel ORA_SBT_TAPE_5: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=18728 stamp=1067295186
channel ORA_SBT_TAPE_5: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_6: starting archive log backupset
channel ORA_SBT_TAPE_6: specifying archive log(s) in backup set
input archive log thread=1 sequence=8409 recid=18721 stamp=1066785365
channel ORA_SBT_TAPE_6: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_7: starting archive log backupset
channel ORA_SBT_TAPE_7: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=18733 stamp=1067381059
channel ORA_SBT_TAPE_7: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_8: starting archive log backupset
channel ORA_SBT_TAPE_8: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=18734 stamp=1067385072
channel ORA_SBT_TAPE_8: starting piece 1 at 16-MAR-21
channel ORA_SBT_TAPE_1: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_ujvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_2: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_ukvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_3: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_ulvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_4: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_umvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_5: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_unvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_6: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_uovpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_7: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_upvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:03
channel ORA_SBT_TAPE_8: finished piece 1 at 16-MAR-21
piece handle=./shouma/backup_full/arch_DOCARE_uqvpu07h_1_1 tag=TAG20210316T235112 comment=API Version 2.0,MMS Version 4.7.0.0
channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:00:03
Finished backup at 16-MAR-21
Starting Control File and SPFILE Autobackup at 16-MAR-21
piece handle=./shouma/DOCARE_c-1269075562-20210316-03.ctl comment=API Version 2.0,MMS Version 4.7.0.0
Finished Control File and SPFILE Autobackup at 16-MAR-21
RMAN>
9.1、备份77GB数据库,耗时不到3分钟。
9.2、备份速度每秒900MB
10、查看DDVE DDboost 客户端状态:
sysadmin@ddve# ddboost clients show active all
Client Client Server Operation Mode Storage-unit
Hostname Interface Interface
--------------- ----------- ------------- --------- ---- ------------
windows-75s8ov1 172.16.0.67 172.16.10.110 write dsp unit_shouma
windows-75s8ov1 172.16.0.67 172.16.10.110 write dsp unit_shouma
windows-75s8ov1 172.16.0.67 172.16.10.110 write dsp unit_shouma
--------------- ----------- ------------- --------- ---- ------------
sysadmin@ddve# ddboost show connections detailed
Active Clients: 1
Clients:
Client Idle CPUs Memory(MiB) Plugin Version OS Version Application Version Encrypted DSP Transport
--------------- ---- ---- ----------- -------------- -------------------------------------------------------------------- -------------------------------- --------- --- ---------
WINDOWS-75S8OV1 NO 24 16,321 3.5.0.0-607663 Microsoft Windows Server 2008 R2 Service Pack 1 (build 7601), 64-bit Oracle RMAN agent 4.7.0.0(70) NO YES IPv4
USER-415UEU2RGM YES 8 65,535 3.5.0.0-607663 Microsoft Windows Server 2008 R2 Service Pack 1 (build 7601), 64-bit Oracle RMAN agent 4.7.0.0(70) NO YES IPv4
USER-SK4MNHBIQC YES 8 32,767 3.5.0.0-607663 Microsoft Windows Server 2008 R2 Service Pack 1 (build 7601), 64-bit Oracle RMAN agent 4.7.0.0(70) NO YES IPv4
--------------- ---- ---- ----------- -------------- -------------------------------------------------------------------- -------------------------------- --------- --- ---------
Client Connections:
Max Client Connections: 30
-------------- ifgroup ------------- --------------- Client Connections ----------- - DD Connections - -----
----- Control ----- ------ Data ------
Group-name Status Interface Write Read Src-repl Dst-repl Synthetic Repl-out Repl-in Total
---------- ------- ------------------ ----- ---- -------- -------- --------- -------- ------- -----
none 172.16.10.110 2 0 0 0 0 0 0 2
none 172.16.10.111 0 0 0 0 0 0 0 0
---------- ------- ------------- ----- ---- -------- -------- --------- -------- ------- -----
Total Connections: 2 0 0 0 0 0 0 2
---------- ------- ------------------ ----- ---- -------- -------- --------- -------- ------- -----
10.1、DDBoost加速情况:
sysadmin@ddve# ddboost show stats interval 1
03/16 23:50:30
Backup Post-comp Network Restore Network Backup Restore
KB/s Written KB/s In KB/s KB/s Out KB/s Conn Conn
--------------- --------------- --------------- --------------- --------------- ------- -------
880,221 108 108 0 0 3 0
857,243 63 63 0 0 3 0
871,957 126 126 0 0 3 0
886,849 13 13 0 0 3 0
868,004 259 259 0 0 3 0
823,543 253 253 0 0 3 0
878,817 39 39 0 0 3
文章评论