Hi Josu, > -----Urspr�ngliche Nachricht----- > Von: Josu [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 3. November 2004 16:36 > An: Hahn, Uwe; [EMAIL PROTECTED] > Betreff: Re: Restoring backup to another host > > > I have currently using dbmcli deleted the parameter on the old db but > now i get more or different errors on the new one on importing. When i > startup the new db from a complete backup restore (not logs) i cant > modify the existing data!!!!!!! why? what do you mean with "cannot modify data"? Do you get an error when executing SQL-Statements? Which error?
> > it fails to restore the db backup and logs What error do you get? Can you solve the error or do you leave it and proceed? > but if i make a new > complete backup i am able to restore and start new instance but then i > cannot modify them!!! (but i can add new ones). Please tell us, what do you add at this point. > Also if i make a > complete log backup it writes the next sequence number for the backup > file but i want to make a complete log backup! as the old ones with > the new complete backup i use dont work! Every time a logbackup is made the extension of the backupfile is incremented. The underlying concept for logbackups is complete different to the one of databackups. I.e. there is no complete vs. incremental backup, but only a backup of yet unsaved logpages. > > My point now: > > SGA2 db host "1" .08: > complete backup DATOS not working for restoration �? Does ist not? What error do you get? > complete backup made today EXPORT WORKS > log backup sequence 007 made today seems not to work applied > to EXPORT backup. What do you mean by saying "it seems not to work"? Didn't you get an returncode from the restore log? > logs 001 to 006 don work when applied to EXPORT backup restore. > > SGA db host "2" .19 > is only able to start instance and recover it using EXPORT backup. > DATOS backup results in non working database. > > Seems that DATOS backup has the HS_NODES parameter hardcoded and only > EXPORT which has been done after quitting it works ....... any idea on > how to recover DATOS and 001 to 006 log backups? > If some database-administration does not work, then have a lokk into the diagnostic files (at most dbm.knl, knldiag) and if you do not understand the errors there, then please provide us this information. It is hard for us to analyse a problem, if you do not exactly describe what you did and which command returned which returncode. Kind regards, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
