Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Re: no data from log in database after restore: msg#00444

db.maxdb

Subject: 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




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
qplus.devel/200...    network.jabber....    debian.qa-packa...    encryption.gpg....    python.dabo.dev...    uclinux.devel/2...    science.mathema...    recreation.pesc...    kernel.ck/2004-...    mozilla.devel.e...    tex.latex.prosp...    ietf.multi6/200...    bbc.cvs/2002-11...    xfree86.newbie/...    jakarta.taglibs...    altlinux.hardwa...    comedi/2002-05/...    horde.bugs/2004...    games.diplomacy...    finance.e-gold....    web.dom.test-su...    lang.ruby.rails...    os.netbsd.devel...    video.gstreamer...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation