Cloning [message #64225] |
Wed, 05 January 2005 00:53 |
Rohit Tyagi
Messages: 1 Registered: January 2005
|
Junior Member |
|
|
Hi, I am a bit new to Oracle stuff but RDBMS concepts r clear... I have 1 live server and a test server both r running independent Oracle 8 on Sun solaris, now i would like to replicate the db of Live Server to db at Test Server, and this should happen may be after every 2 hours or so .... so for this sort of requirement i need to study or concentrate on what part of oracle.
If somebody can just point the steps that i will probably require or provide a link, i will be really thankfull.
May be once i get a initiall hint, rest i will read the doc.
Thanks & Regards
Rohit
|
|
|
Re: Cloning [message #64228 is a reply to message #64225] |
Wed, 05 January 2005 02:58 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Ideally, you are looking into oracle replication, where changes made in one master site are automatically propogated to other sites. Look into SNAPSHOT REPLICATION.
The rest would be crude methods ( which may work if the data is small).
1. blow away test data, export master data, import into testDb, repeat every two hours
2. Create staging table(s). Use Triggers to capture all the changes done in masterDB and insert them to stagingarea. Load this stagingArea to your test db every two hours.
3. Use RMAN to backup the MasterDB.
Use RMAN duplication to clone MasterDB to TestDB.
|
|
|