Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Recovering lost data

19 views
Skip to first unread message

Ingres Forums

unread,
Nov 8, 2012, 7:58:29 AM11/8/12
to

Due to fact that data was on USB my Ingres server lost it
I have the original aaaa files. How can I recover the original data
from those ?
If I simply recreate the db and then copy, Visual Dba will never finish
reading it.
I am using ingres 2006
Please help


--
csbened
------------------------------------------------------------------------
csbened's Profile: http://community.actian.com/forum/member.php?userid=116353
View this thread: http://community.actian.com/forum/showthread.php?t=14847

Ingres Forums

unread,
Nov 8, 2012, 8:18:01 AM11/8/12
to

> Due to fact that data was on USB my Ingres server lost it
No, your foolish decision to put the data on a buffered removable medium
lost it.

> I have the original aaaa files. How can I recover the original data from
> those ?
The aaaa* files are your data. It sounds like you haven't lost them.
What have you really lost?

Give us an understandable description of what you've done and maybe
we'll have some ideas.


--
rhann
------------------------------------------------------------------------
rhann's Profile: http://community.actian.com/forum/member.php?userid=131

Ingres Forums

unread,
Nov 8, 2012, 8:20:42 AM11/8/12
to

First it gave me that tables are unavailable . So I made a backup of
ingres/data/default .
Then I deleted and recreated the database and tried to copy back those
aaaa files. Did not work.


--
csbened
------------------------------------------------------------------------
csbened's Profile: http://community.actian.com/forum/member.php?userid=116353

Ingres Forums

unread,
Nov 8, 2012, 8:23:22 AM11/8/12
to

I mean I am trying to create a database using the original files on the
ingres/data/default/aaa*
Is there a way to do that ?

Ingres Forums

unread,
Nov 8, 2012, 9:19:32 AM11/8/12
to

> I deleted and recreated the database and tried to copy back those aaaa
> files. Did not work.

OK , that's quite a lot different than what you first wrote.

There are ways to do that kind of thing but you need to have prepared
for it in advance.

Unfortunately I doubt Ingres was shut down cleanly before the USB device
was unplugged so your backup is probably corrupt anyway. Ingres buffers
changes in memory and writes them at intervals, and when it does, it
write everything not just the committed updates. You need to take your
backup using the checkpoint utility (ckpdb) so you can restore just the
committed updates from the archive.

I don't think I can give you much reason for optimism about recovering
this particular database this time. You should destroy it, recreate the
tables, and reload the data from scratch.

In future, as I say, you can recover a damaged database but you need to
do it using the tools provided for the purpose. You will find a lot of
useful information in the 'Backup and Recovery'
(http://docs.actian.com/ingres/9.2/database-administrator-guide/1846-performing-backup-and-recovery)
chapter of the DBA Guide.

I'm sure there's no need for me to labour the point about not using USB
drives for a database.


--
rhann
------------------------------------------------------------------------
rhann's Profile: http://community.actian.com/forum/member.php?userid=131

Jean-Pierre Zuate, La Fage Conseil

unread,
Nov 8, 2012, 9:31:29 AM11/8/12
to Ingres and related product discussion forum
Hello Mr Doe,

creating a database (same name, locations name and path, etc) a copying old version files work, even if it's not supported.

I hope for you data was not updated during their USB period (insert, update, delete) ...

Perhaps try that :
- createdb : same name, same location name, but differents areas (not usb one)
- copy files from your backup to data location except aaaaaaaa.cnf one (it contain links with location name AND areas)
- try SELECT on some tables (and pray)

If SELECTs works, quickly try :
1/ to a ascii unloaddb your database (unloaddb -c)
2/ unload.ing your data 
3/ reload them in a proper way (and forget playing with real data)

If you have errors during unloaddb : maybe your data are lost
If you have errors during unload.ing : table concerned by errors are lost, totally or partially ...

Hope this help ... :)

2012/11/8 Ingres Forums <info-...@kettleriverconsulting.com>
_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres

0 new messages