brtools备份与恢复-白红宇

brtools备份与恢复

阅读量：6426 次

发布时间：2019-06-23

本文共 11710 字，大约阅读时间需要 39 分钟。

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:

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:

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:

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

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:

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:

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

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:

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:

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:

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:

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:

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个通道

本文出自 “” 博客，请务必保留此出处

转载于:https://blog.51cto.com/lujiesky/1154738

你可能感兴趣的文章

SSIS 数据类型和类型转换

查看>>

Oracle数据库“Specified cast is农田valid”