ITPub博客

首页 > 数字化转型 > ERP > sap使用DB13和brtools发起oracle数据库备份

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

ERP 作者:chuanhailiu 时间:2016-05-23 19:28:58 0 删除 编辑

    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路径即可

    clip_image001



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

    clip_image002



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

    clip_image003



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

    clip_image004



    进入sapbackup目录查看备份日志

    clip_image005



    等待备份完成。

    备份成功

    clip_image006



    db12查看备份结果

    clip_image007




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

请登录后发表评论 登录
全部评论

注册时间:2010-10-19

  • 博文量
    9
  • 访问量
    20766