Re: Informix backup/archives
On Fri, 10 Oct 1997, Allen Jantzen wrote:
} Art S. Kagel wrote:
}
} > BTW and FYI I recently did a warm restore from an Archive taken on one
} > machine to its sister machine. It worked great! One caviat: you
} > cannot
} > safely roll forward the logs when you do this because the logs on the
} > two machines are unlikely to be identical and you may do more harm
} > than
} > good and if the log numbers are different then ontape will refuse to
} > do
} > it. The dbspaces restored are left marked inconsistent but Informix
} > Support can mark them up and they will actually be consistent just not
} > up-to-date beyond the start of the archive.
}
} Thats interesting. I wondered why the restore process asks you whether
} you want to roll forward when, if you don't, the chunk is just marked
} inconsistent and doesn't go back online. So in this case you would
} call Tek Support and they can bring the inconsistent chunk back online?
}
} So this means that an inconsistent chunk has nothing wrong with it
} except that it has had no logs rolled forward on it??
Correct. Since a checkpoint is forced by the Archive at its start the
dbspaces are consistent for the Archive and copying the Physical Log
preimages guarantees that the dbspaces stay consistent throughout the
Archive.
}
} PS - we do stock market/financial research here. Are you at the
} same Bloomberg company that I'm thinking of???
Yes.
Art S. Kagel, kagel@bloomberg.com