sap使用DB13和brtools發起oracle資料庫備份

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路徑即可

登入sap系統 使用t-code db13發起備份，備份先檢查資料庫大小以及空間是否

選擇離線全備，亦可以根據需要選擇其他選項

這時系統登入斷掉了，已經開始離線備份

進入sapbackup目錄檢視備份日誌

等待備份完成。

備份成功

db12檢視備份結果

使用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:

備份已發起，等待備份完成

配置完成