Hallo Daniel,

The service connection is no connection to the database that is to be 
recovered, but a connection to the so called service database. The service 
database is a special database that is created during software installation. 
This service database also handles the recovery of parameters from backups.

To restore a database from a file backup of another database the following 
sequence of dbmcli-commands should work:

dbmcli -R <INSTROOT> db_create <dbname> <dbmuser>,<dbmpassword>
dbmcli -d <dbname> -u <dbmuser>,<dbmpassword>
>medium_put <mediumname> <backuplocation> FILE DATA
>service_connect
>recover_config <mediumname>
>service_release
>param_directput RUNDIRECTORY <newrundirectory>
>db_admin
>db_connect
>db_activate RECOVER <mediumname>
>db_online
>exit

If this does not work, please specify what step went wrong and what the error 
message was.

Best regards,
Tilo Heinrich
SAP Labs Berlin

 

-----Original Message-----
From: Daniel Rosowski [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 27, 2006 4:06 PM
To: maxdb@lists.mysql.com
Subject: RE: disk full, now kernel dies before reaching admin state

>how did you set the parameters of the new database? Did you
>recover the configuration from the backup using the command
>recover_config or did you set up the parameters manually?

recovering *anything* *anyhow* requires a service connection/session to the
database.
But in order to build up a service connection, the database needs to be in
admin state. See the conflict?

>If the kernel starts there should be some output in the
>file knldiag. The location of this file is determined by
>the database parameter RUNDIRECTORY. Read this parameter
>from your configuration and have a look into the mentioned
>file.

RUNDIRECTORY is /var/opt/sdb/data/wrk/SAG_VIP
Like I said multiple times before, no knldiag or knldiag.err can be found
there.

I tried initializing the database with backup parameters and by defining
parameters, but in both cases I get the same error.

Something is really broke here...

Daniel

-- 
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse für Mail, Message, More +++

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to