This sounds like a permission problem. Brrestore creates this file and
backint gets the list of files to restore from it. Make sure that
/oracle/PR1/817_64/sapbackup is writeable by ora<sid> and/or group dba, and
that /sapmnt/<SID>/exe/backint (and backagent) are group dba, owner root,
with permissions 4775 (suid root).
Does the file get created? If so, the problem is in the permissions on
backint; if not, the problem is somewhere in the ownership or permissions on
the directories in the path.
Is this really the proper path? I've not seen a subdirectory under the sid
before, I would have expected the path to be /oracle/PR1/sapbackup.
Tom Kauffman
NIBCO, Inc
> -----Original Message-----
> From: Davidson, Becky [mailto:Becky.Davidson AT EGR DOT COM]
> Sent: Friday, September 21, 2001 1:47 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP for SAP R/3 Disaster Recovery
>
>
> Our error is BKI1210E: Input file not found or not accessible:
> '/oracle/PR1/817_64/sapbackup/.rdggsfzq.lst" which makes
> sense because that
> is a temporary file. We get the same error not matter what
> we do. How do I
> get around this?
>
> -----Original Message-----
> From: Kauffman, Tom [mailto:KauffmanT AT NIBCO DOT COM]
> Sent: Friday, September 21, 2001 11:51 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP for SAP R/3 Disaster Recovery
>
>
> 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:Becky.Davidson AT EGR DOT COM]
> > Sent: Friday, September 21, 2001 10:41 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > 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: becky.davidson AT egr DOT com
> >
>
|
