Production Backup

[Former Member]

Hi All

I want to take full & incremental PRD backup by Scheduling .

Please help me in detail , how can i take backup step by step

Best Regard

IMRAN KHAN

[former_member227600]

Hi,

If you are using oracle database than you can take backup using brtools(online or offline). login as user <sid>adm & run brtools command at command prompt.Than you will get a menuy driven screen .

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:

select option 4(Backup & database copy)

than you get the following screen

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

-

---

select 8(Additional functions)

you get the following screen

Additional functions for backup and copy

1 = Update of compression rates

2 - Preparation of RMAN backups

3 - Deletion of database disk backups

4 - Deletion of archivelog disk backups

5 - Controlling of BRARCHIVE run

6 - Initialization of BRBACKUP tape volumes

7 - Initialization of BRARCHIVE tape volumes

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

-

---

select option 6(Initialization of BRBACKUP tape volumes)

than u get the following screen

Options for initialization of BRBACKUP tape volumes

1 - BRBACKUP profile (profile) ....... [initPRD.sap]

2 - Initialization type (initialize) . [rename]

3 ~ Number of volumes (number) ....... []

4 - Confirmation mode (confirm) ...... [yes]

5 - Message language (language) ...... [E]

6 ~ Tape volume names (volume) ....... [PRDB01]

7 - BRBACKUP command line (command) .. [-p initPRD.sap -i -l E -v PRDB01]

choose option 2 & put force & enter

than choose 6 give tape name which one you define in init<sid>.sap file

than press "c"

press "c" to initialize the tape

After that go back to main menu

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

chose option 1

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... [initPRD.sap]

2 - Backup device type (device) ...... [tape]

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

-

---

chose option 3

give the tape volume name (Ex -PRDB01)

tahn c & c&c &c backup will start

Let me know If you have any query related to backup.

Karan

[Former Member]

hi karan & All

Thanks for reply Karan , plz also tell me in detail how can i take backup through DB12 .

Best Regard

Imran Khan

[Former Member]

Hi,

you can schedule backup useing DB13.

Run command DB13.

Select the Date on which you schedule the backup.

ckick on create button

In Action field select the Backup Type that you want to run.

Give date and time.

Give the Tape name if you taking the backup on tape else leave blank.

Write name of the profile init<sid>.sap

Check the button BRBACKUP verify option if you want to verify the backed up files.

Againg write the profile init<sid>.sap name for archile log backup (if taking)

Select the -s option for Function field.

Check the button BRarchive verify option if you want to verify the backed up files.

Click add / Execute Immediate.

Thats all.

[former_member227600]

Hi,

Backup procedure using DB13 have described by keyur.

Keyur told you all the steps & Initilize the tape before & than execute the backup.You can initilize the tape using Brtools which i described in my pervious message.

karan

[Former Member]

hi Karan and all

I have taken backup on disk through DB13 successfully, but now i want to take backup on Tape Drive. when i want to initialize Tape drive via BRTOOLs,It terminated with following errors

BR0651I BRTOOLS 7.00 (31)

BR0280I BRTOOLS time stamp: 2008-09-03 17.44.42
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: 2008-09-03 17.44.44
BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2008-09-03 17.44.44
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:
8
BR0280I BRTOOLS time stamp: 2008-09-03 17.45.00
BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2008-09-03 17.45.00
BR0656I Choice menu 10 - please make a selection
-------------------------------------------------------------------------------
Additional functions for backup and copy

 1 = Update of compression rates
 2 - Preparation of RMAN backups
 3 - Deletion of database disk backups
 4 - Deletion of archivelog disk backups
 5 - Controlling of BRARCHIVE run
 6 - Initialization of BRBACKUP tape volumes
 7 - Initialization of BRARCHIVE tape volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2008-09-03 17.45.00
BR0663I Your choice: '6'

BR0280I BRTOOLS time stamp: 2008-09-03 17.45.00
BR0657I Input menu 32 - please check/enter input values
-------------------------------------------------------------------------------
Options for initialization of BRBACKUP tape volumes

 1 - BRBACKUP profile (profile) ....... [initDEV.sap]
 2 - Initialization type (initialize) . [rename]
 3 ~ Number of volumes (number) ....... []
 4 - Confirmation mode (confirm) ...... [yes]
 5 - Message language (language) ...... [E]
 6 ~ Tape volume names (volume) ....... [DEVB01]
 7 - BRBACKUP command line (command) .. [-p initDEV.sap -i -l E -v DEVB01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2008-09-03 17.45.22
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2008-09-03 17.45.22
BR0681I Enter string value for "initialize" (rename|force|show) [rename]:
force
BR0280I BRTOOLS time stamp: 2008-09-03 17.45.26
BR0683I New value for "initialize": 'force'

BR0280I BRTOOLS time stamp: 2008-09-03 17.45.26
BR0657I Input menu 32 - please check/enter input values
-------------------------------------------------------------------------------
Options for initialization of BRBACKUP tape volumes

 1 - BRBACKUP profile (profile) ....... [initDEV.sap]
 2 - Initialization type (initialize) . [force]
 3 ~ Number of volumes (number) ....... []
 4 - Confirmation mode (confirm) ...... [yes]
 5 - Message language (language) ...... [E]
 6 ~ Tape volume names (volume) ....... [DEVB01]
 7 - BRBACKUP command line (command) .. [-p initDEV.sap -i force -l E -v DEVB01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2008-09-03 17.45.44
BR0663I Your choice: '6'

BR0280I BRTOOLS time stamp: 2008-09-03 17.45.44
BR0681I Enter string value for "volume" (scratch|<tape_vol>|<tape_vol_list>) [DEVB01]:
*DEVB01*
BR0280I BRTOOLS time stamp: 2008-09-03 17.50.19
BR0683I New value for "volume": 'DEVB01'

BR0280I BRTOOLS time stamp: 2008-09-03 17.50.19
BR0657I Input menu 32 - please check/enter input values
-------------------------------------------------------------------------------
Options for initialization of BRBACKUP tape volumes

 1 - BRBACKUP profile (profile) ....... [initDEV.sap]
 2 - Initialization type (initialize) . [force]
 3 ~ Number of volumes (number) ....... []
 4 - Confirmation mode (confirm) ...... [yes]
 5 - Message language (language) ...... [E]
 6 ~ Tape volume names (volume) ....... [DEVB01]
 7 - BRBACKUP command line (command) .. [-p initDEV.sap -i force -l E -v DEVB01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
*c*
BR0280I BRTOOLS time stamp: 2008-09-03 17.50.23
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initDEV.sap -i force -l E -v DEVB01'

BR0280I BRTOOLS time stamp: 2008-09-03 17.50.23
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

plz tell me how can i resolve above error....

Best Regard

Imran Khan

[Former Member]

Imran,

which error?

[Former Member]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2008-09-03 18.33.14
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initDEV.sap -i force -l E -v DEVB01'

BR0280I BRTOOLS time stamp: 2008-09-03 18.33.14
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2008-09-03 18.33.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR0051I BRBACKUP 7.00 (31)
BR0282E Directory '$SAPDATA_HOME/sapbackup' not found
BR0182E Checking parameter/option 'backup_root_dir' failed

BR0206I End of backup volume initialization
BR0280I BRBACKUP time stamp: 2008-09-03 18.33.17
BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2008-09-03 18.33.17
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

i have repeated it ..

regards,

imran

[Former Member]

Imran, you need to check your env settings.

Have a look at variables SAPDATA_HOME and SAPBACKUP.