Hello,
To find what file are backup with TDP/R3 use the command ( as ora<SID> ) :
ora<SID> # backfm -p /oracle/<SID>/dbs/init<SID>.utl
Seen after the DR procedure for the SAP with TDP/R3
* find the logfile of the brbackup in the directory
/oracle/<SID>/sapbackup or restore this file with backfm
In this directories, you must find some files like bdgghfsr.anf or
bdgghfsr.aff.
The .aff is for the offline backup and the .anf is for the online
backup.
After use the command (as ora<SID>):
ora<SID> # cd /oracle/<SID>/sapbackup
ora<SID> # brrestore -m full -b bdgghfsr.anf
To restore the last redolog used generated during the brbackup online:
ora<SID> # /oracle/<SID>/sapbackup
ora<SID> # grep SCN bdgghfsr.anf
Current log sequence 2989 SCN: 31357833
Current log sequence 2990 SCN: 31397586
ora<SID> # brrestore -a 2989
or
ora<SID> # grep SCN bdgghfsr.anf
Current log sequence 2989 SCN: 31357833
Current log sequence 2995 SCN: 31397586
ora<SID> # brrestore -a 2989-2994
Now you must apply all thredolog in ORACLE
ora<SID> # svrmgrl
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> recover database using backup controlfile until cancel;
The system suggests each redo log and recovers to the end of
it, press ENTER until it gets to the last redo log (in this
case 2990 or 2995), reply CANCEL when it asks when it asks for redo log
numy.
SVRMGR> alter database open resetlogs;
SVRMGR> exit
-----Original Message-----
From: Davidson, Becky [mailto:[EMAIL PROTECTED]]
Sent: vendredi 21 septembre 2001 17:41
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]
