brtools如何備份與恢復(fù)

這篇文章主要介紹了brtools如何備份與恢復(fù)，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓小編帶著大家一起了解一下。

創(chuàng)新互聯(lián)建站網(wǎng)站建設(shè)提供從項目策劃、軟件開發(fā)，軟件安全維護、網(wǎng)站優(yōu)化(SEO)、網(wǎng)站分析、效果評估等整套的建站服務(wù)，主營業(yè)務(wù)為成都網(wǎng)站設(shè)計、做網(wǎng)站，成都App制作以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。創(chuàng)新互聯(lián)建站深信只要達到每一位用戶的要求，就會得到認(rèn)可，從而選擇與我們長期合作。這樣，我們也可以走得更遠(yuǎn)！

brtools是sap自帶的一個備份和恢復(fù)工具，可以單獨安裝，用這個工具來做備份與恢復(fù)比較方便。

一、備份過程

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,如果遠(yuǎn)程可使用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.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繼續(xù))
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]并行執(zhí)行
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

-------------------------------------------------------------------------------
二、恢復(fù)過程

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

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 #歸檔日志文件的恢復(fù)與應(yīng)用
7 - Disaster recovery
8 - Reset program status

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...

至此一直到恢復(fù)完成。

補充：針對SAP可使用brtools+rman備份方法：brtools是基于文件級的備份，rman備份是基于block級的備份，它只對有數(shù)據(jù)的block備份；另外，rman可以采用多channel備份，這樣可以同時開多個session進行備份（當(dāng)然，這需要磁帶庫的drive數(shù)據(jù)量與sap的.sap配置相匹配）
修改rman_channel數(shù)的方法：打開initSID.utl配置文件
#vi initSID.utl
rman_channel =2 #修改為2個通道

修改sap_channel數(shù)的方法：打開initSID.sap配置文件
#vi initSID.sap
max_session =3 #修改為3個通道

感謝你能夠認(rèn)真閱讀完這篇文章，希望小編分享的“brtools如何備份與恢復(fù)”這篇文章對大家有幫助，同時也希望大家多多支持創(chuàng)新互聯(lián)，關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，更多相關(guān)知識等著你來學(xué)習(xí)!

分享題目：brtools如何備份與恢復(fù)
文章來源：http://bm7419.com/article16/pcedgg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設(shè)計、定制網(wǎng)站、自適應(yīng)網(wǎng)站、網(wǎng)站排名、網(wǎng)站維護、建站公司

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容