Re: Database Replication - Does it work?

ken, > I've tried to point LTAPEDEV to a real file and periodically backup logical > logs 'ontape -a' on the secondary server when it has changed to standard, but > when I try to restore the primary it hangs in fast recovery and the > secondary panics - again requiring careful manual procedures to recover. > (the idea with this approach is to write the logfiles to a file, then remove the file to > make the online believe that the data has been backed up and therefore will prompt > for a tape when I try to restart the primary). > > Has anyone been able to sucessfully automate DR - has anyone been able to use DR > sucessully any way? Informix Support keeps telling me that it works and that I must > be doing something wrong. i have no experience with DR, but when online is in fast recovery mode it is expecting to roll forward the logical logs. if there are no logical logs, then it will just stay in recovery mode. i ran into something similar when i tried to back up my critical dbsapces with on-archive, but didn't have a logical log backup to apply. it also sat in fast recovery mode endlessly. then, if i shut down and tried to re-initialize, it aborted as it couldn't find the log file. our circumstances are different, but the underlying problem might be somewhat the same. it seems that you must have the logical logs backed up and available for the recovery process, as this is what online wants. i'm sure support would have told you this if this was the case, but i hope it helps somewhat. mickm