Hi Shirley, We have done a similar kind of setup in our shop. DB2 6.1 EE on AIX .
The standby AIX server is installed with DB2 6.1 and a full backup image taken from the production DB is restored on the standby server. We have done the restore with rollforward and hence the standby DB is always in recovery mode ( roll forward pending ) . Production system has logretain enabled. Archived logs being generated are ftpd to the standby server ( in another city via dedicated link ) . The logs that are coming into the standby server are being applied ( roll forward to end of logs ) continuosly. This activity involved writing couple of simple ksh/unix scripts for moving archivelogs, ftp, and applying at standby. In the scenario of failure on production system, we need to make sure that all the latest archivelogs are available on the standby server and do the rollforward to end of logs and complete. With this the standby DB comes to online and ready for operations. If later the production server comes online after failure you will have to take a full backup of standby and restore on production ( or leave production as new standby server ) . Some notes that you need to consider with this solution are : - End users switcing to new server instead of production ( could be done with simple scripts db2 catalog ) - The standby database would only be having the last archived log ftpd to it ( orphan logs at production or in transit are lost ) . We have been successful in this implementation and even have tested a disaster scenario switching to standby. Let me know if you need further info. Rgds, Ravi. --- Shirley Fan <[EMAIL PROTECTED]> wrote: > Hi all, > I have two Win2k servers, each with UDB V7.2 > Enterprise installed. > One will be used as a backup server. I like to set > up a standby database > to be a replica of a primary database and is > maintained by applying archived > redo logs from the primary database to the standby > in order to keep them synchronized. > When the system crashes, I need to failover to the > standby database. > > Since I haven't done this before, I would appreciate > if someone > could give me some guidance on how I could approach > this situation. > > Can I use the standard UDB replication tools to set > up this standby database > or do I need any other products to achieve this > failover feature? > Because if the system crashes on the primary server, > it is impossible to > apply the archived redo log to the target server. > > > What is the different between standby database and > database replication ? > > If I want to replicate the whole database from a > source to target server, > > Is there a way to replicate the whole database > rather than table by table. > It is quite troublesome to setup the replication by > table name if I would like > to replicate the whole database > > > > > > > > > > Creating a Standby Database sounds like what you're > wanting to do. > A standby database is basically a replica of a > primary database and > is maintained by applying archived redo logs from > the primary database > to the standby database in order to keep them > synchronized. > If the primary database is lost (system crash, data > corruption, etc), > you can failover to the standby database. In this > case, the standby > database now becomes the primary database. > > The only issue I see is that you said you want to be > able to switch > back to Server 1 after it has been recovered. The > way a standby database > works is that once it becomes the primary database, > it stays the primary database. > Basically, once you get your crashed server back up, > you'd then make it > the standby database and typically wouldn't attempt > to "switch back." > > > > ------------------------------------------------------------------------This > email is intended for the named recipient only. The > informationcontained in this message may be > confidential, or commerciallysensitive. If you are > not the intended recipient you must not reproduceor > distribute any part of the email, disclose its > contents to any otherparty, or take any action in > reliance on it. If you have received thisemail in > error, please contact the sender immediately. > Please deletethis message from your > computer.------------------------------------------------------------------------ > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
