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