Hi Tilo,

after I performed a 'util_execute INIT CONFIG' via dbmcli (as suggested by Patrick 
Buchinger) I did another try for the recovery via dbmgui (v7.3.0.15): As You suggested 
I used dbmgui->instance->recovery->database->restore a medium. I selected the full
backup. A first approach failed because of -6 (invalid session) error (I do not know 
why). But a second approach was successful! Now I can bring up this database into warm 
state!

Thank You for Your help!

kind regards
Frank Schimmelpfennig

PHILIPS Semiconductors Hamburg
ATO-PICTOH  IT&DataSupport
Tel.: +49 40 5613 -1835, Fax: -3020



                                                                                       
                                                
                      "Heinrich, Tilo"                                                 
                                                
                      <tilo.heinrich@s             To:  Frank 
Schimmelpfennig/HBG/SC/PHILIPS@EMEA1                                     
                      ap.com>                      cc:  [EMAIL PROTECTED] 
                                                
                                                   Subject:   RE: System Error -9111 
--> What is the Meaning? (restore problem)        
                      25.03.02 16:42                                                   
                                                
                                                   Classification:                     
                                                
                                                                                       
                                                
                                                                                       
                                                




Hi Frank,

sorry I did not explain the error -118. It means "SERVERDB must be
activated". If a database is installed the command util_activate must be
called. During a restore the database should be activated implicitly (a
util_activate after a successful restore should lead to "-119, SERVERDB
already activated"). That's why I asked for dbm.prt.

Ok, now to your log files:

dbm.prt:

2002-03-25 12:50:28 0x00006c88              0 DBM      command
backup_restore_check "data000" DATA
2002-03-25 12:50:30 0x00006c88              0 DBM      command
service_release
2002-03-25 12:52:32 0x00006c85              0 DBM      command db_warm -f

2002-03-25 12:52:33 0x00006c85 ERR     -24988 DBM      ERR_SQL: sql error
                    0x00006c85 ERR     -24988 DBM      -118,Message not
available

dbm.utl
No "RESTORE DATA ..." can be found.

The command backup_restore_check does not make a restore of your database,
it just checks your backup for errors (by making a restore with the service
kernel and without writing any data to disk). No data was restored into your
database.

You can either use dbmcli (e.g. "dbmcli -d S_LUNA1 -u <user>,<passwd> -uUTL
-c recover_start data000 DATA") or DBMGUI->Instance->Recovery->Database for
a restore. If you already used the second way with DBMGUI, I would be
interested in the DBMGUI version you are using.

HTH,
Tilo Heinrich
SAP Labs Berlin




_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to