DDVE:Windows Server 2008 R2下使用DDBoost RMAN 离线备份Oracle数据库

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        
点赞

发表回复

电子邮件地址不会被公开。必填项已用 * 标注