We've done this many times.
What error are you getting? Is it from sapdba, brrestore, backint, or tsm?
To do the restore with sapdba you will need to have the
/oracle/<SID>/sapbackup/back<SID>.log file and the .anf or .aff file from
the backup in /oracle/<SID>/sapbackup. You can get these back with backint.
1) su - ora<sid>
2) cd /oracle/<SID>/sapbackup
3) backint -p /oracle/<SID>/dbs/init<SID>.utl -f restore
4) enter #NULL /oracle/<SID>/sapbackup/back<SID>.log
5) enter a CTRL-D
This should recover the most recent back<SID>.log. Tail the log and get the
filename for the last backup, then repeat the above procedure to recover it.
Alternatively, do a point-in-time restore for /oracle/<SID>/sapbackup --
this makes the assumption that you've run a backup of this directory after
your SAP database backup. Our online/offline backup scripts do this.
In general, our SAP recovery process runs like this (our production sid is
'prd' for some strange reason :-)
1) Recreate the volume groups and file systems (we run SAP on an AIX
platform -- and use 'restvg' to do this step -- 6 volume groups, about 850
GB of space)
2) restore archived copies of /oracle/PRD, /sapmnt/PRD, /oracle/PRD/saparch,
/usr/sap/PRD, and /usr/sap/trans. We run a weekly (Sunday afternoon) job to
archive these file systems with the same retention as our database backups.
We do two copies, to the same management classes as the off-line redo logs.
3) Do point-in-time restores for /oracle/PRD/sapbackup, /oracle/PRD/saparch,
and /usr/sap/PRD. These run *much* faster if the filesystems are archived
and restored as above.
4) Recover /oracle/PRD/sapbackup/backPRD.log and the relevant .anf/.aff file
as above (not trusting the point-in-time for these :-)
5) Recover in the same manner /oracle/PRD/saparch/archPRD.log
6) We quit using sapdba for the database restore -- run brrestore -b <the
.aff/.anf filename> -m full
7) recover the off-line redo logs while the main brrestore is running. The
log file names are available in the .anf/.aff file -- brrestore -a <first
log>-<last log>
8) after the database restore completes --
svrmgrl
connect internal
set autorecovery off
startup mount
recover database using backup controlfile until cancel
<press enter as prompted to confirm each redo log file - after the
last, type 'cancel'>
alter database open resetlogs
shutdown
startup
9) this is a real good time to do an off-line backup :-)
Hope this helps -
Tom Kauffman
NIBCO, Inc
> -----Original Message-----
> From: Davidson, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 10:41 AM
> To: [EMAIL PROTECTED]
> Subject: TDP for SAP R/3 Disaster Recovery
>
>
> Has anyone ever successfully did a disaster recovery drill
> using TDP for SAP
> R/3?
>
> We are currently trying and I have all of the TSM stuff up
> and when I got
> into SAPDBA and try to restore the SAP/oracle control files
> it fails with an
> error that it can't find the temporary file. I am sure we
> must be missing
> something but I don't know what and my pmr is moving slowly
> up to level 2
> but I need some sort of answer today. If we can't find an
> answer then we
> need to do a cold backup of our production environment Sunday
> night so that
> we can return the test system to the developers in a week.
> Any thoughts?
>
> Thanks
> Becky Davidson
> Data Manager/AIX Administrator
> EDS/Sara Lee Bakery Group
> voice: 314-259-7589
> fax: 314-877-8589
> email: [EMAIL PROTECTED]
>
