How to restore backup from Tivoli storage manager

[Former Member]

Hi Good day,

using AIX 5.3 with Oracle 10.2

I have (all offline + log) & (all online + log) backup's from db13 from of last week.

At the moment if i planned to restore (all offline + log) or (all online + log) for any specific date between 1st april to 5th april. How should i restore.

Looking for a restore procedure from TSM.

[stefan_koehler]

Hello Rahul,

a little step by step guide.

1) Install the TSM TDP for mySAP client

shell> lslpp -L tivoli.tsm.tdpr3.ora.64bit
  Fileset                      Level  State  Type  Description (Uninstaller)
  ----------------------------------------------------------------------------
  tivoli.tsm.tdpr3.ora.64bit
                             5.5.0.0    C     P    Data Protection for SAP
                                                   (/usr/tivoli/tsm/tdp_r3/ora64)

2) Create/edit your corresponding dsm.sys and dsm.opt file

Maybe you have to perform also the password generate step, but this depends on your tsm client configuration.

3) Edit init<SID>.sap in /oracle/<SID>/102_64/dbs

# backup device type
backup_dev_type = util_file
# backup utility parameter file
# default: no parameter file
util_par_file = init<SID>.utl

4) Edit init<SID>.utl in /oracle/<SID>/102_64/dbs

BACKUPIDPREFIX <THE_SAME_AS_THE_BACKUP_WAS_PEFORMED_WITH>

#**************************************************************************
# New Statement for multiple Servers and multiple Paths.
# may be used multiple times (one for each server).
#**************************************************************************

    SERVER              <SERVER_NAME_FROM_DSM_SYS>                  
    SESSIONS            1                        
    PASSWORDREQUIRED    <YES_OR_NO_DEPENDS_ON_YOUR_TSM_CONFIG>                              
    BRBACKUPMGTCLASS    <YOUR_TSM_BACKUP_MANAGEMENT_CLASSES>      
    BRARCHIVEMGTCLASS   <YOUR_TSM_ARCHIVE_MANAGEMENT_CLASSES>           

5) Create password file with TDP for mySAP

shell> backint -f password -p /oracle/<SID>/102_64/dbs/init<SID>.utl

6) Check your configuration with TDP for mySAP

If you have done everything right, you will see all the available backups with the following command

shell> backfm -p /oracle/<SID>/102_64/dbs/init<SID>.utl

7) Restore your backup / logs, etc.

If you don't have a backup log you can restore this with the backfm

shell> brrestore -m full -b <backuplog.anf>

Some steps depend on your TSM client configuration, so maybe you will need some help by your backup colleagues.

If you need more information .. IBM publishes also a redbook:

http://www.redbooks.ibm.com/abstracts/sg245743.html

Regards

Stefan

[debasissahoo]

Hi Rahul,

Use this to restore the datafiles.

brrestore -b <backuplog.anf> -d util_file -r <Oracle_Home>\database\init<SID>.utl -m full -l E

Then restore the required redo logs,

brrestore -a <start_log#>-<end_log#> -c -d util_file -r <Oracle_Home>\database\init<SID>.utl

or,

use brtools to restore the database - easiest procedure. for this you have to make sure that there are these parameters in init<SID>.sap.

backup_dev_type=util_file or util_file_online

'util_par_file' must refer to the configuration file that contains parameters for the external backup utility. for ex, it will be having a value like "<oracle_home>\database\init<SID>.utl

Regards,

Debasis.

Edited by: Debasis Sahoo on Apr 13, 2009 1:44 PM

[Former Member]

Hi debasis & stefan ,

Well, with you guide lines i am planing to restore (all online +log) , but when restoring online backup do i have to stop sap & DB services or the system must be up & running. Please clerify this for me.

[Former Member]

Hello Rahul

sapdbservices must be down, restore will make db up when it finishes..

thanks

Bhudev

[debasissahoo]

Hi Rahul,

SAP should be down so that no user connection to oracle is there.

But Database is upto you. even if you don't bring it down. brtools will take care of it when needed. and after recovery it will also bring it up.

Good luck

Regards,

Debasis

[Former Member]

Hi debasis ,

Well, when im trying to perform this activity i jus tried to stop & satrt DB.

I have faced a neww erors & appreanlty my DB is not coming up, request to pls look in to this

ORACLE instance started.

Total System Global Area 1.6677E+10 bytes

Fixed Size 2113280 bytes

Variable Size 1.5821E+10 bytes

Database Buffers 838860800 bytes

Redo Buffers 14663680 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/oracle/RT1/sapdata1/system_1/system.data1'

Edited by: Rahul on Apr 13, 2009 8:33 PM

[Former Member]

Hi when im trying to brrestore the folloing is the output.

atabcddev:orart1 5> brrestore -m full -b beaimofb.anf

BR0401I BRRESTORE 7.00 (34)

BR0405I Start of file restore: reaiumhl.rsb 2009-04-13 21.42.17

BR0484I BRRESTORE log file: /oracle/RT1/sapbackup/reaiumhl.rsb

BR0428W File /oracle/RT1/sapdata1/cntrl/cntrlRT1.dbf will be overwritten

BR0280I BRRESTORE time stamp: 2009-04-13 21.42.17

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2009-04-13 21.42.37

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0456I Probably the database must be recovered due to restore from online backup

BR0280I BRRESTORE time stamp: 2009-04-13 21.42.37

BR0407I Restore of database: RT1

BR0408I BRRESTORE action ID: reaiumhl

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: FULL

BR0411I Database file for restore: /oracle/RT1/sapdata1/cntrl/cntrlRT1.dbf

BR0419I Files will be restored from backup: beaimofb.anf 2009-04-12 07.00.19

BR0416I 41 files found to restore, total size 179854.047 MB

BR0421I Restore device type: util_file

BR0280I BRRESTORE time stamp: 2009-04-13 21.42.37

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2009-04-13 21.43.02

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2009-04-13 21.43.02

BR0229I Calling backup utility with function 'restore'...

BR0278I Command output of '/usr/sap/RT1/SYS/exe/run/backint -u RT1 -f restore -i /oracle/RT1/sapbackup/.reaiumhl.lst -t file -p /oracle/RT1/102_64/dbs/initRT1.utl':

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager

- Version 5, Release 5, Modification 0.0 for AIX LF 64-bit -

Build: 316B compiled on Oct 23 2007

(c) Copyright IBM Corporation, 1996, 2007, All Rights Reserved.

BKI2027I: Using TSM-API version 5.5.1.0 (compiled with 5.3.0.0).

BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

BKI0005I: Start of program at: Mon Apr 13 21:43:02 IST 2009 .

BKI1214E: TSM Error:

Server not found in configuration file.

BKI1201E: There are no Tivoli Storage Manager-Servers available.

BKI1216E: There are no backup management classes available.

BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).

BKI0020I: End of program at: Mon Apr 13 21:43:05 IST 2009 .

BKI0021I: Elapsed time: 03 sec .

BKI0024I: Return code is: 2.

BR0280I BRRESTORE time stamp: 2009-04-13 21.43.05

BR0279E Return code from '/usr/sap/RT1/SYS/exe/run/backint -u RT1 -f restore -i /oracle/RT1/sapbackup/.reaiumhl.lst -t file -p /oracle/RT1/102_64/dbs/initRT1.utl': 2

BR0374E 0 of 41 files restored by backup utility

BR0280I BRRESTORE time stamp: 2009-04-13 21.43.05

BR0231E Backup utility call failed

BR0406I End of file restore: reaiumhl.rsb 2009-04-13 21.43.05

BR0280I BRRESTORE time stamp: 2009-04-13 21.43.05

BR0404I BRRESTORE terminated with errors

atabcddev:orart1 6>

[stefan_koehler]

Hello Rahul,

BKI1214E: TSM Error:
==> Server not found in configuration file.
BKI1201E: There are no Tivoli Storage Manager-Servers available.
BKI1216E: There are no backup management classes available.

The error is clear.. it seems like you have some problems with the TSM client configuration.

Please contact your TSM admin .. he can help you.

Regards

Stefan

[Former Member]

Hi Debasis & Stefan ,

I believe there is lot of useful information in this link. Well, i spoke to one TSM consultant & he advice me in the following way.

While restoring, the profile files need to properly selected.

.sap file should be initSID_tiv_onl.sap

.utl file should be initSID_tiv_utl.sap

And as per the below mentioned logs the utl file selected is initRT1.utl which should have been initRT1_tiv_onl.utl

Kindly do the appropriate changes in selection thru brtools and retry the restoration activity.

considering that i have used following command ,

brrestore -c -b <asdfgf.aff> -m full -p initSID_tiv_onl.sap

Restored successfully.

May be i still suspect TSM client is not configured properly. If it is,

may be this command would have worked.

brrestore -m full -b asdfgdfd.anf

thanx for quick support.