Straight copy of JDEPROD => JDETEST.. Acceptable?

Hello,

So we need to test the 1099 Tax download on our 8.12 JDE.

Now..

1) our TEST server hardware crashed. It'll take a while to rebuild one..

2) Since we had space on our PRODUCTION Linux Server, we've taken a full RMAN (Recovery Manager) backup of the PROD database, and created a new TEST instance from that.

So the only difference is the connection string.. As anyone been in a similar situation? What should be the next steps, probably harness a Web client first? Your pointers welcome..

Thank you!

Not sure if I understood your post completely, but if you are wanting to do a "data" copy from PD to DV, you can certainly just copy PRODDTA and PRODCTL to TESTDTA and TESTCTL, if you are using default names. If you completely lost your dev box including CODVxxx and DVxxxx databases/libraries, then it is not just a simple copy and rename of the databases.

usually a copy from PROD to a TEST data is a change of the schema - not necessarily a full change of the database connection string. The reason is that you want to 100% isolate test data from production data - and also because you might not have twice the hardware.

Therefore, to answer your question - YES, it IS possible to take an RMAN backup, restore the entire database to another database server/instance - and create a new connection string to that database server/instance. HOWEVER, you will need to do have copies of a BUNCH of logic-running machines :

Fat Clients (development)
Deployment Server (perhaps - may not be necessary)
HTML Servers
Application Servers
BSSV Servers
etc etc

A better way is to take the PRODDTA/PRODCTL schemas, and copy them into CRPDTA/CRPCTL or TESTDTA/TESTCTL - and then access the data using PY or DV depending on which schema you copied into. You will still have to implement environment-specific logic instances (Fat Clients, HTML Server etc) - but because they are using a different ENVIRONMENT, they can share the same hardware if you wish.

Theres a little more detail that needs to be fleshed out in what I just said - but any good CNC should be able to assist you with a data-copy.

Please, please, please don't copy central objects. You'll trash your code integrity....and likely delete a bunch of development without realizing it until too late !