on 09-12-2015 1:45 AM
Hello Experts,
we are planning of exporting a big database to new hardware & OS while DB remains the same.
I have few questioins around uptime & downtime activities.
We will be doing table splitting + parallel exp/imp.
Are the steps DB EXPORT Preparation & Table splitting can be considered as UPTIME activities?
i.e can users use the system while above two steps are running through SAPINST. If yes to what extent?
Only for Transactional purposes??
OR these activities can be considered DOWNTIME activities i.e SAP is unavailble for users? If this the case then my overall downtime wil increase during production cutover.
What are the best practice recommendations?
Thoughts are highly appreciated.
Best Regards
Sachin Bhatt
Thanks for your input guys.
we did some POCs & found that DB Export preparation & Table splitting are uptime activities.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What's your Database? If your database is SQL Server. You can move to new hw/os using system copy detach/attach database
Kind regards,
Piyawat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sachin
1. Could you check this SCN thread about parallel process (Export in source and import in target system)
2. Refer the system copy guide from following SAP link.
BR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sachin,
DB export preparation is an UPTIME activity. As far as table splitting, identifying the tables and Sizes is uptime activity but the splitting will be done at the time of export which is a downtime activity.
As far as the preparation is considered, it can be done during uptime without any issues as it will not be copying any data from the source system dring preparation.
Please check the Master guide/Installation guide for more details.
Hope this helps!
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.