[Info-Ingres] Info-Ingres] Ingres Service Problem when Cloning Database to VMWare Server

[Jean-Pierre Zuate]

Hello,

Your issue is not (yet) how to port a database from a machine to an other
but how to start Ingres in the cloned environment ...

When you clone your VMWare, how was Ingres ? Running or not ? If it was
running, it can be normal to not start recovery due to log file failure. Try
to reformat log file on the cloned vmware ... you will loose the last
pending transaction on this database, and perhap's get an inconsistant db
but you don't care due to your friday checkpoint.

Did the machine name (in the cloned environment) change ? If yes, adapt your
config.dat, protect.dat and see in symbol.tbl

Hope this help
Jean-Pierre
2007/4/4, Phil Hudson <diab434 at hotmail.com>:
>
> Hello,
> We have a problem trying to start the Ingres Service on a cloned Windows
> 2003 Server with Ingres 2.6 sp2 database.
>
> The reason for cloning was that we lost power to the computer room over
> the
> weekend, and some important end of month jobs that should run
> automatically
> on the last day of each month were therefore not run, and not noticed
> until
> yesterday.
>
> We decided to clone the database server to an esx VMWare Virtual Server,
> including the last full checkpoints taken on the Friday evening. We
> configured the cloned Server as internal, not on LAN so that there would
> be
> no conflicts. The idea was then to rollforward the live database on the
> cloned Server from the Friday checkpoints, run the missing jobs, and copy
> back the output files from these jobs onto a normal LAN configured Server
> for printing.
>
> Seemed to be a good idea, but unfortunately we cannot start the Ingres
> Service on the cloned Server.. it always hangs up when trying to start the
> Ingres Recovery Server.
>
> Has anyone faced a similar problem, and knows why the Recovery Server
> should
> hang? Or has anyone found a different way around the problem of recreating
> a
> database from an old checkpoint without endangering the live database?
>
> We have a test database, that is identical to the live one, but is on the
> same Windows Server, and I believe that there are risks when rollforward
> is
> used on one database using a checkpoint from another database when both
> are
> on the same Server. Otherwise that would be a good option to try.
>
> Many Thanks for any help or advice,
> Phil
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>



-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070404/c5c1783e/attachment.html