Re: no data from log in database after restore

Hello Uwe,

thank you for your quick anwer.

With admin mode, you think of the state of  the database?
If so,  it looks like a more severe problem, because the db is set to 
this state before doing the log in the script sap_logtest_01.sh..
...

dbmcli -d $SID -u $DBUSER,$DBPASS db_cold >>$LOG 2>&1

dbmcli -uUTL -d $SID -u $DBUSER,$DBPASS backup_history_open >>$LOG 2>&1

dbmcli -d $SID -u $DBUSER,$DBPASS medium_put $MEDIA $FILE FILE LOG 0 8 YES >>$LOG 
2>&1

dbmcli -uUTL -d $SID -u $DBUSER,$DBPASS backup_start $MEDIA MIGRATION LOG >>$LOG 
2>&1
....


Will look for operations, that can be found in a log backup, later this day.


kind regards
        Thorsten









Hahn, Uwe wrote:

> > -----Original Message-----
> > From: Thorsten Weers [mailto:tweers@xxxxxxxxxxxxxxxxx]
> > Sent: Dienstag, 28. Oktober 2003 09:59
> > To: maxdb@xxxxxxxxxxxxxxx
> > 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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx