missing indexes after system copy

[Former Member]

Hi All

we have around 70,000 missing indexes after the system copy

offline export from

source with sun solaris oracle

To 

Linux oracle

but these appeared after we Run  SGEN , which took 60 hours for a 200 Gb database.

and target system response is also slow , how to go ahead with this issue

we have checked export and import logs , none of the packages were missed

1 Why these missing indexes after SGEN , and why SGEN for 60 hours

2  when we check the Tables which appeared in Missing indexes ,from SE14  it says In Consistency with Data dictionary

3  and the other error , is  Index Missing in the database ,

4  but we cant create all these manually.

Regards

[Matt_Fraser]

Also, you might have a look at , but I think you will find that solving the mystery of the missing indexes is really the first thing to look at.

[Former Member]

Thank you Mr Fraser for the Response

we have performed offline export and import

Database being : oracle 11.2.0.3 and SAP Netweaver 7.31 ABAP only

This is the second Time we are facing the issue

Regards

[Former Member]

Info : I sent  the incident to SAP , but not responding since 10 days

how to escalate this on ?

Any other responses are welcome

Regards

[Former Member]

SAP suggests to perform the Import using R3load 721 ,

But we have done using 720.

But another system Running fine with export done from R3load 721 and Import from 720

Does this really is the cause of the issue

Kindly provide your responses on this

Regards

[Matt_Fraser]

Mellam,

As much as possible, you should try to match kernel versions and patch levels between your source and target systems.  If you can't or don't want to do that, then your target system should be on a higher patch than the source, not a lower one.  If you did your export using kernel 7.21, why not use kernel 7.21 for your import on the target?  It is very conceivable this could be a cause of the problem, and if SAP Customer Support suggests to try using a different R3load, I would go with their suggestion.

Regards,

Matt

[Former Member]

Hi Matt

Thanks for the response

After sap suggestion  , we have done only import again, with 721 R3load same as export.

but still the R3load.exe.log of import shows as done with 720 kernel.

import R3load.exe log       //bas/720_REL/src/R3ld/R3load/R3ldmain.c#

export R3load.exe log     //bas/721_REL/src/R3ld/R3load/R3ldmain.c#10 $ SAP

But when we compare  the sapinst_dev and AGR logs both from export and import

both are referring the same 721 R3load version ,

//bas/721_REL/src/R3ld/R3load/R3ldmain.c

still we have same missing indexes issue , after we did the import again.

Are we making any mistakes in export  , Any suggestions are welcome

hi all , kindly respond with your inputs , on this

Regards

[Matt_Fraser]

Can you give us a few more details about your environment?  What version of NetWeaver, for instance?  Also, were you trying the Oracle-specific method for homogeneous system copy, or one of the R3load import/export methods?  If you were using the Oracle-specific method, that might be your problem, since that is only supported for homogeneous copies, meaning that the hardware type and the operating system (as well as database) remain the same.

Regards,

Matt