Informix Restore Tape question
Posted in 2007
Topics: Platform-Specific Issues
Hello,
I have a Production Informix System running 7.24.UC3 on AIX 4.3.3. I
run "onstat -s -L 0" every night to my rmt1 tape drive.
I am setting up another system just so I have a physical backup server
in case the Production dies.
When I restore the database on the backup system, it wants a second
tape after about an 1 hour of restoring. Now on my Production Server,
I don't backup up to a second tape, there is only one tape.
Why is it asking me to put in a second tape drive?
thanks!
dawaves wrote:
> I have a Production Informix System running 7.24.UC3 on AIX 4.3.3. I
> run "onstat -s -L 0" every night to my rmt1 tape drive.
>
> I am setting up another system just so I have a physical backup server
> in case the Production dies.
>
> When I restore the database on the backup system, it wants a second
> tape after about an 1 hour of restoring. Now on my Production Server,
> I don't backup up to a second tape, there is only one tape.
>
> Why is it asking me to put in a second tape drive?
>
> thanks!
>
1) I assume you mean ontape -s -L 0
2) how do you run the ontape on your production server - in a script
and/or with cron?
3) are you SURE TAPEDEV in your onconfig points to /dev/rmt1 or
whatever, and not /dev/null?
--
Clive
On Feb 5, 7:47 am, Clive Eisen <c...@serendipita.com> wrote:
> dawaves wrote:
> > I have a Production Informix System running 7.24.UC3 on AIX 4.3.3. I
> > run "onstat -s -L 0" every night to my rmt1 tape drive.
>
> > I am setting up another system just so I have a physical backup server
> > in case the Production dies.
>
> > When I restore the database on the backup system, it wants a second
> > tape after about an 1 hour of restoring. Now on my Production Server,
> > I don't backup up to a second tape, there is only one tape.
>
> > Why is it asking me to put in a second tape drive?
>
> > thanks!
>
> 1) I assume you mean ontape -s -L 0
> 2) how do you run the ontape on your production server - in a script
> and/or with cron?
> 3) are you SURE TAPEDEV in your onconfig points to /dev/rmt1 or
> whatever, and not /dev/null?
>
> --
> Clive
Thanks for the responses!
DC:
1.Yes they are large enough
2. No they are not the same on the server.
Errr....the TAPESIZE on my Production Server is 70000000 (70GB),
The TAPESIZE on my backup Server is 35000000 (35GB)
I will make the changes on my backup Server ONCONFIG file to match
that of the Production Server. Hopefully that works.
Clive:
1. Yes you are absolutely right: "ontape -s -L 0" : full archive of
instance
2. Yes it is run from a script that get's run by cron
3. Yes ONCONFIG points to /dev/rmt1
Thanks guys for your comments!