RE: standby instance, log recovery

Hello Jacob,

So what does knldiag.err tells you and what do "medium_label <data_medium>" and 
"medium_labeloffline importlog 001" say about the database ID's?

Best regards,
Tilo Heinrich
SAP Labs Berlin

>-----Original Message-----
>From: Raimund Jacob [mailto:Raimund.Jacob@xxxxxxxxx] 
>Sent: Friday, January 21, 2005 6:35 PM
>To: MaxDB List
>Subject: standby instance, log recovery
>
>
>hello, *!
>
>i am using this nice database since 7.3 and now with 7.5 i want to do 
>some more advanced stuff :)
>
>i want to run a standby instance that is constantly fed by log backups 
>of a main instance, which seems to be a more or less standard task.
>
>my main instance works nice. i disabled autolog since i want 
>to control 
>the log backups. i ran a full backup and used that to create 
>the standby 
>instance (recreated it from the parameters, then recovered the data).
>
>now i am at the point where i want to load the first log backup (which 
>was created manually by backup_start mylogbackupmedium) and it 
>gives me:
>
>recover_start importlog LOG 001
>ERR
>-24988,ERR_SQL: sql error
>-8003,Log and data must be compatible
>
>and knldiag.err shows the db-identifiers, which indeed differ. 
>now, the 
>documentation points out that the standby instance must not have been 
>brought online, which of course happened.
>
>the questions are: is this the only reason why this recover does not 
>work? will it work when i create another instance the same way and do 
>not bring it online? is there some way to change the standby instance 
>somehow so that i accepts the log backup anyway? i had the impression 
>that 'util_execute clear log' somehow might help, but it doesnt.
>
>thank you very much for any advice,
>       Raimund Jacob
>
>ps: it probably does not matter, but the main instance was 
>created from 
>an older 7.4 instance.
>
>pps: for the 7.4->7.5 and 7.5->7.5 copy operations i wanted to use the 
>documentation from the chapter "Homogeneous System Copy with the 
>Database Manager CLI". this documentation is wrong. it uses "INIT 
>CONFIG" which does not exist anymore and it has the point wrong where 
>you have to create the medium to import the data from.
>
>-- 
>7. RedDot Anwendertagung der RedDot Usergroup e.V. am 31.1.2005
>Pinuts präsentiert neue Entwicklung, http://www.pinuts.de/news
>
>Pinuts media+science GmbH                 http://www.pinuts.de
>Dipl.-Inform. Raimund Jacob               Raimund.Jacob@xxxxxxxxx
>Krausenstr. 9-10                          voice : +49 30 59 00 90 322
>10117 Berlin                              fax   : +49 30 59 00 90 390
>Germany
>
>
>-- 
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:    
>http://lists.mysql.com/maxdb?unsub=tilo.heinrich@xxxxxxx
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx