> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Freitag, 28. Februar 2003 14:06 > To: Brunzema, Martin > Cc: [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Backup and Recovery > > > Hi Martin, > sorry, that i didn't answer to your last post, but my > LotusNotes and I had > different opinions about storing mails. > We are still hanging on our backup problem. > The solution you gave us works well until the 'install the > standby-db from > the databackup'. We can do it, Db goes online, including no > data. When we > want to run a recovery using 'restore a medium' and take the complete > backup from the original db, we can't restart the DB any more.
What error is returned ? Did you recover: init config, restore data, restore log => should be running ? Or did you: init config, activate, load_systab, restort data => error is Log and Data incompatible ? regards Uwe > I tried several other ways, Laurent also, but no result. > Do you have any other idea or what went wrong on our solution. > Do we have to take autolog on or off? > > We can also discuss in german, i had to promise Laurent, that i will > translate the result, if it works. > > Thanks for your help > > Flo > > > > > > Hi, > > > > > > this is no real "standby"-sloution, but a cheap version > > > of it using the log-backup to keep the standy-db up to > > > date. > > > > > > Here are the steps to perform it (i also didn't implement > > > this solution, but it should work) > > > > > > > > > master-db: start database > > > master-db: create a complete databackup > > > standby-db: install the standby-db from the databackup > > > > > > now you have two identical databases. If you change data > > > on the master-db, you want to do this changes also auto- > > > matically on the standby-db. You can perform this by > > > using the logsaves of the master-db, which contains all > > > the change-operations. You only have to do periodically > > > a save-log on the master-db and to restore them into > > > the standby-db. > > > > > > For a delay of one hour, you should establish save/restore > > > log every hour as follows: > > > > > > master-db: save-log into file.xxx (xxx is the automatically > > > appended number) > > > > > > copy file.xxx to the standby-db > > > > > > standby-db: restore log from file.xxx-1 > > > (do not restore file.xxx, but the predecessor in > > > order to maintain your delay of one hour) > > > > > > > > > In case of a crash of the master-db you can either > > > - restore the rest of the logsave > > > - additionally do a save log on the master in cold-mode > > > and restore it also > > > - or just doing a restart by using recover_ignore > > > > > > The delay will not be exactly one hour, but in the intervall > > > 1 to 2 hours. You can adjust it by changing interval of > > > your logsave. > > > > > > > > > HTH, Martin > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
