Re: Level - 0 Restore problems

"Art S. Kagel" wrote: > > 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! > Same here. That's how I can cut over a 20G Informix instance in about 4 or 5 hours. Identical logical layouts, all required ONCONFIG parameters are the same, and even using lowly ontape. That's a lot better (and faster) than export / import, even with HPL. > 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. > Agreed. The logical layout compatability is required. > 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. > Unless it actually answers the question . . . . which most didn't. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */