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

Wayne wrote:
>
> 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.

Depending on the complexity, you could use snapshot logs to record just the deltas on each table and apply them.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."