Hi Albert, We have done 7.4 restores without 'clear log'. The backup was done with the MIGRATE option - which I understand does not require the logs.
Our problem is that after the restore MaxDB does not show the data pages. I am more than willing to experiment further. I will add a 'clear log' - do you suggest before the load_systab? Thank you. Stephen -----Original Message----- From: Albert Steckenborn [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 3:55 AM To: [EMAIL PROTECTED] Subject: Re: create new db instances from data backup. Hi, I've seen nothing about restore of LOG-Files??? Of course a "util_execute clear log" after recover will help. rgds. Albert Steckenborn Stephen Gutknecht (SAPDB) schrieb: > Hi, > > We are long time SAPDB users. With MaxDB we are having failures in regards > to this process. We are waiting to hear from Uwe Hahn @ SAP on this issue. > > The procedure we used: > http://www.IPCoast.com/MaxDB-Restore02.txt > > Generates no errors, but it also does not produce a usable restore. > However, it can serve as reference for discussion. > > Stephen Gutknecht > > > > > > -----Original Message----- > From: RemsangPulamte [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 20, 2003 12:01 AM > To: [EMAIL PROTECTED] > Subject: create new db instances from data backup. > > > Hi all > Can anyone tell me how to transfer database from one MaxDb server to > another. My objective is to setup a new server and database instances from > my database backups. > I cannot afford to lose data or have a parallel (mirrored) server running > due to hardware restrictions. > > I am running MAXDB on a win2k platform. > > I have created complete backup as below: > 1. dbmcli -d DBname -u dba,dba medium_put MyBackup c:\maxdb\backup\filename > FILE DATA 0 8 YES > > 2. dbmcli -d DBname -u dba,dba -uUTL -c backup_start MyBackup > > 3. I set up a new server and created new instances from my backup file > 'MyBackup'. > All pages were copied correctly but the db remains in admin state only after > the installation. It cannot be switch to online state. > It returns an error - > dbmcli on scidata>db_restart > ERR > -24895,ERR_SHUTDOWN: shutdown of database occured > -71,connection broken > > How can I make it online? please help > > > Thanks in advance > regds > K R Pulamte > > > -- 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]
