Hi
I am doing a small project using 1 schema with about 33 tables. There wont be any DBA monitoring this database and i have disabled the archive log and the records are deleted and re-generated everyday. Hence the database size wont grow that much. But there may be a few records added to the reference tables.
I managed to use the 2 database replication with synchronous capture on 11g SE.
However, the question is if 1 of the database server is down maybe due to hard disk crash.
What is the fastest way to bring this server up again?
My idea is to install the operating system, install oracle, export the current schema which is running and then import into the new database and set up the synchronous stream again.
But how can i stop the sync capture process on the current running machine?
Why i use this synchronous capture is to ensure high availability of the database to the users. Also the 2 database are served by 1 virtual IP. hence at any time, the master database will be updated and the master database will be replicated to the "slave". Hence if the master goes down, the slave is already up and running with the virtual ip switch over.
please advise
regards
chris