Subject Re: cannot connect to a restored database
Author flpratt
--- In, Nando Dessena <nandod@d...>
> Fred,
> f> If my database contains 50 tables owned by 'owner1' and 100
> f> owned by 'owner2' and 75 tables owned by 'owner3', etc - how
can I
> f> backup/restore so that the tables all have their original
> f> If this is not possible with gbak, it is useless for disaster
> f> recovery.
> Sorry, I completely misunderstood you. I was thinking about the
> database owner, which gbak -c changes AFAIK. I always have a single
> owner for all database objects, so my mindframe is quite biased.
> I'm not sure what restore does of your original owners, but I guess
> you are right and it should preserve them (a simple test would
> unfortunately I am away from any firebird at the moment).
> So, to recap: you had a database in shutdown mode but you don't
> if/when the gfix -shutdown command was issued. Then you brought it
> back on-line but discovered that gbak had changed all your
relation owners
> to the one you used to do the restore, right? Can you reproduce
> with a small sample database? I'm sure the developers would be
> interested.
> Ciao
> --
> Nando mailto:nandod@d...

I am certain that no one issued a gfix -shutdown commmand. Perhaps
a gbak restore leaves the restored database in this state so that
the person doing the restore has a chance to do some single-user
type stuff before the database is brought on-line. I hope this is
the case because the alternative explanation is that there is subtle
corruption the the database and I have only seen the first symptom.
I do plan to do a series of test backup/restores on a much smaller
database in order to better understand what to expect.
We are planning to replace a number of 5 - 20 gb Informix OnLine
5.20 and IDS 7.31 databases with Firebird as soon as we can iron out
wrinkles such as these. I like Firebird very much and hope that we
can re-direct some of our $$$ going to IBM-Informix to the FB