> Still can't understand why was recovered a database that > contained all the > data, even that inserted after the last backup. > > I repost my recover script: > > @echo off > > rem ** sapdb bin path ** > set PATH=c:\sapdb\indep_prog\bin;c:\sapdb\indep_prog\pgm;%PATH% > > rem ** name of the database ** > set SID=PORTAL > > rem ** backup database ** > echo db_cold >> param.tmp > echo util_connect dbm,dbm >> param.tmp > echo recover_start data DATA >> param.tmp > echo util_release >> param.tmp > echo db_warm >> param.tmp > type param.tmp | dbmcli -uUTL -d %SID% -u dbm,dbm >> restore_log.txt > del param.tmp >
Hi, when you only recover the data, then the log-entries on the log-volume remain unchanged. At the time you restart the database with the old data, these entries are "redone" in order to allow a complete recovery. If you don't want this, please use the option -u <yyyymmdd> <hhmmss> for your restart in order to stop the Redo at the specified time. Take care, that you make a databackup afterwards, because the time-in-point-recovery interrupts the backup-history. regards, Martin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
