hi Torsten,

Thanks for your reply here is he file you requested. I also observed that if
I try to take Database from offline to warm I get -8 error and from cold to
warm -9000.
Hope this will help you in solving my problem.

Thanks
Sudhakar
----------------------------------------------------------------------------
--
Date       Time     TID(hex)   Typ MsgID      Label    Message
----------------------------------------------------------------------------
--
2002-10-10 16:58:41 0x00004674              0 DBM      command
backup_history_open
2002-10-10 16:58:41 0x00004674 ERR     -24982 DBM      ERR_NOHISTORY: backup
history file not found
2002-10-10 16:58:55 0x00004674              0 DBM      command
backup_history_open
2002-10-10 16:58:56 0x00004674 ERR     -24982 DBM      ERR_NOHISTORY: backup
history file not found
2002-10-10 16:59:08 0x00004674              0 DBM      command util_execute
VERIFY
2002-10-10 16:59:31 0x0000467e              0 DBM      command
service_connect
2002-10-10 16:59:33 0x0000467e              0 DBM      command
backup_restore_check "SAPdb-fullbackup-TESTDB" DATA
2002-10-10 16:59:33 0x0000467e              0 DBM      command
service_release
2002-10-10 17:00:04 0x00004674              0 DBM      command
param_startsession
2002-10-10 17:00:04 0x00004674              0 DBM      command
param_abortsession
2002-10-10 17:00:10 0x00004674              0 DBM      command
backup_history_open
2002-10-10 17:00:10 0x00004674 ERR     -24982 DBM      ERR_NOHISTORY: backup
history file not found
2002-10-10 17:00:19 0x00004674              0 DBM      command
backup_history_open
2002-10-10 17:00:19 0x00004674 ERR     -24982 DBM      ERR_NOHISTORY: backup
history file not found
2002-10-10 17:01:32 0x000046f0              0 DBM      command
backup_restore "SAPdb-fullbackup-TESTDB" DATA
2002-10-10 17:02:24 0x00004674              0 DBM      command db_warm -f
2002-10-10 17:02:24 0x00004674 ERR     -24988 DBM      ERR_SQL: sql error
                    0x00004674 ERR     -24988 DBM      -9000,Message not
available
2002-10-11 10:11:58 0x000051c9              0 DBM      command db_warm -f
2002-10-11 10:11:58 0x000051c9 ERR     -24988 DBM      ERR_SQL: sql error
                    0x000051c9 ERR     -24988 DBM      -8,Message not
available
2002-10-11 10:17:22 0x000051c9              0 DBM      command db_warm -f
2002-10-11 10:17:22 0x000051c9 ERR     -24988 DBM      ERR_SQL: sql error
                    0x000051c9 ERR     -24988 DBM      -8,Message not
available
2002-10-11 10:18:48 0x000051c9              0 DBM      command db_offline
2002-10-11 10:18:52 0x000051c9              0 DBM      command db_warm -f
2002-10-11 10:18:57 0x000051c9 ERR     -24988 DBM      ERR_SQL: sql error
                    0x000051c9 ERR     -24988 DBM      -9000,Message not
available
2002-10-11 10:20:10 0x000051c9              0 DBM      command db_cold -f
2002-10-11 10:20:17 0x000051c9              0 DBM      command db_warm -f
2002-10-11 10:20:17 0x000051c9 ERR     -24988 DBM      ERR_SQL: sql error
                    0x000051c9 ERR     -24988 DBM      -8,Message not
available

----- Original Message -----
From: "Strahl, Torsten" <[EMAIL PROTECTED]>
To: "'Sudhakar'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 4:24 AM
Subject: RE: restore database error -24988


> Hi,
> this sounds very strange, because error code -9000 means:
>        -9000 System error: Not yet implemented!
>
> This is very funny, because nobody would expect that the
> restart command will fail with 'not implemented'. So I need
> some more informations. Please send me the dbm.prt file located
> in the rundirectory of the kernel.
>
> Regard,
> Torsten
>
> SAP DB, SAP Labs Berlin
>
>
> -----Original Message-----
> From: Sudhakar [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 10. Oktober 2002 23:24
> To: [EMAIL PROTECTED]
> Subject: restore database error -24988
>
>
> hi,
>
> I made some progress in restoring the database from the Complete Backup
with
> checkpoints. But I get this error when I try to start the database after
> recovery.
>
> Error Code: -24988
> Description: sql error [db_warm -f];-9000,Message not available.
>
> Here are the steps I did to restore the database on my linux machine.
> 1) Created a new instance using DBMGUI and used the complete backup file
> with check points created on another linux machine for restoring the
> parameters.
> 2) I created the database using the restore instance not the install
> instance.
> 3) After creating the database I used DBMGUI recovery option to recover
the
> database from the backup medium that I added during database creation.
> 4) After I finished step 3 I tried to get the database to warm state and I
> got this -24988 error
>
> Did I miss any step in restoring the database. I DID THE SAME THING ON
> WINDOWS 2000 AND EVERY THING WORKED JUST FINE  AND I AM ABLE TO USE THE
> TABLES AND DATA normally.
>
> Any help appreciated.
>
> Thanks
> Sudhakar
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
>


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

Reply via email to