How move part of database to another server?

Hello, List.

Our customer plans transfer his production environment (only) from pilot server to individual server. I know how add application server. But how move part of databases to new database server?
I think:
1. Create Add-server Installation plan. Add new Enterprise server and then add new database server. Select only one production environment;
2. Shutdown (take offline) production databases (Business data, central objects, control tables) on old (pilot) database server;
3. Complete Installation plan. I think it create all databases automatically, isn't it?
4. Move data from old server to new server (via R98403, it needs to create new database datasources);
5. Install new application server.

Is that plan correct?

Anton :

That plan seems to run fine, but the plan doesn't create JDE_PRODUCTION and
JDE_PD7333 databases automatically. You have to copy them via
backup and restore, or some DBMS tool. What is your DB platform?

Regards, Sebastian Sajaroff

----- Original Message -----
From: "AntonUsanov" <[email protected]>
To: <[email protected]>
Sent: Thursday, May 22, 2003 3:19 AM
Subject: How move part of database to another server?


from pilot server to individual server. I know how add application server.
But how move part of databases to new database server?I think:1. Create
Add-server Installation plan. Add new Enterprise server and then add new
database server. Select only one production environment;2. Shutdown (take
offline) production databases (Business data, central objects, control
tables) on old (pilot) database server;3. Complete Installation plan. I
think it create all databases automatically, isn't it?4. Move data from old
server to new server (via R98403, it needs to create new database
datasources);5. Install new application server.Is that plan correct?
1.8; JAS Win2000S + SP3 Websphere 3.5 +FP6;



ERP8 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
[email protected]
Canada

Anton,
you do not need to create any plan for adding a database server, but then I
guess it doesn't hurt.
Basically it's copying the data to the new location and repointing the
datasource(s).

The plan will not create your production database. You will have to create
the database structure (instance, tablespaces, logins, etc) manually using
the scripts that you will find in DS\b7333\database.
You will need one datasource pointing to your old Business Data and one to
your new Business Data to copy the data with R98403. If you have a large
amount of data you may want to use a direct copy using database tools. It
will be way faster. Make sure that after the copy your "Business Data -
Prod" points to your new location. Do not take the DB offline, otherwise
R98403 (or any copy) will not work. Make sure no users are using the
database while you copy.
You did not inform the database you are using. In case of Oracle change the
tnsnames.ora on all WS and the all servers. In case of ODBC change it on all
machines. Same for Control Tables and Central Objects.

You may want consider moving the common Datasources like system, dd7333,
obj7333 to your production database as well.

To create the new App server use the planner.

Good luck, Gerd

Re: RE: How move part of database to another server?

Has anyone moved an Oracle DB resident on a SAN to a different Unix server? Is it as simple as redirecting the SAN space to the new server and updating the TSNAMES.ORA? Are there any changes to be made to server mappings? Our DEV/CRP machine is slated to be replaced and the Admins want to move Oracle first and then go back and move the Apps (including JDE) so we will have a couple of months where the ES is a different machine than the DB server. Any pointers will be greatly appreciated.

Re: RE: How move part of database to another server?

Pretty much

You need to move the database over - and keep the SID the same name - then change the connection information in the TNSNames.ora

OneWorld won't really know the difference - and it will work fine.

Don't forget to do this on the enterprise server as well.

Re: RE: How move part of database to another server?

Thanks, Jon. I had come to this conclusion, but it gives a warm fuzzy to have that conclusion validated.