error in backup with verification in DB13

[Former Member]

Dear all,

I am taking backup through DB13. There is two options in that with verification & without verification. when i am taking backup without verification , it is completed succesfuly, but when i am taking backup with verification, there is some error.

I am giving the error lines....

-

---

BR0428W File /oracle/BWD/sapreorg/bwd.data1 will be overwritten

.

.

.

.

BR0278E Command output of '/oracle/BWD/920_64/bin/dbv file=/oracle/BWD/sapreorg/bwd.data1 blocksize=8192':

DBVERIFY: Release 9.2.0.6.0 - Production on Thu Nov 6 16:08:07 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBV-00102: File I/O error on FILE (/oracle/BWD/sapreorg/bwd.data1) during end read operation (-1)

BR0280I BRBACKUP time stamp: 2008-11-06 16.08.07

BR0279E Return code from '/oracle/BWD/920_64/bin/dbv file=/oracle/BWD/sapreorg/bwd.data1 blocksize=8192': 1

BR0397E Verification of backup of /oracle/BWD/sapreorg/bwd.data1 using DBVERIFY failed due to previous errors

BR0056I End of database backup: bdzeuhyo.ant 2008-11-06 16.08.07

BR0280I BRBACKUP time stamp: 2008-11-06 16.08.10

BR0054I BRBACKUP terminated with errors

-

---

Plz help me to solve this error.

Thanks & Regards,

Ankit Gupta

[Former Member · Accepted solution]

Dear All,

Tell me one thing.

when i am starting the backup i checked one thing.

oracle/BWD/sapreorg/bwd.data1 , this file is already there in sapreorg directory. That may be the error. Should it be there? It is also there on its original place.

Suggest me should i delete this file first before taking backup through dbverify? Is there any risk by this?

Thanks in advance.

Ankit

[Former Member · Accepted solution]

any idea?

[former_member204746 · Accepted solution]

you can delete this file from the sapreorg directory. then, try again.

[mohammed_anish · Accepted solution]

There is no problem if you delete oracle/BWD/sapreorg/bwd.data1 prior to backup. It will come again since you are using Verify option with BRBACKUP.

What happens when you use verify option is Once the backup phase is complete, all the saved files are restored from the volume (for example, tape) in sequence to the temperory directory (in this case /oracle/BWD/sapreorg), decompressed (when compress = yes was used), read by the check program, and compared with the originals. And the check program being used is dbverify (command dbv).

The problem may not be with oracle/BWD/sapreorg/bwd.data1, it may be with the original datafile bwd.data1. What you can do is,

Run dbv on all your datafiles and check for errors. (recommend to run dbv when database is offline)

If dbv returns an error, then fix that.

If there are no errors reported by dbv, then your database is perfect.

The reason why BRBACKUP gave the error in such a case, as i see it is, since you are doing an online backup, the datafile is first backed up to a backup media. Since verify is ON, the file is restored to the temperory folder. Some changes (even if minor) may occur in the datafile within this time frame and the comparison fails.

Another chance is if there is no enough space in sapreorg and the restored datafile is not complete.

If you get an error like "DBV-00102: File I/O error on FILE (/oracle/BWD/sapdata1/bwd.data1) during end read operation (-1)" on the original datafile, then, resizing of the datafile may help.Not sure though.

Please refer the link http://help.sap.com/saphelp_nw04/Helpdata/EN/0d/d30c774a0c11d182b80000e829fbfe/content.htm

[Former Member · Accepted solution]

Thanks, First, I have checked backup after delete the file from sapreorg directory. but error is same. After that i have run dbverify on offline db only for this datafile and i am getting the same error.

DBV-00102: File I/O error on FILE (/oracle/BWD/sapdata1/bwd.data1) during end read operation (-1)

Now i am trying to resize the datafile. Can u tell me the procedure? I am using brtools for that.

Ankit

[mohammed_anish · Accepted solution]

Check the current size of the datafile. You can find that from DB02 > current sizes > datafiles. Get the value in MB.

Run BRTOOLS. Select option "2 - Space Management"

> "5 - Alter datafile"

> "3 - Alter data file action (action)" (Note:Now type resize as the action at the prompt) And in the same screen give the datafile name /oracle/BWD/sapdata1/bwd.data1 by selecting option 5.

Now Continue.

> In the next screen it will prompt for new size. Give the size in MB. You may give a size just above the current size.

And continue the execution.

After the resize is done. Run dbv on the file again. Post the error (if any). If dbv is fine, check other datafiles.

Regards,

Anish

[Former Member · Accepted solution]

Dear Anish,

after resize, the error is same.

Plz suggest, now, what should i do ?

Ankit

[mohammed_anish · Accepted solution]

Hi Ankit,

Just to confirm...after you resized the file, did u shutdown the database..?

When I got the same error. I used sqlplus to resize the file by using the command. Alter database datafile <datafile name> resize <new size>. Then db was shut down. then dbv was run on the file. it was ok.

Regards,

Anish

[mohammed_anish · Accepted solution]

If dbv returned the IO error even when the DB is down (after resizing), it indicates an error on the hardware.

Regards,

Anish

[Former Member · Accepted solution]

yes. i shutdown the db. when i am running verify on datafile .

exact error is coming...

-----------------------------------------------------------------------------------------------------------------------------------------------
BR0395I Verifying /oracle/BWD/sapdata4/bwd_1/bwd.data1 using DBVERIFY...
BR0278E Command output of '/oracle/BWD/920_64/bin/dbv file=/oracle/BWD/sapdata4/bwd_1/bwd.data1 blocksize=8192':
DBVERIFY: Release 9.2.0.6.0 - Production on Tue Jan 13 13:29:16 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
DBV-00102: File I/O error on FILE (/oracle/BWD/sapdata4/bwd_1/bwd.data1) during end read operation (-1)
BR0280I BRBACKUP time stamp: 2009-01-13 13.29.16
BR0279E Return code from '/oracle/BWD/920_64/bin/dbv file=/oracle/BWD/sapdata4/bwd_1/bwd.data1 blocksize=8192': 1
BR0397E Verification of /oracle/BWD/sapdata4/bwd_1/bwd.data1 using DBVERIFY failed due to previous errors
BR0280I BRBACKUP time stamp: 2009-01-13 13.29.16
--------------------------------------------------------------------------------------------------------------------------------------------------

Now suggest, what i have to do for resolve the problem?

Ankit

[mohammed_anish · Accepted solution]

Hi Ankit,

I would like you to run this command from OS prompt in oracle user (orabwd) after shutting down the DB user to rule out it is not a problem with the way BRTool is doing it.

dbv file=/oracle/BWD/sapdata4/bwd_1/bwd.data1 logfile=data1ver.log blocksize=8192

Now if you get an error, let us find out if the disk is having block errors. Run the command on all the datafiles using the command i mentioned.

Note down all the files which is giving this error. Find out, on which physical disk the volume resides. See if it is the same disk. (I'm trying to see if the error is being reported to the files on one volume (sapdata4) or the disk on which sapdata4 resides)

Regards,

Anish

[Former Member · Accepted solution]

I run the same command through orabwd at os level but the same error is coming. error is coming for all the datafiles for server.

In my case, exact harddisk analyse on which these are residing is not possible, because i am using virtual array from hp as a data bank with raid configured.

Plz suggest.

Ankit

[mohammed_anish · Accepted solution]

If you are using unix, can u send df -h output to mohamedanish at gmail dot com.

Regards

Anish

[Former Member · Accepted solution]

Dear Anish,

It is Ok now. After again resizing the datafile, the verify is successfully. I was doing one mistake. I was resizing the datafile but not change its size. That was the problem. now, i increase its size & it is verified successfully.

Thank u very much.

Ankit

[former_member204746]

if you run a DBV while SAP and Oracle are online, you may get false positives. so, tun this offline only.

if it was run offline, then File /oracle/BWD/sapreorg/bwd.data1 might be corrupted, check previous post for an answer.

[Former Member]

do you have sufficient free space under /oracle/BWD/sapreorg, it should be larger than your datafile.

also check Note 589320 - Composite SAP note: DBV-00102

cheers,

-Sunil