Topic: HA/VCS Cluster/Data guard >> Replication
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| dba_pistol |
Posted: Mar 25, 2003 12:37:00 AM |
Total Post: 1
Joined: Jan, 2003
|
I am a DBA here we are using Oracle8 for our payroll database, secondly we are using some small database in Approach also, here i have to import the new upgraded data each time there is a change in Oracle data, now i want to automate this process if there is aany change in Oracle data this change should reflect in Approach automatically , i have heared about replication in Oracle will it work for my problem, if you have any idea how to do this, i`ll be greatly helpful to you.
Thanking You
Regards
Dinesh Pratap Singh
|
|
|
nocturnal |
| Posted: Mar 25, 2003 11:50:00 AM | |
|
Total Post: 11
Joined: Jan, 2003
|
You can use different things here.
1.If you are not using another database for transactional purpose then standby database will be a good option for you. I know it can be opened in read only mode for queries etc in oracle 8i but not sure about 8. You can check Oracle 8 documentation to confirm this. I can send you the steps for setting up the standby database if you need it.
2.You can use any 3rd party clustering tools that can do this job for you. Like Veritas or shareplex (Quest) etc.
I have not used Oracle 8 replication so cannot tell you about that.
Thanks,
Puneet
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|