brtools如何备份与恢复


这篇文章主要介绍了brtools如何备份与恢复,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。brtools是sap自带的一个备份和恢复工具,可以单独安装,用这个工具来做备份与恢复比较方便。一、备份过程C:Documents and Settingsbwdevadm>brtools
BR0651I BRTOOLS 7.00 (24)BR0280I BRTOOLS time stamp: 2012-04-11 14.11.57
BR0656I Choice menu 1 – please make a selection
——————————————————————————-
BR*Tools main menu1 = 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 programStandard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2012-04-11 14.12.02
BR0663I Your choice: ‘4’BR0280I BRTOOLS time stamp: 2012-04-11 14.12.02
BR0656I Choice menu 9 – please make a selection
——————————————————————————-
Backup and database copy1 = 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 statusStandard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2012-04-11 14.12.04
BR0663I Your choice: ‘1’BR0280I BRTOOLS time stamp: 2012-04-11 14.12.04
BR0657I Input menu 15 – please check/enter input values
——————————————————————————-
BRBACKUP main options for backup and database copy1 – BRBACKUP profile (profile) ……. [initbwd.sap]
2 – Backup device type (device) …… [disk]本地可使用disk,如果远程可使用tape
3 # Tape volumes for backup (volume) . []
4 # BACKINT/Mount profile (parfile) .. []
5 – Database user/password (user) …. [/]
6 – Backup type (type) …………… [offline]备份模式也可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:
6
BR0280I BRTOOLS time stamp: 2012-04-11 14.12.59
BR0663I Your choice: ‘6’BR0280I BRTOOLS time stamp: 2012-04-11 14.12.59
BR0681I Enter string value for “type” (offline|offline_force|offline_standby|off
line_split|offline_mirror|offline_stop|online|online_cons|online_split|online_mi
rror|online_standby|offstby_split|offstby_mirror) [offline]:
offline_force
BR0280I BRTOOLS time stamp: 2012-04-11 14.13.09
BR0683I New value for “type”: ‘offline_force’BR0280I BRTOOLS time stamp: 2012-04-11 14.13.09
BR0657I Input menu 15 – please check/enter input values
——————————————————————————-
BRBACKUP main options for backup and database copy1 – BRBACKUP profile (profile) ……. [initbwd.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) …………… [offline_force]
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: 2012-04-11 14.13.37
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…BR0280I BRTOOLS time stamp: 2012-04-11 14.13.37
BR0657I Input menu 16 – please check/enter input values
——————————————————————————-
Additional BRBACKUP options for backup and database copy1 – 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 initbwd.sap -d disk -t offline_forc
e -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
BR0280I BRTOOLS time stamp: 2012-04-11 14.13.40
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…BR0291I BRBACKUP will be started with options ‘-p initbwd.sap -d disk -t offline
_force -m all -k no -e 0 -l E’BR0280I BRTOOLS time stamp: 2012-04-11 14.13.40
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2012-04-11 14.13.41
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…###############################################################################BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: beelvlfp.afd 2012-04-11 14.13.41
BR0484I BRBACKUP log file: D:oraclebwdsapbackupbeelvlfp.afd
BR0477I Oracle pfile D:oraclebwd102databaseinitbwd.ora created from spfile
D:oraclebwd102databasespfilebwd.oraBR0280I BRBACKUP time stamp: 2012-04-11 14.13.48
BR0057I Backup of database: bwd
BR0058I BRBACKUP action ID: beelvlfp
BR0059I BRBACKUP function ID: afd
BR0110I Backup mode: ALL
BR0077I Database files for backup:
D:ORACLEbwdORIGLOGALOG_G11M1.DBF
D:ORACLEbwdORIGLOGBLOG_G12M1.DBF
D:ORACLEbwdORIGLOGALOG_G13M1.DBF
D:ORACLEbwdORIGLOGBLOG_G14M1.DBF
D:oraclebwdoriglogAcntrlcntlrbwd.dbf
BR0061I 70 files found for backup, total size 128961.432 MB
BR0143I Backup type: offline_force
BR0112I Files will not be compressed
BR0130I Backup device type: disk
BR0106I Files will be saved on disk in directory: D:oraclebwdsapbackupbeelvl
fp
BR0064I Database instance bwd will be shut down now
BR0280I BRBACKUP time stamp: 2012-04-11 14.13.48
BR0256I Enter ‘c[ont]’ to continue, ‘s[top]’ to cancel BRBACKUP:
c
BR0280I BRBACKUP time stamp: 2012-04-11 14.14.11
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…BR0370I Directory D:oraclebwdsapbackupbeelvlfp created
BR0370I Directory D:oraclebwdsapbackupbwd createdBR0202I Saving init_ora
BR0203I to D:oraclebwdsapbackupbwd …BR0202I Saving D:oraclebwd102databaseinitbwd.sap
BR0203I to D:oraclebwdsapbackupbwd …BR0280I BRBACKUP time stamp: 2012-04-11 14.14.11
BR0198I Profiles saved successfullyBR0280I BRBACKUP time stamp: 2012-04-11 14.14.11
BR0307I Shutting down database instance bwd …BR0280I BRBACKUP time stamp: 2012-04-11 14.14.38
BR0308I Shutdown of database instance bwd successfulBR0202I Saving D:ORACLEbwdSAPDATA1SR3_10SR3.DATA10
BR0203I to D:oraclebwdsapbackupbeelvlfpSR3.DATA10 …#FILE….. D:ORACLEbwdSAPDATA1SR3_10SR3.DATA10
#SAVED…. D:oraclebwdsapbackupbeelvlfpSR3.DATA10 #1/1BR0280I BRBACKUP time stamp: 2012-04-11 14.15.37
BR0063I 1 of 70 files processed – 2000.008 MB of 128961.432 MB done
BR0204I Percentage done: 1.55%, estimated end time: 15:46
BR0001I *_________________________________________________BR0202I Saving D:ORACL开发云主机域名EbwdSAPDATA1SR3_11SR3.DATA11
BR0203I to D:oraclebwdsapbackupbeelvlfpSR3.DATA11 …#FILE….. D:ORACLEbwdSAPDATA1SR3_11SR3.DATA11
#SAVED…. D:oraclebwdsapbackupbeelvlfpSR3.DATA11 #1/2BR0280I BRBACKUP time stamp: 2012-04-11 14.16.50
BR0063I 2 of 70 files processed – 4000.016 MB of 128961.432 MB done
BR0204I Percentage done: 3.10%, estimated end time: 15:39
BR0001I **________________________________________________BR0202I Saving D:ORACLEbwdSAPDATA1SR3_12SR3.DATA12
BR0203I to D:oraclebwdsapbackupbeelvlfpSR3.DATA12 …#FILE….. D:ORACLEbwdSAPDATA1SR3_12SR3.DATA12
#SAVED…. D:oraclebwdsapbackupbeelvlfpSR3.DATA12 #1/3……………………………………BR0202I Saving D:oraclebwdsapbackupbackbwd.log
BR0203I to D:oraclebwdsapbackupbwd …BR0056I End of database backup: beelvlfp.afd 2012-04-11 15.36.16
BR0280I BRBACKUP time stamp: 2012-04-11 15.36.23
BR0052I BRBACKUP completed successfully
——————————————————————————-
二、恢复过程C:Documents and Settingsbwdevadm>brtools
BR0651I BRTOOLS 7.00 (24)BR0280I BRTOOLS time stamp: 2012-04-11 16.11.57
BR0656I Choice menu 1 – please make a selection
——————————————————————————-
BR*Tools main menu1 = 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 programStandard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
5
BR0280I BRTOOLS time stamp: 2012-04-11 16.12.02
BR0663I Your choice: ‘5’BR0280I BRTOOLS time stamp: 2012-04-11 16.12.02
BR0656I Choice menu 11 – please make a selection
——————————————————————————-
Restore and recovery1 -Complete database recovery
2 – Database point-in-time recovery
3 – Tablespace point-in-time recovery
4 – Whole database reset
5 – Restore of individual backup files
6 – Restore and application of archivelog files #归档日志文件的恢复与应用
7 – Disaster recovery
8 – Reset program statusStandard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2012-04-11 16.13.02
BR0663I Your choice: ‘1’BR0280I BRTOOLS time stamp: 2012-04-11 16.13.12
BR0657I Input menu 34 – please check/enter input values
——————————————————————————-
BRRECOVER options for restore and recovery1 – BRRECOVER profile (profile) …… [initbwd.sap]
2 ~ BACKINT/Mount profile (parfile) .. [/oracle/bwd/102_64/dbs/initbwd.utl]
3 – Database user/password (user) …. [/]
4 – Recovery interval (interval) ….. [30]
5 – Confirmation mode (confirm) …… [yes]
6 – Scrolling line count (scroll) …. [20]
7 – Message language (language) …… [E]
8 – BRRECOVER command line (command) . [-p initbwd.sap –
r /oracle/bwd/102_64/dbs/initbwd.utl -t complete -i 30 -s 20 -l E]Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2012-04-11 16.13.52
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…BR0291I BRRECOVER will be started with options ‘-p initbwd.sap –
r /oracle/bwd/102_64/dbs/initbwd.utl -t complete -i 30 -s 20 -l E’BR0280I BRTOOLS time stamp: 2012-04-11 16.14.12
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2008-10-24 19.31.38
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…至此一直到恢复完成。补充:针对SAP可使用brtools+rman备份方法:brtools是基于文件级的备份,rman备份是基于block级的备份,它只对有数据的block备份;另外,rman可以采用多channel备份,这样可以同时开多个session进行备份(当然,这需要磁带库的drive数据量与sap的.sap配置相匹配)
修改rman_channel数的方法:打开initSID.utl配置文件
#vi initSID.utl
rman_channel =2 #修改为2个通道修改sap_channel数的方法:打开initSID.sap配置文件
#vi initSID.sap
max_session =3 #修改为3个通道感谢你能够认真阅读完这篇文章,希望小编分享的“brtools如何备份与恢复”这篇文章对大家有帮助,同时也希望大家多多支持开发云,关注开发云行业资讯频道,更多相关知识等着你来学习!

相关推荐: SSL证书怎样筑起防火墙

这篇文章给大家介绍SSL证书怎样筑起防火墙,内容非常详细,感兴趣的小伙伴们可以参考借鉴,希望对大家能有所帮助。随着我们互联网技术的发展,这也是黑客盗窃财产的一种非常方便的方式。因此,我们都需要保护数据传输的安全,这样用户才能安全地浏览我们的网站,这也是对用户的…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 05/17 11:53
下一篇 05/17 11:53

相关推荐