Lawrie

I think this is because when you use SAPDBA, you will use the default
SAP-environment (i am no dba either).

We use the following method (R3 on AIX):
1. Copy the /oracle/SID/sapbackup/*a?f file from Production to Quality
(offline-backup is easier for such a restore). If you restore an online
backup you will also need the /oracle/SID/saparch/arch<SID>.log to get the
DB consistent.
2. Copy the initSID.sap, initSID.utl and initSID.bki files from Production
to Quality
        (located in /oracle/SID/*/dbs)
3. Create link "ln -s /oracle/SPP /oracle/SPQ" (might be redundant)
4. We restore from the command-line, so we can specify which initSID.sap
file to use:
        brrestore -m full -b ??????.aff -p init<SOURCE>.sap

Regards
Jeroen


-----Original Message-----
From: Lawrie Scott - Persetel Q Vector [mailto:LawrieS AT COMPAREXAFRICA.CO DOT 
ZA]

Sent: Friday, January 03, 2003 10:11
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SAP TDP Restore


Hi All
I am running TSM 5.1.5 on Windows 2000 and SAP/R3 using Oracle on a TRU64
Unix Cluster. I backup the SAP Databases using the SAP/R3 TDP for Tivoli on
Tru64 Unix. I wish to restore the SPP (Production Database) to the SPQ (QA
Database) location, overwriting the SPQ database with SPP's database.
However when I use the SAPDBA tools it does not allow me to point SPP
restores to a new location. The only way I can see roumd this is to stop SPP
rename it to SPQ and then Restore SPP, or modify the *.anf File from SPP's
backup with SPQ's location. I am not very knowledgeable on SAP/R3, so any
help will be greatly appreciated. This has been requested for test purposes
and will  not be the normal practice.

With the cluster consiting of 4 Compaq GS80 Servers these databases can be
running on any of the four machine, as the cluster software points to a
primary machine however if it fails the databases, applications etc. etc.
get failed over to one of the other 3 machines. So while there are 4 CPU's
the is not physical distinction as to where the databases and applications
are running. Therefore all 4 CPU's share the same directory structure on a
set of SAN disks aswell.


Kind Regards
LAWRIE SCOTT
For:
Persetel/Q Vector KZN
Company Registration Number: 1993/003683/07
Tel: +27 (0) 31 5609222
Fax: +27 (0) 31 5609495
Cell: +27 (0) 835568488
E-mail:  lawries AT comparexafrica.co DOT za