Replication of Oracle Database in Windows 2000 Enviorment [message #75513] |
Tue, 29 June 2004 09:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Kuntal
Messages: 9 Registered: February 2004
|
Junior Member |
|
|
Hii,
I have a Oracle 8i database(SID : DATABASE) in windows 2000 platform. As a failsafe measure i want to create a similar enviroment where another 8i database(DATABASE2) where DATABASE1 will be replicated, in a windows 2000 platform. I need to know how can this be done. i can go about the replication first time by a full export/import. can i use dbms_job to carry out this operation at frequent interval. I am new to such replication issues. Any help in this matter will be highly gratefull.
Thanks and Regards
Kuntal
|
|
|
Re: Replication of Oracle Database in Windows 2000 Enviorment [message #75517 is a reply to message #75513] |
Mon, 05 July 2004 03:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Oskar
Messages: 26 Registered: May 2002
|
Junior Member |
|
|
If you want to replicate the complete database I'd use a different approach.
You can try to copy every datafile to the destination machine from a cold/hot backup and then start the cloned database there.
If you want a standby database (to be used in case of disaster in your production machine) you can do that too.
Metalink provides notes/scripts on how to do every option mentioned above.
|
|
|