I have checked it:
It doesn't matter if I tried the restore with the new dbmgui or scripts: The DATA are not in the DB after the restore of Log 01!
With the wizard I restored the data. In the next step I wanted to restore from medium until <date> <time>,
but it only take the first log nor gave me a chance to do the second and third one.
With the script I get the error, which I already have reported.
Also I tried to restore all logs in one dbmcli-session, butt the connection was broken with error -8888
and there was no entry in the error-log of the kernel.
The backup of logs were made from the beginning in admin_mode of db.
So until now, I have no chance to restore the data from the logs.
It is very important, because we are working with some databases of 600 GB.
Also it is no good thing, if you cannot restore the data between two backups of the complete db.
Kind Regards
Thorsten Weers
Hahn, Uwe wrote:
-----Original Message----- From: Thorsten Weers [mailto:[EMAIL PROTECTED] Sent: Dienstag, 28. Oktober 2003 09:59 To: [EMAIL PROTECTED] Subject: no data from log in database after restore
Hello,
when I was working with restore at SAPDB, I have the problem, that the data from log are not in the database after restore.
Sequence:
1. Data Backup Migration
2. call sap_logtest.sh
...
drop table TWS_TST
create table TWS_TST
add 3 records
show records in TWS_TST
perform backup log 01
If you start the log backup you backup all changes you have done before and the amount of log pages which can be backuped are divided in parts of the size LOG_SEGMENT_SIZE (a parameter). But only complete parts are backuped in online mode.
example: t1 time of last log backup t2-t3 doing some changes t3-t4 beginning the test with your known changes t5 backup log => it may be that the log of the time t2-t3 is backuped but the changes of t3-t4 not because it is not enough to satisfy the constraint LOG_SEGMENT_SIZE.
If you want to test recovery you should work with log backups in admin mode, because then all log is backuped and you know exactly what changes are in what log backup.
Another hint what operations can be found in a log backup is given by the timestamps of the log backups in dbm.knl.
kind regards Uwe
add 3 records show records in TWS_TST perform backup log 02 add 3 records show records in TWS_TST perform backup log 03
3. restore Data Backup (1.) 4. call sap_restore_log.sh
restore data log 01 The log of the restore shows no error(rc 0). I expect the newly created table and the data from it in db.
but: show records in TWS_TST, gave me the error
ERR
-24988,ERR_SQL: sql error
-4004,Unknown table name:TWS_TST
Restore log 02 DBM-Api error ( -4'received a garbled packet')
For me I seems, that the restore of log 01 is not ok. This happens everytime on solaris,linux and nt4.
What must be done to restore log 02 and 03? What have I done wrong? Is this a bug?
Thanks in advance.
Best regards
Thorsten Weers
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
