Hello Martin, >Does recover_start allows to recover version files from autosaved logs? or >is it just for interactive log files?
Use the <nnn> option of recover_start. There is no difference between autosaved log backups and interactive log backups into files, all are versioned. >I need a suggestion for a procedure to test a recovery scenario where: >1) data and log volumes has been destroyed >2) A full backup 1 day old exists >3) Some autosave version files exists, some are newer than the last full >data backup Reinstall the database for restore (e.g. recycle the createdemodb script up to the line util_execute INIT CONFIG). Recover the data backup. Restore the matching log backups. You can either have a look into dbm.knl to decide which log backups are matching your data backup or you can try with recover_start until it answers with -8020. After the first -8020 (first matching log backup) restore all following log backups with recover_replace. After the last log backup use recover_ignore to finfish the restore of log backups. >b) What should I do in terms of inserting data, firing backups, etc in order >to be able to test this scenario? Sorry can not answer that one, as it spoils all your fun and does not create any faith in SAP DB's restore abilities. Best Regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Martin Cordova S. [mailto:[EMAIL PROTECTED] Sent: Freitag, 13. Juni 2003 00:37 To: [EMAIL PROTECTED] Subject: Questions about recover_start Does recover_start allows to recover version files from autosaved logs? or is it just for interactive log files? I need a suggestion for a procedure to test a recovery scenario where: 1) data and log volumes has been destroyed 2) A full backup 1 day old exists 3) Some autosave version files exists, some are newer than the last full data backup I have many doubts about how to implement this test, and I am concerned because I would like to have some domain over a contingency plan for my SAPDB. a) What should be the recover script? b) What should I do in terms of inserting data, firing backups, etc in order to be able to test this scenario? I strongly feel that a how-to like this would benefit a vast majority of SAPDB users who may feel as lost as me in the backup/restore matters of SAPDB. Thank you very much, Martin Cordova http://java.megaserv.com ps: I already read the document "backup and recovery with dbmcli". BTW, the script in page 8 does not work! _______________________________________________ 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
