Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to backup and restore brtools, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Brtools is a backup and recovery tool that comes with sap, which can be installed separately. It is more convenient to use this tool to do backup and recovery.

I. backup process

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:

four

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 # Reserve Library

2-Archivelog backup # prepare for filing, and also pay attention to manual preparation of control files

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:

one

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 can be used locally, and tape can be used remotely

3 # Tape volumes for backup (volume). []

4 # BACKINT/Mount profile (parfile).. []

5-Database user/password (user).... [/]

6-Backup type (type). [offline] backup mode can also be 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:

six

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 (choose C to continue)

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] can not be compressed

4-Verification mode (verify). [no] Verification can be unselected

5-Fill-up previous backups (fillup). [no] you don't have to fill in the previous backup

6-Parallel execution (execute). [0] parallel execution

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

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

II. Recovery process

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:

five

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

Recovery and Application of 6-Restore and application of archivelog files # Archive Log File

7-Disaster recovery

8-Reset program status

Standard keys: C-cont, b-back, s-stop, r-refr, h-help

BR0662I Enter your choice:

one

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

Until the recovery is complete.

Add: brtools+rman backup method can be used for SAP: brtools is based on file-level backup, rman backup is based on block-level backup, which is only for block backup with data; in addition, rman can use multi-channel backup, so that multiple session can be opened for backup at the same time (of course, this requires that the amount of drive data in the tape library matches the .sap configuration of sap)

How to modify the number of rman_channel: open the initSID.utl configuration file

# vi initSID.utl

Rman_channel = 2 # modified to 2 channels

How to modify the number of sap_channel: open the initSID.sap configuration file

# vi initSID.sap

Max_session = 3 # modified to 3 channels

Thank you for reading this article carefully. I hope the article "how to back up and restore brtools" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.