RE: Ontape question

Correct. ontape restoration must start with a level zero restore, and will over-write any existing data, followed by any level 1 or 2 restores and finally roll-forward of logical logs. No way around this. You 'could' respond Y at the end of the first set of logical logs, leave the server in this condiditon until the next logs are available and then apply them, but the engine would not be available for any other use during this time. HDR is your friend. Keith -> -----Original Message----- -> From: dawaves [mailto:dawaves@gmail.com] -> Sent: Friday, July 21, 2006 4:02 PM -> To: informix-list@iiug.org -> Subject: Re: Ontape question -> -> -> Is HDR available on Informix-Online Version 7.24.UC3? -> -> So it seems like there is no way of directly going to the logical log -> tape to recover the logical logs? I have to do "ontape -r", wait for -> the hour for the DLT to finish, then proceed to the logical log tape, -> right? -> -> thanks! -> -> -> scottishpoet wrote: -> > You need to look at High Availability Data Replication (HDR) and -> > similar disaster recovery strategies -> > -> > you are basically implementing this manually at the moment -> > -> > -> > dawaves wrote: -> > > Hello, -> > > -> > > On June 15 I posted: -> > > -> > > When I run 'ontape -r', it asks me if I want to restore -> from an archive -> > > tape (an 8mm tape) after restoring from level0 backup (a -> DLT tape). Is -> > > there any way to just go straight to that 8mm tape for -> restore and -> > > bypass the hour I have to wait for the level0 restore to complete -> > > before getting the prompt for archive tape restore? -> > > -> > > -> > > As a followup, I guess I wasn't too clear. I have a -> Production Server -> > > and a Backup Server. On the Production Server, I run -> 'ontape -c' all -> > > day that backs up logical logs as they get written to my -> 8mm tape. At -> > > the end of the day, I run a level0 (ontape -s -L 0) -> backup that backs -> > > up everything to my DLT tape. I then use these 2 tapes -> to restore to my -> > > Backup Server everyday in case our Production Server goes down. -> > > -> > > Here are the steps I take on the <STRONG>Backup Server</STRONG>: -> > > 1) I insert DLT tape from Production Server into Backup Server -> > > 2) I run 'ontape -r' on Backup Server -> > > 3) it prompts me: 'continue restore (y/n)?'. I hit "y" -> and "Enter". -> > > 4) it prompts me: 'backup logical logs (y/n)?'. I hit -> "y" and "Enter" -> > > 5) I then have to wait an hour for my level0 backup on -> my DLT tape -> > > drive to finish -> > > 6) I then get a prompt: 'Level1 restore (y/n)?'. I hit -> "n" and "Enter". -> > > 7) I then get a prompt: 'restore logical logs (y/n)?'. I -> hit "y" and -> > > "Enter". -> > > 8) This is where I put in my 8mm Logical Log tape from -> my Production -> > > Server into the Backup Server. -> > > 9) The logical logs from the 8mm get written to the Backup Server -> > > 10) Now the Production Server and Backup Server are -> identical in terms -> > > of data. -> > > -> > > My question is this: I don't want to wait the hour on -> point 5 from the -> > > list above. I want to be able to restore logical logs -> from the 8mm w/ a -> > > command. Is there a command I can run taht will allow me -> to restore -> > > logical logs from the 8mm tape drive on my Backup Server? -> > > The reason is I am writing a script to automate all this. -> > > -> > > Thanks! -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> *********************************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ***********************************************************************************************