Hi!
I'm working on timestamp recovery and have some questions about it.
Following scenario is used in this mail:
I've got an instance which has backup-medias for full backups (FULL),
incremental backups (INC) and log backups (LOG). AutoLog is switched on.
Several programmers are working on this instance. programmer "A" and "B" are
working on different tables. Now programmer "A" realizes, that he has done
some stupidities. Programmer "B" has done his work and is happy about the
result. "A" calls me to recover his broken table(s).
Here's an ASCII-art timeline:
11:50 12:00
| 11:55 | 12:05
| | | |
------------------------+---+------+--+-------->
SP1 SP2 SP3 SP4 SP5
| | | | |
*---F--+-A---+A----I--+-A---+---------+A-------*
|-TA-|
|---TB---|
F = full backup
I = incremental Backup
A = AutoLog Backup
SPn = Savepoint n
TA = Transaction of programmer "A"
TB = Transcaction of programmer "B"
Programmer "A" has realized his error early and remembers the exact time
(e.g. 12:00). The Savepoints are set arbitrarily by me (in real the DBMS
does this).
I would recover the database using the full-, incremental and the last three
or two AutoLog-backups (depending on the first log-page of the incremental
backup) until 11:59:59.
The problem: It seems that TA and TB are internally committed by SAP DB when
reaching SP5 - not earlier. So if I recover until 11:59:59 ALL transactions
committed between SP4 and SP5 are lost. Recovering until 12:05:00 recovers
TA and TB but I don't want TA to be recovered.
Here are my commands for recovering:
...
db_admin
util_connect
recover_start FULL data
recover_start INC pages
recover_start LOG log 002 until 20031211 11:59:59
recover_replace LOG log.003
recover_replace LOG log.004
...
After the last log backup the instance is ONLINE.
The commands are from my memory. But they illustrate the recovery-process.
Am I wrong? Is there a possibility to explicitly recover a certain
transaction or to ommit some transactions when recovering?
Bye
Christian Jung
PS I'm running SAP DB 7.4.3.27 on Linux.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
