dbTalk Databases Forums  

Re: [Info-Ingres] FW: Recover checkpoint toserver with different locations

comp.databases.ingres comp.databases.ingres


Discuss Re: [Info-Ingres] FW: Recover checkpoint toserver with different locations in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default Re: [Info-Ingres] FW: Recover checkpoint toserver with different locations - 11-29-2011 , 07:08 AM






Hi Karl,

Looks nasty, I'll go for the 'brute force and bloody ignorance' option...which has always been a personal favorite.

A simple program can scan for the known old paths and then substitute them for new paths (correctly padded to width).

I'll recode my recovery application and see what explodes this time.

Marty

-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 29 November 2011 11:58
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] FW: Recover checkpoint to server with different locations


On Nov 29, 2011, at 5:30 AM, Martin Bowes wrote:

Quote:
Hi All,

Yes a table/index create has a hard coded path in it...
I never understood why the server uses hardcoded paths anywhere, after going
to all the trouble of doing location support. I'm going to fix that before I die. :-)
(and it might take that long...)

Quote:
So it appears that I need to edit the dumps/journals as well.

Rather than decode the blasted journals with od does anyone know where I can find the journal file descriptions?
As far as I know, the journals are the same as the transaction log.
There might be a header of some kind, I'm not sure. The log record
definitions are in back/dmf/hdr/dm0l.h. The low level journal
file readers are in cl/clf/jf_unix_win/jf.c and in back/dmf/dmp/dm0j.c
(the JF routines are the CL equivalent of read() and write(), and
the dm0j routines give you read-a-record.)

Karl



_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.