Hi Benoit, if you want to restore a 7.3 backup into a 7.4 database, you have to call the util_execute migrate command before. (see below)
If you want to restore 7.3 backup into 7.3 it's not needed. If you want to restore 7.4 backup into 7.4 it's not needed. I think it's not necessary to keep the 7.3 system, because after the successful release update from 7.3 to 7.4 you start a new backup history! Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Benoit Menendez [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 13. Februar 2003 20:26 To: Strahl, Torsten Cc: [EMAIL PROTECTED] Subject: Re: How do I restore... Does this mean that I cannot restore a backup I did a month ago where I did not do the util_execute migrate? I need to keep a 7.3 system up just to do the conversion of old backups? Benoit ----- Original Message ----- From: "Strahl, Torsten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 1:33 AM Subject: RE: How do I restore... > Hi Benoit, > you should take a look at the following documentation > > http://www.sapdb.org/7.4/pdf/migration73_74eng.pdf > > If you want to migrate your database from 7.3 to 7.4 via restore data > you should create a full database backup in db_state cold, but pay attention! > > Before you start the cold backup you have to call in db_state cold: > > dbmcli -d <...> -u <...>,<...> util_execute migrate > > After calling this command you have the start your backup without(!) > changing the db_state. This is very important, because the migrate > command will set a flag in the restart record which will be reseted > by the next restart. The 7.3 database backup could be only restored > if the restart record of the backup contains the migrate flag, otherwise > you get the error code -111 and the output in the knldiag file. > > > Regards, > Torsten > > SAP DB, SAP Labs Berlin > > > > -----Original Message----- > From: Benoit Menendez <[EMAIL PROTECTED]> > [mailto:[EMAIL PROTECTED]] > Sent: Donnerstag, 13. Februar 2003 00:39 > To: [EMAIL PROTECTED] > Subject: How do I restore... > > > an old 7.3 full migration backup in a 7.4 instance. > > I did: > > db_offline > db_start -f > util_connect > util_execute INIT CONFIG > recover_start ... > > I get an error: > > ERR > -24988,ERR_SQL: sql error > -111,Message not available > > With the following database error: > > 2003-02-12 15:17:31 0xC4C ERR 52000 RESTORE Kernel 7.3.0 Build > 025-000-085-923 > 2003-02-12 15:17:31 0xC4C ERR 52000 RESTORE Restore not possible. > Hostfile > too old! > 2003-02-12 15:17:31 0xFA4 ERR 52012 RESTORE error occured, basis_err > 1040 > > I hope there is an easy way to restore 7.3 full backup media > > Thanks for your help > > Benoit > > > _______________________________________________ > 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
