sap使用DB13和brtools发起oracle数据库备份
sap版本:erp6.0sap所使用数据库版本:oracle 11g修改配置文件/oracle/X01/11202/dbs/initX.sap,只需修改一下几处,其他默认...
sap版本:erp6.0
sap所使用数据库版本:oracle 11g
修改配置文件/oracle/X01/11202/dbs/initX.sap,只需修改一下几处,其他默认不变,其中backup_type是默认选项,真正发起时可以指定需要的选项。
backup_dev_type 选择disk,若是nfs也选择disk,其他的磁带等根据需要选择。若是nfs只需将backup_root_dir 、archive_copy_dir 后面填写mount的NFS路径即可
登录sap系统 使用t-code db13发起备份,备份先检查数据库大小以及空间是否
选择离线全备,亦可以根据需要选择其他选项
这时系统登录断掉了,已经开始离线备份
进入sapbackup目录查看备份日志
等待备份完成。
备份成功
db12查看备份结果
使用brtools发起online备份,使用orax01用户
# su - orax01
R3QAS01:orax01 1% brtools
BR0651I BRTOOLS 7.20 (27)
BR0280I BRTOOLS time stamp: 2014-08-15 12.35.44
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 // 选择4数据库备份选项
BR0280I BRTOOLS time stamp: 2014-08-15 12.35.47
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2014-08-15 12.35.47
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:
1 //选择1数据库备份
BR0280I BRTOOLS time stamp: 2014-08-15 12.35.56
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2014-08-15 12.35.56
BR0657I Input menu 15 - please enter/check input values
-------------------------------------------------------------------------------
BRBACKUP main options for backup and database copy
1 - BRBACKUP profile (profile) ....... [initX01.sap]
2 - Backup device type (device) ...... [disk]
3 # Tape volumes for backup (volume) . []
4 # BACKINT/Mount profile (parfile) .. []
5 - Database user/password (user) .... [/]
6 - Backup type (type) ............... [online]
7 # Disk backup for backup (backup) .. [no]
8 # Delete disk backup (delete) ...... [no]
9 ~ Files for backup (mode) .......... [all]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c // 查看选项,无误输入c继续,需要修改进入响应数字更改
BR0280I BRTOOLS time stamp: 2014-08-15 12.36.16
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRTOOLS time stamp: 2014-08-15 12.36.16
BR0657I Input menu 16 - please enter/check input values
-------------------------------------------------------------------------------
Additional BRBACKUP options for backup and database copy
1 - Confirmation mode (confirm) ....... [yes]
2 - Query mode (query) ................ [no]
3 - Compression mode (compress) ....... [no]
4 - Verification mode (verify) ........ [no]
5 - Fill-up previous backups (fillup) . [no]
6 - Parallel execution (execute) ...... [0]
7 - Additional output (output) ........ [no]
8 - Message language (language) ....... [E]
9 - BRBACKUP command line (command) ... [-p initX01.sap -d disk -t online -m all -k no -e 0 -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c //查看选项,无误输入c继续
BR0280I BRTOOLS time stamp: 2014-08-15 12.36.20
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRBACKUP will be started with options '-p initX01.sap -d disk -t online -m all -k no -e 0 -l E'
BR0280I BRTOOLS time stamp: 2014-08-15 12.36.20
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c //查看选项,无误输入c继续
BR0280I BRTOOLS time stamp: 2014-08-15 12.36.22
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0051I BRBACKUP 7.20 (27)
BR0055I Start of database backup: beonhqsk.and 2014-08-15 12.36.22
BR0484I BRBACKUP log file: /oracle/X01/sapbackup/beonhqsk.and
BR0477I Oracle pfile /oracle/X01/112_64/dbs/initX01.ora created from spfile /oracle/X01/112_64/dbs/spfileX01.ora
BR0280I BRBACKUP time stamp: 2014-08-15 12.36.34
BR0319I Control file copy created: /oracle/X01/sapbackup/cntrlX01.dbf 20267008
BR0280I BRBACKUP time stamp: 2014-08-15 12.36.36
BR0057I Backup of database: X01
BR0058I BRBACKUP action ID: beonhqsk
BR0059I BRBACKUP function ID: and
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/X01/sapbackup/cntrlX01.dbf
BR0061I 41 files found for backup, total size 100459.641 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: disk
BR0106I Files will be saved on disk in directory: /oracle/X01/sapbackup/beonhqsk
BR0280I BRBACKUP time stamp: 2014-08-15 12.36.36
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
备份已发起,等待备份完成
配置完成
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27771627/viewspace-1251782/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27771627/viewspace-1251782/
更多推荐
所有评论(0)