I did two exports:
via:
- CATALOGEXTRACT ALL OUTFILE '/tmp/cat.dmp'
- TABLEEXTRACT ALL OUTFILE '/tmp/tab.dmp'
the export seems to be done correctly
when i try to import into a newly created instance
via:
- CATALOGLOAD ALL INFILE '/tmp/cat.dmp'
- TABLELOAD ALL INFILE '/tmp/tab.dmp' OUTFILE '/tmp/restart.dmp'
i get a python-exception:
repman.CommunicationError: repman.CommunicationError: [1] protocol
error
logfile:
/var/opt/sapdb/indep_data/wrk/repserver.log
-------------------------------------------------------------
/ M ReplMan 7.3.0 Build
020-000-084-665
/ *
/ M Starting protocol at 2002021300141029
/ *
/ *
/ *
/ M START 20020213 00141029
/ *
set logowner andre
/ *
/ M START 20020213 00141029
/ *
USE USER DBA *;
/ *
/ M USER: 'DBA'
on DB: 'MOON'
/ *
/ M START 20020213 00141029
/ *
CATALOGLOAD ALL INFILE '/tmp/cat.dmp'
/ *
/ M Releasing user connection (USER: 'DBA').
/ *
/ M START 20020213 00141029
/ *
TABLELOAD ALL INFILE '/tmp/tab.dmp' OUTFILE '/tmp/restart.dmp'
/ *
/ M Input data file used: /tmp/tab.dmp0001
/ *
-------------------------------------------------------------
(ends here)
it seems that the server goes to nirvana.
My python code:
-------------------------------------------------------------
if "y"==raw_input("Export? [y/n]: "):
session=None
try:
session=repman.RepMan("server2","DATABASE2")
session.cmd("USE USER DBA pwd;")
session.cmd("USE SERVERDB DATABASE1 ON server1;")
print session.cmd("CATALOGEXTRACT ALL OUTFILE '/tmp/cat.dmp'")
print session.cmd("TABLEEXTRACT ALL OUTFILE
'/tmp/tab.dmp'")
finally:
del session
if "y"==raw_input("Import? [y/n]: "):
session=None
try:
session=repman.RepMan("server2","DATABASE2")
session.cmd("USE USER DBA pwd;")
print session.cmd("CATALOGLOAD ALL INFILE '/tmp/cat.dmp'")
print session.cmd("TABLELOAD ALL INFILE '/tmp/tab.dmp'
OUTFILE '/tmp/restart.dmp'")
finally:
del session
-------------------------------------------------------------
server2 is a linux-rpm-installation of:
sapdb-ind-7.3.0.20-1
sapdb-srv-7.3.0.20-1
server1 is a linux-rpm-installation of:
sapdb-ind-7.3.0.8-1
sapdb-srv-7.3.0.8-1
I used the ReplicationServer of server2 (7.3.0.20) to
- export the data from server1 (7.3.0.8)
- import.the data to server2 (7.3.0.20)
Any suggestions?
--
_____________________________________________
inworks GmbH
Andre Reitz
Magirusstrasse 44 Tel. 0731/93
80 7-21
89077 Ulm
http://www.inworks.de
