Hello Martin, Wednesday, February 19, 2003, 9:45:39 AM, you wrote:
>> >> -----Original Message----- >> >> From: Hans Scheffers [mailto:[EMAIL PROTECTED]] >> >> Sent: Dienstag, 18. Februar 2003 15:44 >> >> To: [EMAIL PROTECTED] >> >> Subject: Kernel Panic >> >> >> >> >> >> Hi >> >> Last saturday we had a kernel panic on our development system. >> >> Because of this, sapdb has crashed also and I am not able >> to start the >> >> database again. >> >> The database will come up with db_cold to the cold state, >> but db_warm >> >> gives the following error message: >> >> >> >> dbmcli on TST>db_warm >> >> ERR >> >> -24988,ERR_SQL: sql error >> >> -4008,Message not available >> >> >> >> >> >> The system runs sapdb-7.3.0.29 on redhat 7.3 >> >> BM> You should save the log-pages of the crashed database in >> cold-mode. >> >> Thx Martin, >> >> This is what I have done so far: >> > util_connect dbm,xxxx >> > backup_start auto RECOVERY log >> >> As far as I understand, it has now saved the logpages to a file called >> autosave.xxx >> >> How can I restore these files and how do I get the database in the >> warm state again? >> >> BM> execute the following dbmcli-command at the original database BM> in offline mode: BM> backup_history_list -r LAST BM> you will get the backup-items. starting with a complete backup, BM> eventually an incremental backup and the log-backups needed. BM> 1) create media-definitions for reading the data and log-backup with BM> backup_media_put ... BM> 3) restore data BM> db_cold BM> util_connect BM> recover_start data_medium_name data BM> 4) restore log starting with logBackupNo xxx until yyy BM> recover_start log_medium_name log xxx BM> recover_replace log_medium_name filename xxx+1 BM> recover_replace log_medium_name filename xxx+2 BM> recover_replace log_medium_name filename xxx+3 BM> .... BM> recover_replace log_medium_name filename yyy BM> recover_ignore BM> now the database should be in warm-mode. BM> Regards, Martin BM> P.S. please reply always to the list, because..... BM> _______________________________________________ BM> sapdb.general mailing list BM> [EMAIL PROTECTED] BM> http://listserv.sap.com/mailman/listinfo/sapdb.general This worked... thx very much :-) -- Best regards, Hans mailto:[EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
