配置sap系统备份到带库
操作系统版本:solaris 10 sparc
sap 版本:ERP 6.0
hostname :r3qas01
备份软件:EMC networker
备份服务器hostname:bksrv01
r3qas01已经安装networker client软件,和备份服务器/etc/hosts已经相互添加,安装client方法可以参考我的博客《 安装networker备份软件client on Solaris10》http://blog.itpub.net/27771627/viewspace-1252093/
配置networker备份软件server端
使用group ADCI_LZ
client 为r3qas01
使用pool LZpool
label 一盘空磁带LZpool里面
配置SAP
修改initX01.sap 配置文件,主要修改以下两处,其他不变
配置后日志内容如下
bash-3.00# grep -v "#" initX01.sap
backup_mode = all
restore_mode = all
backup_type = online
backup_dev_type = util_file
backup_root_dir = /oracle/X01/sapbackup
stage_root_dir = /oracle/X01/sapbackup
compress = no
compress_cmd = "compress -c $ > $"
uncompress_cmd = "uncompress -c $ > $"
compress_dir = /oracle/X01/sapreorg
archive_function = copy_delete_save
archive_copy_dir = /oracle/X01/sapbackup
archive_stage_dir = /oracle/X01/sapbackup
tape_copy_cmd = cpio
disk_copy_cmd = copy
stage_copy_cmd = rcp
pipe_copy_cmd = rsh
cpio_flags = -ovB
cpio_in_flags = -iuvB
cpio_disk_flags = -pdcu
dd_flags = "obs=64k bs=64k"
dd_in_flags = "ibs=64k bs=64k"
saveset_members = 1
copy_out_cmd = "dd ibs=8k obs=64k of=$"
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind = "mt -f $ rewind"
rewind_offline = "mt -f $ offline"
tape_pos_cmd = "mt -f $ fsf $"
tape_size = 100G
exec_parallel = 0
tape_address = /dev/rmt/0mn
tape_address_rew = /dev/rmt/0m
volume_archive = (X01A01, X01A02, X01A03, X01A04, X01A05,
X01A06, X01A07, X01A08, X01A09, X01A10,
X01A11, X01A12, X01A13, X01A14, X01A15,
X01A16, X01A17, X01A18, X01A19, X01A20,
X01A21, X01A22, X01A23, X01A24, X01A25,
X01A26, X01A27, X01A28, X01A29, X01A30)
volume_backup = (X01B01, X01B02, X01B03, X01B04, X01B05,
X01B06, X01B07, X01B08, X01B09, X01B10,
X01B11, X01B12, X01B13, X01B14, X01B15,
X01B16, X01B17, X01B18, X01B19, X01B20,
X01B21, X01B22, X01B23, X01B24, X01B25,
X01B26, X01B27, X01B28, X01B29, X01B30)
expir_period = 30
tape_use_count = 100
util_par_file = initX01.utl
修改initX01.utl文件,若没有该文件创建一个,里面填写group、pool、server等信息。
/sapmnt/X01/exe/下面要有backint执行文件,发起备份时候需要调用,若没有在sap网站上下载或者在别的系统拷贝一个放在exe目录下,修改权限。
配置完成,使用brtools发起归档备份测试,也可以使用t-code DB13发起,详细执行步骤可参考我的博客
《 sap使用DB13和brtools发起oracle数据库备份》http://blog.itpub.net/27771627/viewspace-1251782/
R3QAS01:orax01 1% brtools
BR0651I BRTOOLS 7.20 (27)
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.11
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu
1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.23
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.23
BR0656I Choice menu 9 - please make a selection
-------------------------------------------------------------------------------
Backup and database copy
1 = Database backup
2 - Archivelog backup
3 - Database copy
4 - Non-database backup
5 - Backup of database disk backup
6 - Verification of database backup
7 - Verification of archivelog backup
8 - Additional functions
9 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.43
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.43
BR0657I Input menu 17 - please enter/check input values
-------------------------------------------------------------------------------
BRARCHIVE main options for archivelog backup and verification
1 - BRARCHIVE profile (profile) ...... [initX01.sap]
2 - BRARCHIVE function (function) .... [copy_delete_save]
3 - Backup device type (device) ...... [util_file]
4 # Tape volumes for backup (volume) . []
5 ~ BACKINT/Mount profile (parfile) .. [initX01.utl]
6 - Database user/password (user) .... [/]
7 ~ Maximum number of files (number) . []
8 - Back up disk backup (archive) .... [no]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.46
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.46
BR0657I Input menu 18 - please enter/check input values
-------------------------------------------------------------------------------
Additional BRARCHIVE options for archivelog backup
1 - Confirmation mode (confirm) ....... [yes]
2 - Query mode (query) ................ [no]
3 - Compression mode (compress) ....... [no]
4 - Verification mode (verify) ........ [no]
5 - Fill mode, group size (fill) ...... [no]
6 - Modify mode, delay apply (modify) . [no]
7 - Additional output (output) ........ [no]
8 - Message language (language) ....... [E]
9 - BRARCHIVE command line (command) .. [-p initX01.sap -copy_delete_save -d util_file -r initX01.utl -k no -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.47
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRARCHIVE will be started with options '-p initX01.sap -copy_delete_save -d util_file -r initX01.utl -k no -l E'
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.47
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2014-08-18 12.16.48
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0002I BRARCHIVE 7.20 (27)
BR0006I Start of offline redolog processing: aeonwikm.cds 2014-08-18 12.16.48
BR0484I BRARCHIVE log file: /oracle/X01/saparch/aeonwikm.cds
BR0477I Oracle pfile /oracle/X01/112_64/dbs/initX01.ora created from spfile /oracle/X01/112_64/dbs/spfileX01.ora
BR0280I BRARCHIVE time stamp: 2014-08-18 12.16.52
BR0008I Offline redolog processing for database instance: X01
BR0009I BRARCHIVE action ID: aeonwikm
BR0010I BRARCHIVE function ID: cds
BR0048I Archive function: copy_delete_save
BR0011I 458 offline redolog files found for processing, total size 74708.677 MB
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility at file level
BR0280I BRARCHIVE time stamp: 2014-08-18 12.16.52
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:
c
BR0280I BRARCHIVE time stamp: 2014-08-18 12.16.56
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRARCHIVE time stamp: 2014-08-18 12.16.56
BR0229I Calling backup utility with function 'backup'...
备份发起成功,磁带已经被载入16cbn,显示writing状态
查看备份结果
配置完成