On Fri, 27 Jun 2003 14:50:54 +0200
"Paskamp, Marco" <[EMAIL PROTECTED]> wrote:
I have a simliar problem:
My DUMP file is from sapdb 7.3.0.29
I am trying to import it into sapdb 7.4.3.25
with the following statements (from a Python-script):
CMD: db_create XXX DBM,DBM
CMD: param_rmfile
CMD: param_startsession
CMD: param_init OLTP
CMD: param_put CAT_CACHE_SUPPLY 300
CMD: param_put CACHE_SIZE 2500
CMD: param_put MAXDATADEVSPACES 5
CMD: param_checkall
CMD: param_commitsession
CMD: param_addvolume 1 DATA /var/opt/sapdb/PLUTA/DISKD0001 F 81000
CMD: param_addvolume 1 LOG /var/opt/sapdb/PLUTA/DISKL001 F 22000
CMD: db_start
CMD: util_connect DBM,DBM
CMD: util_execute init config
CMD: backup_media_put fullrestore_tmp /tmp/fullbackup_XXX_20030625.dmp FILE DATA 0 8
YES
CMD: util_connect DBM,DBM
CMD: recover_start fullrestore_tmp
Traceback (most recent call last):
File "./sapdb_db_create.py", line 225, in ?
SEND(session,"recover_start %s" % MIGRATIONMEDIUM)
File "./sapdb_db_create.py", line 129, in SEND
r=session.cmd(cmd)
dbm.DBMServError: dbm.DBMServError: [-24988] sql error
Is this the same Problem?
> Hi,
> I've nerver try it out, but this are the steps you should do to migrate your
> database (>= 7.3.0.21):
> - shutdown the database (dbmcli -d<dbname> -u<user>,<passwd> db_offline)
> - start the database in cold mode (dbmcli -d<dbname> -u<user>,<passwd> db_cold)
> - set the migrate flag within the database (dbmcli -d<dbname> -u<user>,<passwd>
> util_execute migrate), this may take a few minutes.
> - make a complete backup in cold mode.
>
How do I bring the 7.3 Instance in the state before?
(undo: util_execute migrate)?
Greetings Andre'
> You can use this special backup to create a new SAP DB instance in version 7.3 or
> 7.4.
>
> HTH,
> Marco
> ----------------------------------------------
> Marco PASKAMP
> SAP DB, SAP Labs Berlin
>
> > -----Original Message-----
> > From: Georg Schoepe [mailto:[EMAIL PROTECTED]
> > Sent: Freitag, 27. Juni 2003 13:38
> > To: [EMAIL PROTECTED]
> > Subject: Export DB-Instance from a version 7.3 to a version 7.4-SAP DB
> >
> >
> > Hello,
> >
> > I tried to migrate a complete DB-instance from a version
> > 7.3.0.29 - System
> > to a version 7.4.03 - System.
> >
> > Migration of an existing instance can easily be done by creating a new
> > instance from a restore medium as I tried with version 7.4 backups und
> > recovery.
> > But unfortunataly it isn't possible to recover a 7.3-backup
> > on a 7.4-DB.
> > In this case I get an 111-error - Incompatible incremental backup.
> >
> > At the time I dont't want to update the 7.3-System.
> > Does anybody know a convenient method to migrate the instance?
> >
> > Thanks very much and greetings
> > Georg Schoepe
> >
> >
> >
> > _______________________________________________
> > 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
--
_____________________________________________
inworks GmbH Andre Reitz
H�rvelsinger Weg 39 Tel. 0731/93 80 7-21
89081 Ulm http://www.inworks.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
