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?
it fails to restore the db backup and logs 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). 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! My point now: SGA2 db host "1" .08: complete backup DATOS not working for restoration �? complete backup made today EXPORT WORKS log backup sequence 007 made today seems not to work applied to EXPORT backup. 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? Thanks, Josu. On Wed, 3 Nov 2004 14:57:52 +0100, Hahn, Uwe <[EMAIL PROTECTED]> wrote: > The errors are telling you that your hotstandby configuration is invalid. > You cannot use hotstandby until you have specific hardware. > So I think you should correct your parameters and then a restore to the target > instance > will be successfull. > HS_NODES should not be used and should be deleted. > kind regards, > Uwe > > > > >-----Original Message----- > >From: Josu [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, November 03, 2004 10:17 AM > >To: [EMAIL PROTECTED] > >Subject: Restoring backup to another host > > > > > >Restoring/migration a db from a host named debian to another named > >za02 gives the resulting error .... > > > >2004-11-03 10:16:47 18554 46 Admin + 2004-11-03 10:16:47.000 > >RTE ERROR 332004-11-03 10:16:47 18554 46 Admin - the local > >node name (ZA02) could not be found in the list of configured > >HotStandBy nodes > >2004-11-03 10:16:47 18554 46 Admin The database parameters > >are neither correctly configured for 'HotStandby' nor for 'Normal' > >operation. > >2004-11-03 10:16:47 18554 ERR 8 Admin ERROR '' CAUSED > >EMERGENCY SHUTDOWN > >2004-11-03 10:16:47 18554 12696 DBSTATE Change DbState to > >'SHUTDOWN'(25) > > > >Can i make anything to solve this? > > > >Thanks, > >Josu. > > > >-- > >MaxDB Discussion Mailing List > >For list archives: http://lists.mysql.com/maxdb > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
