Need to mirror a DB on two machines, here is my idea - please comment

Here is my idea, please advise if there is even a chance of thie working.

Setup:
- I have two servers, say A & B (server and laptop).

• They both have the same version of Oracle installed in the same physical directory.
• They both have a database named DEMO, located in the same directory on the same drive letter and all physical datafiles have the same names.

Problem:
- Need to *quickly* move ALL DEMO data from A to B (we load up the
DEMO instance with user specific data to take on-site via the laptop. The data will need to be extensivly manipulated so loading into the laptop directly is not desireable - not the mention the performance difference between the server and the laptop). Also the needs to be a repeatable process.

Idea:
- Shutdown both DB's

• Copy the raw datafiles from A to B via the network replacing what was there.
• Startup both DB's

Result:
- DB A should not be adversly effected as all I did what stop and
start.
- DB B when started will be an exact mirror image of A that can be
taken onsite for a DEMO.
- All Exports/Imports have been eliminated.

• A simple drag and drop does everything I need!

Does this sound right?

Thanks for any advise!

Wayne. Received on Fri Nov 02 2001 - 05:58:01 CST