Hy, it would be very nice if somebody would answer some simple questions aubout
backup/recovery.
The first part of this mail describes what I am doing (successfulle). My Questions are
at the
end of the Mail.
I want to move a database called "OLDINST" to an other server into a newly created
instance called
"NEWINST".
Thanks in advance, Andre'
WHAT I AM DOING (SUCCESSFULLY):
-----------------------------------------------------------------------------
A. BACKUP
From Server1: 7.3.0.8 (Linux, SuSE 6.4)
From Instance: OLDINST
Step 1:
cat <<EOF | dbmcli -d OLDINST -u DBM,DBM
backup_media_put mybackup /tmp/full.dmp FILE DATA 0 8 YES
util_connect DBM,DBM
backup_start mybackup MIGRATION DATA
quit
EOF
Step 2:
Now I copy the file to a new machine
-----------------------------------------------------------------------------
B. RECOVERY (on a different server)
To Server: 7.3.0.21 (Linux, SuSE 7.3)
To Instance: NEWINST
Step 1:
Prepare a completely new instance (with an onther name)
- mkdir /var/opt/sapdb/NEWINST
- dbmcli -s -R /opt/sapdb/depend db_create NEWINST DBM,DBM
- cat <<EOF | dbmcli -d NEWINST -u DBM,DBM
param_rmfile
param_startsession
param_init OLTP
param_put LOG_MODE SINGLE
param_put CAT_CACHE_SUPPLY 300
param_put DATA_CACHE 2500
param_put MAXDATADEVSPACES 5
param_put MAXDATAPAGES 1024000
param_checkall
param_commitsession
param_adddevspace 1 SYS /var/opt/sapdb/NEWINST/DISKS01 F
param_adddevspace 1 DATA /var/opt/sapdb/NEWINST/DISKD0001 F 4000
param_adddevspace 1 LOG /var/opt/sapdb/NEWINST/DISKL001 F 1000
quit
EOF
- dbmcli -d NEWINST -u DBM,DBM db_start
- cat <<EOF | dbmcli -d NEWINST -u DBM,DBM
util_connect DBM,DBM
util_execute init config
quit
EOF
Step 2:
Recovery of the full backup
- cat <<EOF | dbmcli -d NEWINST -u DBM,DBM
backup_media_put myrecover /tmp/full.dmp FILE DATA 0 8 YES
util_connect DBM,DBM
util_execute INIT CONFIG
recover_start myrecover
db_warm
quit
EOF
-----------------------------------------------------------------------------
MY QUESTIONS:
Q1: Does it seem to be correct what I am doing?
Q2: Must OLDINST and NEWINST have the same devspace sizes?
Q3: DBMGUI shows only the "DBM"-User under Configuration/Users on NEWINST, but it is
possible
to connect the database with the "imported" DBA user.
(on OLDINST DBMGUI shows the Users: "DBM","operator","DBA")
Did I something wrong?
Q4: What is the operator user? (I didn't create it)
Q5: On what does it depend that the User is shown in DBMGUI?
(seems: only systemusers, but what about "operator" and "domain"?)
Q6: Do I have to call: "dbmcli -d NEWINST -u DBM,DBM load_systab -u DBA,DBA -ud
domain" ?
If I do so, then DBMGUI shows the users: "DBM" and "DBA". But where is "operator"?
Q7: What exactly does load_systab? Can I call it everytime I want? :)
Greetings Andre' and thank you very much in advance.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
