Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Informix database restore

David Tang_3
Occasional Contributor

Informix database restore

Hi all,
Got a real headache wish you guys be able to help.
I have a harddisk in a server that was used as a rawdisk for informix database. In SAM it was shown as not in use so a system admin used that disk to do a mirrorring for vg00.
When it was realised it was too late. Chunk 1 of some database reside in this disk.
Is there anyway to salvage anything from this situation?
4 REPLIES
Rainer von Bongartz
Honored Contributor

Re: Informix database restore

Hope you got your INFORMIX backup tapes at hand !!!!!!!!!!

Mirroring vg00 onto informix chunk has destroyed this chunk and cannot be otherwise restored.

If you did your INFX backups with onbar you can recover the following way:
onmode -ky
onbar -r -p
onbar -r -l

He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
David Tang_3
Occasional Contributor

Re: Informix database restore

Sad to say there is no backup tape...Is there any other way to restore the data?
From the oncfg file, I can see that the database have 4 chunks Chunk 1 and 2 is in the destroyed disk and Chunk 3 and 4 is in another disk mounted as a file system.
Rainer von Bongartz
Honored Contributor

Re: Informix database restore

David,

you definitly lost your chunks 1 and 2 !!!!

whether you can restart your database or not now depends on the contents that were on this chunks.

if your rootdbs (ROOTPATH in $ONCONFIG) was on one of this chunks you are definitly lost.

otherwise you could try to set ONDBSPACEDOWN 0 in your onconfig file

in either case post your online log file , perhaps i can give you some more hints, but dont't expect too much.
I think you have lost your database.
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
David Tang_3
Occasional Contributor

Re: Informix database restore

Thanks for your help..I know that the rootdbs is in the affected disk...guess nothing could be done...Thanks anyway :)