Hello, I want to setup a database HA like described in the SAP DB Ha howto by Yves trudeau (sapdb.2scale.net/moin.cgi/SapDbHaHowto), but I have a question about the database consistency in this setup.
During a recover, the redo task reads the redolist. For commits: it uses the generate redo log files to roll forward the database For rollbacks: if the rollback started before the savepoint -> the redo task evaluates the UNDO LOG FILE of the transaction, in order to set the transaction to the state before the savepoint. (http://www.mysql.com/documentation/maxdb/62/79bb3ee5bf7173e10000000a114084/content.htm) => My question: the main database crashed, making the data area unavailable. The backupdatabase uses the databackups and logbackups to be rebuild, but the "last night" databackups do not contain these latest undo log files (undo log files are stored in the data area) and the logbackups only contain the redo log entries. Does this mean the database in this case can not be reset to a consistent state? Or are the undo log files also regenerated by the redo task? Regards, Filip Sergeys -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
