The problem you're running into is that the log files written to tape by
brbackup and brarchive are the log files being written to by brbackup
and brarchive. Backfm is the supplied method around this. Or - you can
back up the log files after the run.

 

I have my brbackup script set up to run brarchive after the backup, and
then run an incremental backup of /oracle/<sid>/sapbackup and
/oracle/<sid>/saparchive to capture the log files to yet another
management class. We restore these at the same time we're restoring the
SAP and Oracle executables at D/R.

 

Tom Kauffman

NIBCO, Inc

 

________________________________

From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Dksh Cssc
Sent: Wednesday, June 21, 2006 4:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP For SAP/R3 - Single File Restore Problem

 


The backfm works better for the restore. My team was having the same
problem as in the log file was halfway truncated and could NOT be used
to do a restore using BRRESTORE, backfm wipes our worries away. 

Just invoke backfm -p /xxx/init<SID>.utl as root user. 
Select the datafile / redo log which you want to restore given that the
filesystems and directories exist. It will work like magic!!! 


____________________________________________ 



"Hooft, Jeroen" <Jeroen.Hooft AT ATOSORIGIN DOT COM> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 

06/20/2006 06:37 PM 

Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To

ADSM-L AT VM.MARIST DOT EDU 

cc

 

Subject

Re: [ADSM-L] TDP For SAP/R3 - Single File Restore Problem

 

 

 





Try to restore the files with backint or backfm

"backfm =p initTPP.utl" will give you a kind of filemanager where you
can select individual files from the different backups.



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Pranav Parikh
Sent: dinsdag 20 juni 2006 12:28
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP For SAP/R3 - Single File Restore Problem


Hi,

I am facing problem in restoring single log file using brrrestore.  The
activity log shows that the require file archTPP.log  has been
successfully backed by brarchive using tdp for SAP/R3 V5.2. We are
unable to retrieve this file by brrestore command. It gives
following error while running "brrestore -n det_log -p initTPP.sap"

"option '-n' not supported for 'util_file' "

The very same -n options works fine with the direct tape backup on local
host.  The -d switch in conjunction to -n allows us to specify device
i.e
tape (only) and does not support util parameter file.

Some of the log files with extension .fnf, .cds and archTPP.log file on
the production server required for restoring the archive logs has
been lost due to corruption in oracle database.  This files are already
being backed up and are very much present in the backup set. but we are
unable to restore it either by using the switches available in brrestore
command line or brtools menu. This are vital files containing
information
of the archive logs backup prior to database crashes. If we can restore
any of the above mentioned individual files from the backup set we can
restore archive logs and recover database.

If any one of you know , do let me know how to retrieve single file.  We
have restored previous online backup and required archive logs to fully
recovered from data loss.

Regards
Pranav




CONFIDENTIALITY NOTICE:  This email and any attachments are for the 
exclusive and confidential use of the intended recipient.  If you are not
the intended recipient, please do not read, distribute or take action in 
reliance upon this message. If you have received this in error, please 
notify us immediately by return email and promptly delete this message 
and its attachments from your computer system. We do not waive  
attorney-client or work product privilege by the transmission of this
message.