Hi David, we do the following daily for backup:
dbmlcli -u dbm,<dbpasword> -d <databasename> <<EOM; util_connect backup_start DATA DATA release EOM We do this in online mode, no cold, no warm. The database is running. We have turned AUTOLOG on and we would expect that a restore would be done be a restore of the DATA-backup and replaying the logs from the point of backup-time. The DATA-backups and the AUTOLOG-Backups are saved via ADSM. Regards, Dirk David Barcelo schrieb: > > Hello list, > I have been backing up my current sap database for a month and I have > currently been told that I may not be doing it correctly. I do not have > a background in databases and so I would love it if someone could point > me in the right direction. The issue that I am dealing with is that > when I perform a restore the data may not be consistent. That is to > say that there could be transactions in the logs that have not been > committed. When I first perormed a log restore the database broke and I > had to rebuild it. Due to my own ignorance (and possibly laziness) I > scrapped trying to restore logs and just restored data becuase at the > time I didn't exactly understand the functions or importance of logs. > Is there a standard way to backup and restore a database? Are there > different ways to skin a cat? I would appreciate any incite someon > could provide. At the end of the message I have included the shell > scripts that I use for backups. Feel free to critique. > > Thank you very, very much in advance, > Dave > > ############################################### > #!/bin/bash > cd /var/spool/dbbackup/IceBurg > > /bin/cat << EOF | /opt/sapdb/depend/bin/dbmcli -d fooDB -u dba,foo > db_cold > > util_connect > > backup_start dataCOMP3 data > #backup_start logCOMP log > db_warm > > quit > > EOF > > val=`cat ver.txt` > > val=`expr $val + 1` > > echo $val > ver.txt > > cp dataCOMP3 dataCOMP3.`echo $val` > ################################################################ > > -- > _____ > > James David Barcelo > Network/Systems Administration > > Data Junction Corporation > 2201 Northland Drive > Austin, TX 78756 > tel: 512-459-1308 ext. 349 > fax: 512-469-1309 > www.datajunction.com > * The contents and attachments in this email are confidential. > > _____ > > _______________________________________________ > 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
