1. 首页
  2. IT资讯

sap使用DB13和brtools发起oracle数据库备份

    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使用DB13和brtools发起oracle数据库备份

    登录sap系统 使用t-code db13发起备份,备份先检查数据库大小以及空间是否

    sap使用DB13和brtools发起oracle数据库备份

    选择离线全备,亦可以根据需要选择其他选项

    sap使用DB13和brtools发起oracle数据库备份

    这时系统登录断掉了,已经开始离线备份

    sap使用DB13和brtools发起oracle数据库备份

    进入sapbackup目录查看备份日志

    sap使用DB13和brtools发起oracle数据库备份

    等待备份完成。

    备份成功

    sap使用DB13和brtools发起oracle数据库备份

    db12查看备份结果

    sap使用DB13和brtools发起oracle数据库备份

    使用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/223653/viewspace-1370591/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:℅傍ㄖ免沦陷dε鬼,转转请注明出处:http://www.cxybcw.com/192148.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code