Hallo, in step 5 you should use install _with_ recovery and not only installation of new instance.
After your full installation you have created a new db instance with its own data and log area. When you only recover the data from AA to BB your log area does not match the overwritten data area. You then have a data area AA and a log area from BB which definitly does not match. kind regards Uwe > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 7. August 2003 14:55 > To: [EMAIL PROTECTED] > Subject: Error 'LogAndDataIncompatible' > > > Hello > > It sounds too simple: I'm trying to copy a > database instance TST running on server AA > to server BB. > Both SAP DBs are 7.4.3, running under Win2K. > > I get these errors after executing the steps below > > Front-end error: > -24895 shutdown of database occured [db_warm -f]; > -71,connection broken > > Knldiag error: > DBIdentifier of DataVolume (AA:TST_2003xxxx) and > LogVolume (BB:TST_2003xxxx) does not match > RestartArchiveLog: LogAndDataIncompatible > RestartError '3800' => SHUTDOWN IS FORCED > > > 1. Start DBMGUI on server AA. > 2. Choose database instance > 3. Backup - Complete Data - to FILE "x:\complete_bkp" > (x: is a shared disk drive) > 4. Switch to DBMGUI on server BB. > 5. Instance - Install - TST - on local server > - with same DBM and DBA username/passwords > - restore parameters from a backup medium > (choose the x:\complete_bkp file) > - "The database instance was created successfully. > If required, adjust the parameters now." > - Keep parameters and volumes as they are > - Install and start instance > - Register database instance as TST > 6. Switch instance TST on server BB to "admin mode". > 7. Recovery - Database - Restore a medium - Next step > - "x:\complete_bkp" - Start > - "If you restart the database now, it will be > completely restored" - Restart > > How can the error be circumvented? Is the solution > beyond the abilities of DBMGUI? > > Are there easier ways to copy TST from AA to BB? > How do they work? > > Christian > -- > > -- > COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test > -------------------------------------------------- > 1. GMX TopMail - Platz 1 und Testsieger! > 2. GMX ProMail - Platz 2 und Preis-Qualit�tssieger! > 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. > daybyday - 8. e-Post > > _______________________________________________ > 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
