ORA 01115 ERROR

[sivakumar_kilari3]

Hi

Can any body help me.

while i taking online backup i got the error 01115 bacause hard disk has bad sector. what should i do.

Thanks & Regards

siva

[former_member204746 · Accepted solution]

you forgot to tell us which Oracle version you are using and what is your OS.

if on Solaris, check SAP note 201302

please supply full error message, if you are lucky, this happened on an index tablespace and a tablespace reorg will clear the problem.

[sivakumar_kilari3 · Accepted solution]

Thanks for Quick reply

I am using ECC 6.0 ORACLE 10.2 WIN 2003

[Former Member]

most ORA-01115s are caused by hardware problems.Approaches differ according to whether you know the cause of the problem or not

Usually, there is no damage to the datafiles. Unless you can quickly fix the controller and restore access to the datafile

Find out which datafiles are under the bad controller.If you know for a fact that a disk has bad blocks or is malfunctioning, you should focus on moving the datafiles in it to a different disk, if at all possible. If not, you must consider the files lost and address the issue according to the tablespaces to which they belong

Vinod

[sivakumar_kilari3]

Thanks for quick reply

i am using ecc6 .0 with oracle OS win 2003

In case i want to change the hard disk what should i do. operating system also in the hard disk.

Thanks & Regards

siva

[former_member204746]

no need to change the hard disk, just run a SCANDISK, it will detect the bad block and will take it out of available blocks.

if the hard disk block is OK but you just got corruption at software level, then a reorg will also fix this issue (if this is an index tablespace).

so again, please supply full error message.

[sivakumar_kilari3]

Thank you

In case my management is decided to new installation what shoud i do.

[Former Member]

Hi Siva,

In case of new installation just make a full backup,make a new installation and a restore from tape.

But isn't necessary a new installation.

Regards.

[sivakumar_kilari3]

Thanks Albert

Can you the Recovery Steps

Thanks & Regards

siva

[sivakumar_kilari3]

Thanks Albert

Can you send the Recovery Steps.

siva

[Former Member]

Hi Siva,

the recovery steps depends on if you're using the tool you use to make the backups, but normally is a recover from tape into the new installation.

Normally, you don't need to do nothing more.

regards.

[former_member204746]

siva,

<b>FOR THE THIRD TIME</b>, p<u>lease supply the full error log</u> you got. without it, we cannot supply you with a valid recovery strategy.

[Former Member]

Siva,

I agree with Eric.

Is very complicated give a solution if we don't have the necessary data.

Please, send the data of the error.....

[sivakumar_kilari3]

Thanks Albert,

-

---

Detail log: bdvyxbrw.and

-

---

BR0051I BRBACKUP 7.00 (22)

BR0055I Start of database backup: bdvyxbrw.and 2007-08-20 22.27.16

BR0484I BRBACKUP log file: F:\oracle\VMP\sapbackup\bdvyxbrw.and

BR0477I Oracle pfile F:\oracle\VMP\102\database\initVMP.ora created from spfile F:\oracle\VMP\102\database\spfileVMP.ora

BR0280I BRBACKUP time stamp: 2007-08-20 22.27.21

BR0319I Control file copy created: F:\oracle\VMP\sapbackup\CNTRLVMP.DBF 17645568

BR0101I Parameters

Name Value

oracle_sid VMP

oracle_home F:\oracle\VMP\102

oracle_profile F:\oracle\VMP\102\database\initVMP.ora

sapdata_home F:\oracle\VMP

sap_profile F:\oracle\VMP\102\database\initVMP.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir G:\SAPPRDBACKUP\DATA

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info SAPServiceVMP BLRSAP001 Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info VMP 10.2.0.2.0 8192 2677 22622661 BLRSAP001 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003VMP0011T03623230840013NetWeaver_ORA

make_info NTintel OCI_10201_SHARE Jan 29 2007

command_line brbackup -u / -jid ALLOG20070820222700 -c force -t online -m all -p initVMP.sap -a -c force -p initVMP.sap -s

BR0116I ARCHIVE LOG LIST before backup for database instance VMP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination E:\oracle\VMP\oraarch\VMParch

Archive format ARC%S_%R.%T

Oldest online log sequence 2674

Next log sequence to archive 2677

Current log sequence 2677 SCN: 22622661

Database block size 8192 Thread: 1

Current system change number 22626938 ResetId: 625779267

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3_3\SR3.DATA3 2097160192 6 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3_4\SR3.DATA4 2097160192 7 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3_5\SR3.DATA5 2097160192 8 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3_10\SR3.DATA10 2097160192 13 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3_11\SR3.DATA11 2097160192 14 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3_12\SR3.DATA12 2097160192 15 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3_13\SR3.DATA13 2097160192 16 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3_14\SR3.DATA14 2097160192 17 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3_15\SR3.DATA15 2097160192 18 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3_16\SR3.DATA16 2097160192 19 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3_17\SR3.DATA17 2097160192 20 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3_18\SR3.DATA18 2097160192 21 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3_19\SR3.DATA19 2097160192 22 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3_20\SR3.DATA20 2097160192 23 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3700_1\SR3700.DATA1 3900710912 24 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3700_2\SR3700.DATA2 4089454592 25 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3700_3\SR3700.DATA3 3900710912 26 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3700_4\SR3700.DATA4 3753910272 27 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3700_5\SR3700.DATA5 3711967232 28 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3700_6\SR3700.DATA6 3774881792 29 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3700_7\SR3700.DATA7 3795853312 30 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA2\SR3700_8\SR3700.DATA8 3670024192 31 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3700_10\SR3700.DATA10 3795853312 33 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3700_11\SR3700.DATA11 3607109632 34 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3700_12\SR3700.DATA12 3628081152 35 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA3\SR3700_9\SR3700.DATA9 3753910272 32 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_13\SR3700.DATA13 3690995712 36 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_14\SR3700.DATA14 3837796352 37 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_15\SR3700.DATA15 3586138112 38 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_16\SR3700.DATA16 3523223552 39 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_17\SR3700.DATA17 3502252032 44 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_18\SR3700.DATA18 3628081152 45 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_19\SR3700.DATA19 3628081152 46 5 NOLINK FILE 5242880000 10485760 8192

PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3700_20\SR3700.DATA20 3628081152 47 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 41 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 42 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 43 5 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 5 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ F:\ORACLE\VMP\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 5 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ F:\ORACLE\VMP\SAPDATA3\UNDO_1\UNDO.DATA1 9164562432 2 5 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 272637952 3 5 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ F:\ORACLE\VMP\SAPDATA1\SYSAUX_2\SYSAUX.DATA2 272637952 49 5 NOLINK FILE 10485760000 5242880 8192

SYSTEM ONLINE* SYSTEM+ F:\ORACLE\VMP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 859840512 1 5 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ F:\ORACLE\VMP\SAPDATA1\SYSTEM_2\SYSTEM.DATA2 859840512 48 5 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

F:\ORACLE\VMP\ORIGLOGA\LOG_G11M1.DBF 52429312 1 5 INUSE NOLINK FILE

E:\ORACLE\VMP\MIRRLOGA\LOG_G11M2.DBF 52429312 1 4 INUSE NOLINK FILE

F:\ORACLE\VMP\ORIGLOGB\LOG_G12M1.DBF 52429312 2 5 INUSE NOLINK FILE

E:\ORACLE\VMP\MIRRLOGB\LOG_G12M2.DBF 52429312 2 4 INUSE NOLINK FILE

F:\ORACLE\VMP\ORIGLOGA\LOG_G13M1.DBF 52429312 3 5 INUSE NOLINK FILE

E:\ORACLE\VMP\MIRRLOGA\LOG_G13M2.DBF 52429312 3 4 INUSE NOLINK FILE

F:\ORACLE\VMP\ORIGLOGB\LOG_G14M1.DBF 52429312 4 5 INUSE NOLINK FILE

E:\ORACLE\VMP\MIRRLOGB\LOG_G14M2.DBF 52429312 4 4 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

F:\oracle\VMP\origlogA\cntrl\cntlrVMP.dbf 17645568 0 5 NOLINK FILE

F:\oracle\VMP\origlogB\cntrl\cntrlVMP.dbf 17645568 0 5 NOLINK FILE

F:\oracle\VMP\sapdata1\cntrl\cntrlVMP.dbf 17645568 0 5 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2007-08-20 22.27.23

BR0057I Backup of database: VMP

BR0058I BRBACKUP action ID: bdvyxbrw

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: F:\oracle\VMP\sapbackup\CNTRLVMP.DBF

BR0061I 50 files found for backup, total size 126897.211 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: G:\SAPPRDBACKUP\DATA\bdvyxbrw

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0370I Directory G:\SAPPRDBACKUP\DATA\bdvyxbrw created

BR0202I Saving init_ora

BR0203I to G:\SAPPRDBACKUP\DATA\VMP ...

BR0202I Saving F:\oracle\VMP\102\database\initVMP.sap

BR0203I to G:\SAPPRDBACKUP\DATA\VMP ...

BR0280I BRBACKUP time stamp: 2007-08-20 22.27.24

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2007-08-20 22.27.25

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA1 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3_1\SR3.DATA1

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA1 #1/1

BR0280I BRBACKUP time stamp: 2007-08-20 22.28.18

BR0063I 1 of 50 files processed - 2000.008 MB of 126897.211 MB done

BR0204I Percentage done: 1.58%, estimated end time: 23:25

BR0001I *_________________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3_2\SR3.DATA2

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA2 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3_2\SR3.DATA2

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA2 #1/2

BR0280I BRBACKUP time stamp: 2007-08-20 22.31.26

BR0063I 2 of 50 files processed - 4000.016 MB of 126897.211 MB done

BR0204I Percentage done: 3.15%, estimated end time: 0:35

BR0001I **________________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3_3\SR3.DATA3

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA3 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3_3\SR3.DATA3

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA3 #1/3

BR0280I BRBACKUP time stamp: 2007-08-20 22.32.41

BR0063I 3 of 50 files processed - 6000.023 MB of 126897.211 MB done

BR0204I Percentage done: 4.73%, estimated end time: 0:19

BR0001I **________________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3_4\SR3.DATA4

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA4 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3_4\SR3.DATA4

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA4 #1/4

BR0280I BRBACKUP time stamp: 2007-08-20 22.35.32

BR0063I 4 of 50 files processed - 8000.031 MB of 126897.211 MB done

BR0204I Percentage done: 6.30%, estimated end time: 0:36

BR0001I ***_______________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3_5\SR3.DATA5

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA5 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3_5\SR3.DATA5

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA5 #1/5

BR0280I BRBACKUP time stamp: 2007-08-20 22.38.07

BR0063I 5 of 50 files processed - 10000.039 MB of 126897.211 MB done

BR0204I Percentage done: 7.88%, estimated end time: 0:43

BR0001I ****______________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA2\SR3_10\SR3.DATA10

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA10 ...

#FILE..... F:\ORACLE\VMP\SAPDATA2\SR3_10\SR3.DATA10

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA10 #1/6

BR0280I BRBACKUP time stamp: 2007-08-20 22.40.51

BR0063I 6 of 50 files processed - 12000.047 MB of 126897.211 MB done

BR0204I Percentage done: 9.46%, estimated end time: 0:49

BR0001I *****_____________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA2\SR3_6\SR3.DATA6

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA6 ...

#FILE..... F:\ORACLE\VMP\SAPDATA2\SR3_6\SR3.DATA6

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA6 #1/7

BR0280I BRBACKUP time stamp: 2007-08-20 22.43.26

BR0063I 7 of 50 files processed - 14000.055 MB of 126897.211 MB done

BR0204I Percentage done: 11.03%, estimated end time: 0:52

BR0001I ******____________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA2\SR3_7\SR3.DATA7

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA7 ...

#FILE..... F:\ORACLE\VMP\SAPDATA2\SR3_7\SR3.DATA7

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA7 #1/8

BR0280I BRBACKUP time stamp: 2007-08-20 22.45.30

BR0063I 8 of 50 files processed - 16000.063 MB of 126897.211 MB done

BR0204I Percentage done: 12.61%, estimated end time: 0:51

BR0001I ******____________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA2\SR3_8\SR3.DATA8

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA8 ...

#FILE..... F:\ORACLE\VMP\SAPDATA2\SR3_8\SR3.DATA8

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA8 #1/9

BR0280I BRBACKUP time stamp: 2007-08-20 22.47.31

BR0063I 9 of 50 files processed - 18000.070 MB of 126897.211 MB done

BR0204I Percentage done: 14.18%, estimated end time: 0:49

BR0001I *******___________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA2\SR3_9\SR3.DATA9

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA9 ...

#FILE..... F:\ORACLE\VMP\SAPDATA2\SR3_9\SR3.DATA9

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA9 #1/10

BR0280I BRBACKUP time stamp: 2007-08-20 22.49.46

BR0063I 10 of 50 files processed - 20000.078 MB of 126897.211 MB done

BR0204I Percentage done: 15.76%, estimated end time: 0:49

BR0001I ********__________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA3\SR3_11\SR3.DATA11

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA11 ...

#FILE..... F:\ORACLE\VMP\SAPDATA3\SR3_11\SR3.DATA11

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA11 #1/11

BR0280I BRBACKUP time stamp: 2007-08-20 22.52.03

BR0063I 11 of 50 files processed - 22000.086 MB of 126897.211 MB done

BR0204I Percentage done: 17.34%, estimated end time: 0:49

BR0001I *********_________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA3\SR3_12\SR3.DATA12

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA12 ...

#FILE..... F:\ORACLE\VMP\SAPDATA3\SR3_12\SR3.DATA12

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA12 #1/12

BR0280I BRBACKUP time stamp: 2007-08-20 22.53.41

BR0063I 12 of 50 files processed - 24000.094 MB of 126897.211 MB done

BR0204I Percentage done: 18.91%, estimated end time: 0:46

BR0001I *********_________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA3\SR3_13\SR3.DATA13

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA13 ...

#FILE..... F:\ORACLE\VMP\SAPDATA3\SR3_13\SR3.DATA13

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA13 #1/13

BR0280I BRBACKUP time stamp: 2007-08-20 22.55.55

BR0063I 13 of 50 files processed - 26000.102 MB of 126897.211 MB done

BR0204I Percentage done: 20.49%, estimated end time: 0:46

BR0001I **********________________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA3\SR3_14\SR3.DATA14

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA14 ...

#FILE..... F:\ORACLE\VMP\SAPDATA3\SR3_14\SR3.DATA14

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA14 #1/14

BR0280I BRBACKUP time stamp: 2007-08-20 22.57.51

BR0063I 14 of 50 files processed - 28000.109 MB of 126897.211 MB done

BR0204I Percentage done: 22.07%, estimated end time: 0:45

BR0001I ***********_______________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA3\SR3_15\SR3.DATA15

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA15 ...

#FILE..... F:\ORACLE\VMP\SAPDATA3\SR3_15\SR3.DATA15

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA15 #1/15

BR0280I BRBACKUP time stamp: 2007-08-20 23.00.14

BR0063I 15 of 50 files processed - 30000.117 MB of 126897.211 MB done

BR0204I Percentage done: 23.64%, estimated end time: 0:46

BR0001I ************______________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA4\SR3_16\SR3.DATA16

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA16 ...

#FILE..... F:\ORACLE\VMP\SAPDATA4\SR3_16\SR3.DATA16

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA16 #1/16

BR0280I BRBACKUP time stamp: 2007-08-20 23.03.06

BR0063I 16 of 50 files processed - 32000.125 MB of 126897.211 MB done

BR0204I Percentage done: 25.22%, estimated end time: 0:49

BR0001I *************_____________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA4\SR3_17\SR3.DATA17

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA17 ...

#FILE..... F:\ORACLE\VMP\SAPDATA4\SR3_17\SR3.DATA17

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA17 #1/17

BR0280I BRBACKUP time stamp: 2007-08-20 23.04.57

BR0063I 17 of 50 files processed - 34000.133 MB of 126897.211 MB done

BR0204I Percentage done: 26.79%, estimated end time: 0:47

BR0001I *************_____________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA4\SR3_18\SR3.DATA18

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA18 ...

#FILE..... F:\ORACLE\VMP\SAPDATA4\SR3_18\SR3.DATA18

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA18 #1/18

BR0280I BRBACKUP time stamp: 2007-08-20 23.07.08

BR0063I 18 of 50 files processed - 36000.141 MB of 126897.211 MB done

BR0204I Percentage done: 28.37%, estimated end time: 0:47

BR0001I **************____________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA4\SR3_19\SR3.DATA19

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA19 ...

#FILE..... F:\ORACLE\VMP\SAPDATA4\SR3_19\SR3.DATA19

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA19 #1/19

BR0280I BRBACKUP time stamp: 2007-08-20 23.09.22

BR0063I 19 of 50 files processed - 38000.148 MB of 126897.211 MB done

BR0204I Percentage done: 29.95%, estimated end time: 0:47

BR0001I ***************___________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA4\SR3_20\SR3.DATA20

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA20 ...

#FILE..... F:\ORACLE\VMP\SAPDATA4\SR3_20\SR3.DATA20

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3.DATA20 #1/20

BR0280I BRBACKUP time stamp: 2007-08-20 23.11.47

BR0063I 20 of 50 files processed - 40000.156 MB of 126897.211 MB done

BR0204I Percentage done: 31.52%, estimated end time: 0:48

BR0001I ****************__________________________________

BR0280I BRBACKUP time stamp: 2007-08-20 23.11.49

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-20 23.11.50

BR0315I 'Alter tablespace PSAPSR3700 begin backup' successful

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3700_1\SR3700.DATA1

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA1 ...

#FILE..... F:\ORACLE\VMP\SAPDATA1\SR3700_1\SR3700.DATA1

#SAVED.... G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA1 #1/21

BR0280I BRBACKUP time stamp: 2007-08-20 23.16.29

BR0063I 21 of 50 files processed - 43720.164 MB of 126897.211 MB done

BR0204I Percentage done: 34.45%, estimated end time: 0:49

BR0001I *****************_________________________________

BR0202I Saving F:\ORACLE\VMP\SAPDATA1\SR3700_2\SR3700.DATA2

BR0203I to G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA2 ...

BR0278E Command output of 'copy F:\ORACLE\VMP\SAPDATA1\SR3700_2\SR3700.DATA2 G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA2':

Data error (cyclic redundancy check).

0 file(s) copied.

BR0280I BRBACKUP time stamp: 2007-08-20 23.20.11

BR0279E Return code from 'copy F:\ORACLE\VMP\SAPDATA1\SR3700_2\SR3700.DATA2 G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA2': 1

BR0222E Copying F:\ORACLE\VMP\SAPDATA1\SR3700_2\SR3700.DATA2 to/from G:\SAPPRDBACKUP\DATA\bdvyxbrw\SR3700.DATA2 failed due to previous errors

BR0280I BRBACKUP time stamp: 2007-08-20 23.20.19

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0056I End of database backup: bdvyxbrw.and 2007-08-20 23.20.11

BR0280I BRBACKUP time stamp: 2007-08-20 23.20.19

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2007-08-20 23.20.19

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20070820222700 -d disk -c force -p initVMP.sap -s'

BR0280I BRBACKUP time stamp: 2007-08-20 23.21.12

BR0292I Execution of BRARCHIVE finished with return code 0

[Former Member]

Siva,

can you revise the Note 540543 - Composite SAP note: dd errors when calling in BR tools.

This note explain some problems on Windows 2003 (problems with dd, block size, etc...).

How large is the file that crash in the backup ?? How many Mb ??

[sivakumar_kilari3]

Albert i am using External hard disk

[Former Member]

Hi Siva,

Looking the note I see some tests you can do:

• Does the error also occur with another tape?

• Does the error also occur with another drive?

• Does the error also occur with another backup tool (for example, ntbackup on NT)?

• Does the error also occur when calling dd directly (instead of via the BR tools)?

Can you make this tests and tell us your feedback ??

Regards

[former_member204746]

rename G:\SAPPRDBACKUP to another name, then re-create G:\SAPPRDBACKUP

and try again to see if this helps.

[Former Member]

Hi Siva,

Have you tried some step to fix the problem ?

Regards

[Former Member]

Hi Siva,

Have you tried to make a backup on tape ?

Regards

[Former Member]

Hi,

Perform full backup on another disk. from bad sector hard sisk you can't perform the restore database.

Regards

Ganesh