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:[EMAIL PROTECTED] On Behalf Of Dksh Cssc Sent: Wednesday, June 21, 2006 4:03 AM To: [email protected] 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" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 06/20/2006 06:37 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] 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:[EMAIL PROTECTED] Behalf Of Pranav Parikh Sent: dinsdag 20 juni 2006 12:28 To: [email protected] 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.
