Restore worked - but I recived error messages

[Former Member]

Hey guys,

We are testing a new netbackup<->sap config, and our first point in time restore worked... However, I was a bit nervous

as I did recive one error (see below)... it seems to be complaining (returncode 5) about the backup utility call failing.

********************************************************************************

BR0374E 27 of 27 files restored by backup utility

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.54

BR0231E Backup utility call failed

BR0406I End of file restore: reemdgkd.rsb 2010-11-02 17.03.54

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.54

BR0404I BRRESTORE terminated with errors

===============================================================================

BR0292I Execution of BRRESTORE finished with return code 5

Either way, the restore was successful, but, we would love to know where this came from.... perhaps a bad .utl or .sap file entry...

Thanks everyone for any suggestions.

Richard

[Former Member]

Hey,

there is nothing after the log... the restore continues, I open the db, and life is good.. however, I don't ever feel all warm and fuzzy when there is still an error showing:

Below is more info: (could that be the issue "xxxx has already reported by backup utility"?

BR0280I BRRESTORE time stamp: 2010-11-02 16.53.50

#FILE..... /oracle/SM1/sapdata4/sr3usr_1/sr3usr.data1

#RESTORED. VXF1288722547

BR0372E File /oracle/SM1/sapdata4/sr3usr_1/sr3usr.data1 has been already reported by backup utility

[31703.00] 16:53:50 (77676.001) /oracle/SM1/sapdata1/undo_1/undo.data1

BR0280I BRRESTORE time stamp: 2010-11-02 17.02.49

#FILE..... /oracle/SM1/sapdata1/undo_1/undo.data1

#RESTORED. VXF1288722547

BR0372E File /oracle/SM1/sapdata1/undo_1/undo.data1 has been already reported by backup utility

[31703.00] 17:02:49 (77676.001) /oracle/SM1/sapdata1/sysaux_1/sysaux.data1

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.10

#FILE..... /oracle/SM1/sapdata1/sysaux_1/sysaux.data1

#RESTORED. VXF1288722547

BR0372E File /oracle/SM1/sapdata1/sysaux_1/sysaux.data1 has been already reported by backup utility

[31703.00] 17:03:10 (77676.001) /oracle/SM1/sapdata1/system_1/system.data1

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.52

#FILE..... /oracle/SM1/sapdata1/system_1/system.data1

#RESTORED. VXF1288722547

[31703.00] 17:03:53 (77676.001) INF - TAR EXITING WITH STATUS = 0

[31703.00] 17:03:53 (77676.001) INF - TAR RESTORED 27 OF 27 FILES SUCCESSFULLY

[31703.00] 17:03:53 (77676.001) INF - TAR KEPT 0 EXISTING FILES

[31703.00] 17:03:53 (77676.001) INF - TAR PARTIALLY RESTORED 0 FILES

[31703.00]

[31703.00] 17:03:54 (77676.001) Status of restore from image created Tue Nov 02 13:29:07 2010 = the requested operation was successfully completed

[31703.00]

********************************************************************************

BR0374E 27 of 27 files restored by backup utility

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.54

BR0231E Backup utility call failed

BR0406I End of file restore: reemdgkd.rsb 2010-11-02 17.03.54

BR0280I BRRESTORE time stamp: 2010-11-02 17.03.54

BR0404I BRRESTORE terminated with errors

[former_member204746]

Hi,

look in your log.

loook for BRxxxE errors, where xxxx is numeric value.

[Former Member]

Only thing it is showing is

BR0231E Backup utility call failed

but everything ran successfully....

this one is really causing me to scrach my head...

[Former Member]

This one is in the log too:

BR0372E File /oracle/SM1/sapdata1/sysaux_1/sysaux.data1 has been already reported by backup utility

it is the only thing I see that could be causing this message.

[Former Member]

>BR0372E File /oracle/SM1/sapdata1/sysaux_1/sysaux.data1 has been already reported by backup utility

Yes, there is some issue with your backup utility.

[Former Member]

Kind of weird, could you try to check the logs from the netbackup side? Is this your first restore? Do you have a sandbox system to do some more testing?

Cheers Michael

Edit: one more thing, you probably can see parts of the backup utility log in your brrestore log. In our configuration these parts start with square brackets

[28664.03] 18:01:25 INF - Processing /oracle/SID/102_64/dbs/initSID.utl_arch
[28664.03] 18:01:25 /oracle/SID/102_64/dbs/initSID.utl_arch

[Former Member]

Hi,

As pointed out by Michael can you please paste the logs from the netbackup.

/usr/openv/netbackup/logs/user_ops/dbext/logs

Did you try restoring a single file like only the controlfile and see whats the message its giving and paste the netbackup logs.Thanks.

[Former Member]

You should check the log file of the restore for the error. We can only see the very last lines here and not the real error. The log file can still be found in your /oracle/SID/sapbackup directory.

Cheers Michael