Re: Ontape -r asking for non-existent tape 2

Andrew <andrew.gothard1@ wrote: > IDS 9.21 > Windows 2000 Advanced Server sp2 > > Brief history of whine > Use Informix as backend to BaaN ERP system. > Backend to BaaN ERP > > Restored live onto test server (approx 216 Gb) > > Did a bit of work, including testing dropping some data in reporting tables > as that's now been moved to (SQLServer) datawarehouse (Oh, the flames, the > flames) which reduced the amount of used space quite significantly. > > Then did some buggering about with the blocksize on the backup (changed from > 16 to 1024 in stages to see if it noticibly improved backup times. Seemed > to), looked at reducing fragmentation in small table trivial test kind of > way. > > Backup is to a disc file on the same server. Live and test environments are > an almost exact copy of each other (other then BaaN configuration issues). > > Obviously, next stage is to test the restore, which I'd assumed would be a > no brainer. Turned out it was, but not in the way I'd expected. > While the backup looked sweet, finished OK - no errors or issues I can see - > it gets to a point in the restore when it asks for a tape 2. There are a few reason for the ontape process to ask for another tape. ontape encountered an EOF while reading, TAPESIZE was encountered (even if using a disk file). 1. The first thing to do is to check the disk file size against the TAPESIZE paramater in your onconfig. 2. Validate the archive using the archecker utility. If this utility indicates that all data is there then it can be restored even if ontape is currently not restoring the data correctly. Hope this helps, John > > Now - given that the restore is from a backup to a single disc file, and > that's from a backup to the same single disc file - I find that surprising. > Obviously - there is no tape 2. I *could* <Ctrl - C> but as fate would have > it we've had expensive consultants doing expensive stuff - and > communications breakdown is an unpopular phrase with senior management > expecting a demo. > > Question is - is it hosed - or is there a retrieval mechanism anyone here > can give me? All I know is that any time I've stopped a restore > inappropriately (it's happened - we do about 4-6 test DR's a year) - it's > back to square one. Suspect that square one this time's going to bring me > to the same problem point. > > Anyway, any advice welcome, if it saves my job you may even get an invite to > my wedding. If you put it on e-bay you die. > >