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
