Re: Ontape question
- From: "dawaves" <dawaves@xxxxxxxxx>
- Date: 21 Jul 2006 09:10:30 -0700
hmmmm....interesting proposition Simmons, Keith....since this is just a
Backup Server doing nothing but sitting there waiting for Production to
die, I could do leave it in a state of waiting for the next set of
logical logs.....interesting...
wow you guys are super. I'm kinda new to informix and really appreciate
the professional responses and assistance.
thanks!
Madison Pruet wrote:
dawaves wrote:
Is HDR available on Informix-Online Version 7.24.UC3?
HDR was first released with Version 6.
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!
.
- Follow-Ups:
- Re: Ontape question
- From: Clive Eisen
- Re: Ontape question
- References:
- Ontape question
- From: dawaves
- Re: Ontape question
- From: scottishpoet
- Re: Ontape question
- From: dawaves
- Re: Ontape question
- From: Madison Pruet
- Ontape question
- Prev by Date: Re: Ontape question
- Next by Date: Re: 668 System command cannot be executed - 1: Not owner
- Previous by thread: Re: Ontape question
- Next by thread: Re: Ontape question
- Index(es):
Relevant Pages
|
|
