recover from a bad disk

FAQ

Profile

recover from a bad disk

Database Help (Home) -> Ingres

Next: report writer

Author

Message

Zhiliang Hu

External

Since: Aug 22, 2008
Posts: 4

(Msg. 1) Posted: Fri Aug 22, 2008 7:44 am Post subject: recover from a bad disk Archived from groups: comp>databases>ingres (more info?)

We have an Ingres installation on a Digital Unix 4.0, with 2 drives: Disk A: /local/ingres Disk B: /local/ingres/data Lately Disk B went bad. I created "/local/ingres/data" on Disk A and recovered the data from backup take into this location. File/owner permissions are set as before (owned by ~ingres and have directories 700 and files 600). Then I restarted the Ingres DBM. Now when I try to get to db it complains: "E_US002B Could not open the iidbdb database" Any hint what this could be and how shall I get it to work? Thanks in advance! Zhiliang >> Stay informed about: recover from a bad disk

ghingres

External

Since: Feb 05, 2008
Posts: 5

(Msg. 2) Posted: Fri Aug 22, 2008 12:59 pm Post subject: Re: recover from a bad disk [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi Zhiliang Good old Alpha Unix - most important thing is you have a backup First login as ingres and have a look at the file ~/files/ errlog.log (%II_SYSTEM%/ingres/files/errlog.log) In here you will see a more detailed reason as to why the system cannot open the iidbdb database. This should be your first point of call in diagnosing what is wrong with the system. The command infodb may also display further information. I'm wondering if you've got an error of inconsistent database or something - but first we need to know what your errlog.log file contains. Post that information and people can give you more pointers. Cheers Gary >> Stay informed about: recover from a bad disk

Zhiliang Hu

External

Since: Aug 22, 2008
Posts: 4

(Msg. 3) Posted: Fri Aug 22, 2008 5:37 pm Post subject: Re: recover from a bad disk [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Nice to know someone else are also using Ingres/Alpha machines. Never realize error logs are in /files/, not in /log/, something learned Now I figured out by looking at the error log, that I missed out / default/ layer in ~ingres/data/default/iidbdb. Now it's back to life! Many thanks!! Zhiliang On Aug 22, 2:59 pm, ghing....TakeThisOut@yahoo.co.uk wrote: > Hi Zhiliang > > Good old Alpha Unix - most important thing is you have a > backup > > First login as ingres and have a look at the file ~/files/ > errlog.log (%II_SYSTEM%/ingres/files/errlog.log) > > In here you will see a more detailed reason as to why the system > cannot open the iidbdb database. This should be your first point of > call in diagnosing what is wrong with the system. The command infodb > may also display further information. I'm wondering if you've got an > error of inconsistent database or something - but first we need to > know what your errlog.log file contains. Post that information and > people can give you more pointers. > > Cheers > > Gary >> Stay informed about: recover from a bad disk

Roy Hann

External

Since: Jul 08, 2008
Posts: 50

(Msg. 4) Posted: Tue Aug 26, 2008 2:39 am Post subject: Re: [Info-Ingres] Ingres equivalent of Memo Field [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Phil Hudson wrote: > Hello, > Could someone please tell me what the Ingres equivalent of Memo field is? > We need a text field to contain notes of up to any length, accepting that it will not be searchable. LONG VARCHAR maybe? -- Roy UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009 Go to http://www.iua.org.uk/join to get on the mailing list. >> Stay informed about: recover from a bad disk

Roy Hann

External

Since: Jul 08, 2008
Posts: 50

(Msg. 5) Posted: Tue Aug 26, 2008 2:45 am Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Phil Hudson wrote: > Hello again, > Has anyone experienced running an Ingres database on a Virtual Server (in our case Windows 2003) in a VMWare environment on an ESX Server? > I guess that it must have pros and cons.. can anyone give their experience or recommendations please? I've not got a live production system running on VMWare, but it is certainly a promising idea, as this somewhat related posting points out: http://groups.google.com/groups?as_umsgid=578de3e9-de80-45eb-99c3-cf15...a0446@2 -- Roy UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009 Go to http://www.iua.org.uk/join to get on the mailing list. >> Stay informed about: recover from a bad disk

Michael Leo

External

Since: Jan 23, 2008
Posts: 15

(Msg. 6) Posted: Tue Aug 26, 2008 6:44 am Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Phil, I have the following experience: - Development Ingres installations (2006) on a VMWare virtual machine running Windows 2000/2003R2 and 64-bit RedHat 5.0 (Linux) - Development Oracle installation on a VMWare virtual machine running Linux I haven't run a production Ingres or Oracle server on a VMWare virtual machine. Most of my production servers are heavily I/O oriented, an the whitepapers I've read about running I/O intensive SQL Servers on virtual machines haven't been glowing. I guess it depends on - the iron you run it on - how much performance you need - your I/O platform. A good NetApp properly provisioned on the back end will help immensely Cheers, Mike Leo Phil Hudson wrote: > > Hello again, > Has anyone experienced running an Ingres database on a Virtual Server > (in our case Windows 2003) in a VMWare environment on an ESX Server? > I guess that it must have pros and cons.. can anyone give their > experience or recommendations please? > Many Thanks, > Phil >> Stay informed about: recover from a bad disk

Michael Leo

External

Since: Jan 23, 2008
Posts: 15

(Msg. 7) Posted: Tue Aug 26, 2008 9:32 am Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

That is pretty neat! I have been trying to find a way to gain some time. 7 hours a week would be great! "Would I be taxed on it?" is the obvious next question ... Andrew wrote: > Hi All, > > Side-issue... > > Has anyone heard of systems under vmware environments gaining time? > > Ingres is running fine, just SuSE linux running in a vmware set up is > gaining about an hour a day. > > Regards, > Andrew. > > _______________________________________________ > Info-Ingres mailing list > Info-Ingres.TakeThisOut@kettleriverconsulting.com > http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres > >> Stay informed about: recover from a bad disk

Martin Bowes

External

Since: Feb 05, 2008
Posts: 17

(Msg. 8) Posted: Tue Aug 26, 2008 2:00 pm Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi Andrew, No I havent seen that on any of the Virtual environments we've set up. All have been RedHat. Marty -----Original Message----- From: info-ingres-bounces DeleteThis @kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Andrew Sent: 26 August 2008 13:41 To: Ingres and related product discussion forum Subject: Re: [Info-Ingres] Ingres with VMWare Hi All, Side-issue... Has anyone heard of systems under vmware environments gaining time? Ingres is running fine, just SuSE linux running in a vmware set up is gaining about an hour a day. Regards, Andrew. _______________________________________________ Info-Ingres mailing list Info-Ingres DeleteThis @kettleriverconsulting.com http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres >> Stay informed about: recover from a bad disk

Martin Bowes

External

Since: Feb 05, 2008
Posts: 17

(Msg. 9) Posted: Tue Aug 26, 2008 3:47 pm Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

No Taxes, but the Cows don't like gaining 1 hour so I can't see them enjoying 7! Marty -----Original Message----- From: info-ingres-bounces.RemoveThis@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Michael Leo Sent: 26 August 2008 15:32 To: Ingres and related product discussion forum Subject: Re: [Info-Ingres] Ingres with VMWare That is pretty neat! I have been trying to find a way to gain some time. 7 hours a week would be great! "Would I be taxed on it?" is the obvious next question ... Andrew wrote: > Hi All, > > Side-issue... > > Has anyone heard of systems under vmware environments gaining time? > > Ingres is running fine, just SuSE linux running in a vmware set up is > gaining about an hour a day. > > Regards, > Andrew. > > _______________________________________________ > Info-Ingres mailing list > Info-Ingres.RemoveThis@kettleriverconsulting.com > http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres > _______________________________________________ Info-Ingres mailing list Info-Ingres.RemoveThis@kettleriverconsulting.com http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres >> Stay informed about: recover from a bad disk

Grant Croker

External

Since: Feb 20, 2008
Posts: 4

(Msg. 10) Posted: Tue Aug 26, 2008 5:10 pm Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi Andrew, I have seen this and a system lose time, but only with VMware GSX/Server not on ESX. In theory you can set the kernel options in the guest to include clock=pit however the system that is losing time has this set (AMD 64 running a 32bit SuSE VM). http://support.microsoft.com/kb/918461 shows how you change this for the Grub and LILO boot managers. regards grant On 26/08/2008 14:41, Andrew wrote: > Hi All, > > Side-issue... > > Has anyone heard of systems under vmware environments gaining time? > > Ingres is running fine, just SuSE linux running in a vmware set up is > gaining about an hour a day. > > Regards, > Andrew. > > _______________________________________________ > Info-Ingres mailing list > Info-Ingres DeleteThis @kettleriverconsulting.com > http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres > >> Stay informed about: recover from a bad disk

Andrew

External

Since: Jan 15, 2008
Posts: 5

(Msg. 11) Posted: Tue Aug 26, 2008 10:41 pm Post subject: Re: [Info-Ingres] Ingres with VMWare [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi All, Side-issue... Has anyone heard of systems under vmware environments gaining time? Ingres is running fine, just SuSE linux running in a vmware set up is gaining about an hour a day. Regards, Andrew. >> Stay informed about: recover from a bad disk

Display posts from previous:

Related Topics:

Anyone using Plone with Ingres? - I'm currently playing about with Plone and Ingres (i.e. I have created a ZODB that is stored in an Ingres database). I am curious to know who else is. Roy

Windows Server 2003 Ingres Net Problems - Gday, I am running Ingres Net (version 2.6 SP2) on a Windows Server 2003 box with ODBC Driver version 3.50.00.32 and am having some problems with stability. Essentially the problem is that I get a random Ingres ODBC error ERROR [HY000] [CA][Ingres ODBC...

ODBC error message: Unable to authenticate client's user ID - Hi list, we have two machines: 1. Suse Linux with Ingres 2.6 SP2 DBMS 2. Win 2000 Server with IngresNet (client-only) 2.5 The Win 2000 box starts a Borland-Delphi-app that connects via ODBC, unfortunately this fails. Errlog.log on the Windows machine....

Ingres with PHP - Hallo, sorry for my bad english. I need to use IIS/PHP/Ingres, but it does not work. Do you know the exactly way to use Ingres with PHP?

Is there a way to allow ambiguous replace on update? - Ingres 2.6 HP-UX 11.11 Is there a way to temporarily turn on ambiguous replace on update with the use of one of the set trace points? Ambiguous replace used to work in earlier versions of ingres, and I understand it's generally not a good thing and....

	Database Help (Home) -> Ingres	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum