Hello Victor, >First I have to find the first log file which I need >to recover and execute a recover_start LOG<N>. For the following >versions execute a recover_replace LOG <N+1>, LOG<N+2>, ....
In principle yes, but take care of the syntax of recover_start and recover_replace. >If I don't have any log file to recover, execute a recover_ignore. You need no log, if db_restartinfo says that the database is restartable. In this case just restart the database. Recover_ignore is just used, after a recover_start and if you have recovered your last available log backup and the database is still asking for another one. >I want to automate my log mechanism. >This way, my scripts must add a medium each time a complete/incremental >backup is taken. Not for the log backups. You must use another medium for the data backup, if you backup into files and want to keep multiple generations of data backups (what is recommended anyway). >For the AutoLog, I can handle multiple files on the same medium. Correct? Yes >1) Is there any formula to get the correct size of the Log Segment (defined >with LOG_SEGMENT_SIZE), >or it is only a commitment with performance (the number of times a new log >file is generated) and the >quantity of information we can loose in case of a crash? It only determines, when AutoLog will create a new log backup and how large it will be. >2) Is it possible to convert a RECOVER Backup on a MIGRATION Backup? No, but with SAP DB 7.3 a backup for recover can be consistent of nothing happened on the database during the backup. You can find out if a data backup is consistent or not in the backup history. With SAP DB 7.4 all data backups are consistent and a backup for recover is always a backup for migration. >3) I am using SAPDB 7.4.03. This version has the LOG_MODE parameter for >SINGLE/DUAL logging. Is it possible to specify different locations/mediums >for the two log files in case of DUAL logging? The two log volumes must be in different locations anyway. There is nothing like a dual log backup. >3.1)I have read somewhere that newer builds of the database have a >different parameter for this option. Does newer versions >offer more functionality for DUAL Logging? No, but you can now switch off log writing and the need for log backups independently from the single/mirrored logging. Best Regards, Tilo Heinrich SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
