on 05-16-2014 3:06 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.