Database Mirroring

[ligang]

Scenario:

Oracle9i Standard Edition is installed on a Unix machine .

Plan to Replicate the Database on another server . The interval to do replication might be one day one time .

Suppose we have serveral option :

Option1:

1. Create Oracle9i SE database on a WindowsOS server .
2. Schedule Job to export dump file from oracle9i database on Unix Machine .
3. Copy and import it to Oracle9i on WIndowsOS

Option2:

1. Create Oracle9i SE Database on a exact same model Unix Server(but different machine ofcourse) . and the oracle home structure is same as the old one .
2. Database Cloning .

Option3:
1. Create Oracle9i SE database on a WindowsOS or Unix Server
2. Using Archivelog from old oracle9i database to do dummy recovery ?

Option4:
1. Snapshot ?


I am not so clear about Option3 and Option4 , Could any Xpert gives some tips ? Which option is easy and fast ? or you have some other ideas?

[Axr2]

3. Huh? What do you mean - "dummy recovery"?? Yes, you can recover on a different OS version or a patch level..but you can't apply archivelogs on a completely different OS.

4. Snapshots - RTM. They are fairly straight forward to create / maintain. If you're on 9i, OEM will do most of the stuff for you..point and click.

[stmontgo]

what fer? to make a copy of prod or to move it?

[ligang]

Originally posted by Axr2
3. Huh? What do you mean - "dummy recovery"?? Yes, you can recover on a different OS version or a patch level..but you can't apply archivelogs on a completely different OS.

4. Snapshots - RTM. They are fairly straight forward to create / maintain. If you're on 9i, OEM will do most of the stuff for you..point and click.

i also think snapshot is a quite good idea in this case , how do you think the performance ?
and those 2 database are same version but running on different os , any concern on that

[Axr2]

You can snapshot across different OS and database releases/versions even..

Performance - depends on activity, and refresh intervals.

[ligang]

How is the delete affect the snapshot ?

let's say , in the master database , the record is deleted , how it will affect the standby database .

[Axr2]

RTM! Snapshots to a standby database?! What are you saying!

If you mean target database, yes - obviously the row will be deleted from there as well!