Error during Database Instance Export

[Former Member]

Hi All,

while running the Database Instance Export at the Source system for System AS Abap , i m having error at the Database Export Phase , with 46 of 47 completed, and last one job is failing ..

This is the error in the Log Browser, that points to export_monitor_java.log , Monitor_java.log, from there , this in turn is the log.

First few lines from the SAPSSEXC.log

(RTF) ########## WARNING ###########
	Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases


F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job completed
F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090707162613

F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090707162613

F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jan 24 2008 01:41:44
F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -e SAPSSEXC.cmd -datacodepage 4103 -l SAPSSEXC.log -stop_on_error

Last few lines from the SAPSSEXC.log

(RTF) ########## WARNING ###########
	Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DBC) Info: No commits during lob export
DbSl Trace: OCI-call 'OCILobRead' failed with rc=1578

DbSl Trace: ORA-1578 occurred when reading from a LOB

(EXP) ERROR: DbSlLobGetPiece failed
  rc = 99, table "DYNPSOURCE"
  (SQL error 1578)
  error message returned by DbSl:
ORA-01578: ORACLE data block corrupted (file # 25, block # 418028)
ORA-01110: data file 25: 'F:\ORACLE\QAS\SAPDATA1\SR3700_2\SR3700.DATA2'
(DB) INFO: disconnected from DB

F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
F:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090707204417

Thanks in advance.

[former_member603052]

Hi,

Some block got corrupted in the datafile 25 of your database. So you need to recover it first from the backup and then try to export.

Regards,

Kalyan

[Former Member]

Hi Kalyan,

can u help me doing this...as it was running properly and i havent restored it from any backup...

Thanks

[antonio_voce]

DID YOU SEE THE NOTE ?

AL THE STEP ARE DESCRIBED IN THE NOTE.

WE ALL UNDERSTAND THAT THERE ARE BLOCK CORRUPTED.......

[Former Member]

You will not get any errors until you access that particular (corrupted) block. I would suggest you to follow the notes mentioned above to correct and then export.

[former_member603052]

Hi,

As others also informed...follow that note mentioned to rectify the corrupted datafile and retry the export.

Kalyan

[Former Member]

Hi all,

Sorry to inform u guys, i do not have a backup available from where i can restore that datafile. and is there a possibility of resolving this , otherwise i will have to install it from database export i already have from PRD.

Thanks

[antonio_voce]

Hi ,

follow the instruction of OSS note Note 365481 - Block corruptions.

Antonio.

[Former Member]

DbSl Trace: ORA-1578 occurred when reading from a LOB

Looks like you have some data block corruption. [http://www.dbmotive.com/oracle_error_codes.php?errcode=1578]

[http://help.sap.com/saphelp_nw70/helpdata/EN/55/c491f37407e74781bc0ebd96befba7/content.htm]