Re: Level - 0 Restore problems
We use ontape to regularly duplicate production systems to separate test
machines for development/testing/QA, etc. Is it possible to take an onbar
backup created on host A and restore it to host B (assuming all the
necessary disk devices and links are set up to accommodate all the chunks
contained in the backup)?
Thanks,
Steve Murray, Senior DBA
Assocated Grocers, Inc
Seattle, WA
"Art S. Kagel" <kagel@bloomberg.net> on 06/13/2000 06:21:56 AM
Please respond to kagel@bloomberg.net
To: informix-list@iiug.org
cc: (bcc: Stephen Murray/AGInc)
Subject: Re: Level - 0 Restore problems
Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.
Watawinona@aol.com wrote:
>
> Mark,
>
> we could talk in deep, dark tones about why a level 0 from one machine to
> another is not a good idea. And many a newbie tries that now and then,
and
> fails just as the idiots before him.
>
> There are other, more suitable tools designed just for that purpose. So
use
> them. And don't wolf about things you don't know anything about.
Sorry Nona, there is nothing inherently BAD or 'bad idea' about restoring
from one machine to another. Indeed I depend on that capability to
maintain a sane backup strategy in the face of servers that take over 24
hours to archive. We archive sister machines on a rotating schedule so
that
I always have a current level 0 from one and level 0 plus level 1 from the
other. I keep the disk layouts compatible (I try to keep them identical
but that never seems to work) so that I can restore one set to the other
machine if that is the faster solution holding the two tape set restore in
reserve in case the tapes turn out to be bad. This has worked for me and
for my predecessor for eight years and I'm still working here!
The problem is that the disk layouts have to be compatible, which is easy
if you are running only one instance per machine, meaning all devices are
the same size or if larger on one system that the instance ONLY utilizes
the smaller size on both systems letting the difference go to waste.
Mark is right, and obviously one word to you was not sufficient so here
were a few hundred. Your one liners are not useful or helpful and, unless
appended or prepended to a functional answer, neither appreciated nor cute.
Art S. Kagel