Hello!
I have a few doubts/questions about the backup and recovery mechanism.
Any answers/experiences would be welcome:
1) For a real system, the docs advice to use AutoLog On. Can this backups
be taken to an external backup like a tape, or does this imposes overheads
to the system?
1.1) Case AutoLog is on, is there any need to take interactive log
backups?
2) In a recovery procedure, which log backups do we need to recover? Do we
need to know exactly one which was taken before the recovered
complete/incremental backup?
2.1) Do we need to execute a recover_start for each log version file?
Or
is this procedure automatic after the recover_start of the first version?
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?
3) Should each backup use a different medium, or can a medium hold more
than one backup (of the same type)?
4) Is it possible to archive version files with the dbmcli, or any other
SAP client?
Thanks in advance,
Victor Batista
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
