共計 10433 個字符，預計需要花費 27 分鐘才能閱讀完成。
這篇文章主要介紹了 brtools 如何備份與恢復，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓丸趣 TV 小編帶著大家一起了解一下。
brtools 是 sap 自帶的一個備份和恢復工具，可以單獨安裝，用這個工具來做備份與恢復比較方便。
一、備份過程
C:\Documents and Settings\bwdevadm 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 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
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 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
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 copy
1 – 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 copy
1 – 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 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 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:\oracle\bwd\sapbackup\beelvlfp.afd
BR0477I Oracle pfile D:\oracle\bwd\102\database\initbwd.ora created from spfile
D:\oracle\bwd\102\database\spfilebwd.ora
BR0280I 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:\ORACLE\bwd\ORIGLOGA\LOG_G11M1.DBF
D:\ORACLE\bwd\ORIGLOGB\LOG_G12M1.DBF
D:\ORACLE\bwd\ORIGLOGA\LOG_G13M1.DBF
D:\ORACLE\bwd\ORIGLOGB\LOG_G14M1.DBF
D:\oracle\bwd\origlogA\cntrl\cntlrbwd.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:\oracle\bwd\sapbackup\beelvl
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:\oracle\bwd\sapbackup\beelvlfp created
BR0370I Directory D:\oracle\bwd\sapbackup\bwd created
BR0202I Saving init_ora
BR0203I to D:\oracle\bwd\sapbackup\bwd …
BR0202I Saving D:\oracle\bwd\102\database\initbwd.sap
BR0203I to D:\oracle\bwd\sapbackup\bwd …
BR0280I BRBACKUP time stamp: 2012-04-11 14.14.11
BR0198I Profiles saved successfully
BR0280I 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 successful
BR0202I Saving D:\ORACLE\bwd\SAPDATA1\SR3_10\SR3.DATA10
BR0203I to D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA10 …
#FILE….. D:\ORACLE\bwd\SAPDATA1\SR3_10\SR3.DATA10
#SAVED…. D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA10 #1/1
BR0280I 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:\ORACLE\bwd\SAPDATA1\SR3_11\SR3.DATA11
BR0203I to D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA11 …
#FILE….. D:\ORACLE\bwd\SAPDATA1\SR3_11\SR3.DATA11
#SAVED…. D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA11 #1/2
BR0280I 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:\ORACLE\bwd\SAPDATA1\SR3_12\SR3.DATA12
BR0203I to D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA12 …
#FILE….. D:\ORACLE\bwd\SAPDATA1\SR3_12\SR3.DATA12
#SAVED…. D:\oracle\bwd\sapbackup\beelvlfp\SR3.DATA12 #1/3
……………………………………
BR0202I Saving D:\oracle\bwd\sapbackup\backbwd.log
BR0203I to D:\oracle\bwd\sapbackup\bwd …
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 Settings\bwdevadm 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 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:
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 recovery
1 -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 status
Standard 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 recovery
1 – 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 個通道
感謝你能夠認真閱讀完這篇文章，希望丸趣 TV 小編分享的“brtools 如何備份與恢復”這篇文章對大家有幫助，同時也希望大家多多支持丸趣 TV，關注丸趣 TV 行業資訊頻道，更多相關知識等著你來學習!
