Hello!
Thanks for your prompt reply!
I still have some doubts/questions. I would be very grateful if you could
answer me.
> >2.2) According to the doc "Backup and Recovery with the Database Manager
> >CLI:...", in a Recovery procedure, after the recovery of the
> version 001 of
> >the Logs (recover_start logsave LOG 001), a recover_replace and a
> >recover_ignore are executed:
> > - recover_start logsave LOG 001
> > - recover_replace logsave /usr/sapdb/log 002
> > - recover_ignore
> >2.2.1) What's does recover_replace and recover_ignore?
> >2.2.2) What does it really means the "Media change" of the log backup on
> >the recovery process?
>
> recover_start logsave LOG 001 -> /usr/sapdb/log.001 is recovered
> recover_replace logsave /usr/sapdb/log 002 ->/usr/sapdb/log.002
> is recovered
> recover_replace logsave ... 003 -> ....003 is recovered
> ...
> recover_ignore <- only needed if no log information can be found
> on the log volume.
I think I understood. 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>, ....
If I don't have any log file to recover, execute a recover_ignore.
Is this correct?
> >3) Should each backup use a different medium, or can a medium hold more
> >than one backup (of the same type)?
>
> A medium is basically a combination of a logical name, a file
> system path and the device type. If your backup medium points to
> a tape, you should replace the tape, otherwise the previous
> backup is overwritten. If your medium points to a file and is not
> for Log backups, you can make a backup only, if the file does not
> exist or if you specify the overwrite flag of the medium. If your
> medium points to a file and is for log backups, you can reuse it
> without hesitation, as a increasing number is added to the file name.
I want to automate my log mechanism.
This way, my scripts must add a medium each time a complete/incremental
backup is taken.
For the AutoLog, I can handle multiple files on the same medium. Correct?
New questions:
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?
2) Is it possible to convert a RECOVER Backup on a MIGRATION Backup? If the
machine which is running the database
completely crashes and must be replaced/substituted for another one. Is it
possible to recreate there the database with only
RECOVER backups? Which are the differences between the two types os backup?
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?
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?
Thanks in advance,
Victor Batista
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
