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

来源：互联网发布：怎样才能成为网络写手编辑：程序博客网时间：2024/06/05 08:29

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:

备份已发起，等待备份完成

配置完成

0 0