> -----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]
