AW: AW: Recovery-data lost

Hello Kristian,

Your dbm.knl 

42370CBA0002|DAT_00002|SAVE COLD|2005-01-04 16:44:45|2005-01-04 
16:44:45|2005-03-15 17:26:35|2005-03-15 17:26:37|      2698|          |NO 
|DAT1                                                            |       
264|         1|         0|    

shows that indeed your backup was made at March 15-th but contained data that 
would set the database without any further log backups to the state of January 
4-th.

Sorry that we could not help in your case.

Best regards,
Tilo Heinrich
SAP Labs Berlin

-----Ursprüngliche Nachricht-----
Von: kris_pyl@xxxxxxxxxxx _ [mailto:kris_pyl@xxxxxxxxxxx] 
Gesendet: Freitag, 18. März 2005 14:20
An: Heinrich, Tilo
Betreff: RE: AW: Recovery-data lost

Tilo,

Thanks again for replying.

>I assume with backup and recovery you meant backups and recoveries using 
>MaxDB tools (dbmcli, DBMGUI).

Yes, I used DBMGUI.

>If you have no log backups of your database you can not recover more data 
>than you did. Though I'm a bit surprised, that the restored data is old 
>some months.

I was also surprised.  Obviously I made a big mistake by erasing the log 
file.

>What does dbm.knl state about your backup?

It seems to show a backup from about two months ago.  I attached a copy of 
the file, although I understand there is really nothing you can do at this 
point.

>As you are looking for scripts stored in the database - if they were stored 
>as text, you could try to simply search for them (or some keywords) on the 
>data volume(s) using a good editor.

I have tried this.  They seem to have disappeared completely from my 
machine.  I guess I should be more careful next time.

In any case, thanks very much for your help.

Kristian






>-----Ursprüngliche Nachricht-----
>Von: krispsu@xxxxxxxxxxx _ [mailto:krispsu@xxxxxxxxxxx]
>Gesendet: Dienstag, 15. März 2005 18:49
>An: maxdb@xxxxxxxxxxxxxxx
>Betreff: Recovery-data lost
>
>Hello Tilo,
>
>Thanks a bunch for replying to my post.
>
>In response to your suggestion below, I performed a backup from the broken
>database instance.  Then I copied the backup file into the working 
>directory
>of a new database instance.  And from the new instance I performed a
>restore.
>
>It worked, but it only recovered information from up to several months ago.
>Should I assume that the data is lost?  All I really need are some SQL
>scripts that I saved.  Can I somehow retrieve these or is it hopeless?
>
>Thanks again,
>Kristian
>
>
>
>Hello Kristian,
>
>Maybe you can bring the db into ADMIN mode and create a complete data
>backup? You could
>then restore that backup into your new instance. Which data and from what
>point in time
>you recover by this depends on the last savepoint written by your original
>database.
>Usually a savepoint is written every 10 minutes.
>
>Best regards,
>Tilo Heinrich
>SAP Labs Berlin
>
>-----Ursprüngliche Nachricht-----
>Von: krispsu@stripped _ [mailto:krispsu@stripped]
>Gesendet: Montag, 14. März 2005 18:41
>An: maxdb@stripped
>Betreff: MaxDB crash. Need to transfer data to new instance.
>
>Hello,
>
>My MaxDB instance crashed.  I tried to fix it, but made it worse by
>accidentally deleting Log_001.  Now the instance won't start.  So my best
>solution is probably to configure a new instance and import the data
>dictionary and application data from the old instance.  How can I do this?
>
>Your suggestions would be greatly appreciated.
>
>Kristian
>
>
>
>--
>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