Hi all,
IDS11.50FC7 (SLES10.3), we have nightly job of production server
ontape -s -L 0 -d (25minutes) then the file is moved to 2nd IDS
instance on our development machine and then restored there using
ontape -r -d (recently this restore takes much longer than it was few
weeks ago). It's worth adding here that the 'clone' instance of
production on the development IDS instance is not used for day to day
work - it's there for some data checks (SELECTs on a day-old data
etc.). The difference I've noticed since (or at least that's the only
relation I see) we've upgraded 11.10 -> 11.50FC7 that ontape -r -d
salvages the log files before the cold restore now - don't see it in
logfiles before the upgrade. Could some one confirm that the solution
here would be to only switch ontape -r to ontape -p?

No. Ontape -p is for making a physical restore in order to initiate an HDR
or RSS secondary server. It does not perform any logical log restore or
rollforward because it expects that the logs will be transferred from the
primary server directly once HDR or RSS has been established. It leaves the
server in an inconsistent state that's difficult to recover from except by
doing a logical log restore (ontape -l) afterwards. You can try that
combination, however, and see if the total restore time is any better.
You'd have to archive all of the logical logs since the start of the archive
and restore them immediately after the ontape -p completes and before
shutting down the instance. Once the logs have been restored you will have
to force the instance to complete fast recovery by running an onmode -m and
waiting for the engine to come fully online before it will be safe to bring
the engine offline or to use it.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Thu, Jul 22, 2010 at 7:00 AM, Waldemar Znoinski <wznoinski (AT) gmail (DOT) com>wrote: