RE: IDS 7.31: Backing up logical logs to disk
Posted in 2000
Topics: Backup & Restore, Logging & Checkpoints, Versions, Editions & End-of-Life, Jobs, Consulting & Announcements
This is not 100 percent true. onbar can do a physical restore,
then a logical restore using ontape and the logical logs.
But, it does require more set-up and work for a restore.
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Peter Dzvonyar [mailto:peter.dzvonyar@ops.de]
Sent: Thursday, May 11, 2000 7:50 AM
To: informix-list@iiug.org
Subject: Re: IDS 7.31: Backing up logical logs to disk
Hi Murray,
If I correctly understand your script you mix onbar and ontape: onbar for
backup
and ontape for logical log backup. This cannot work! Those two utilities
work
with different data format, so you will not be able to restore your
database!
Have you ever tested it?
Regards
Peter
--
Peter Dzvonyar
SAP-Consultant R/3 BC
_______________________________________________________________
email: Peter.Dzvonyar@ops.de p.dzvonyar@t-online.de
_______________________________________________________________
"Martin, Wayne E." schrieb:
> This is not 100 percent true. onbar can do a physical restore,
> then a logical restore using ontape and the logical logs.
>
> But, it does require more set-up and work for a restore.
>
> Wayne E. Martin
> Informix Database Administrator
> Kmart Corp.
I have to doubt it. If you make a database backup with onbar, finally the
logical logs are also backed up. These logical logs cannot be backed any more,
ontape will not have them. If you make a physical restore with onbar the
database is restored as far as the point where the first logical log file
began to be backed up with onbar. But you can not restore this log with ontape
because it has not it. These logs can be reloaded only with onbar.
Regards
Peter
--
Peter Dzvonyar
SAP-Consultant R/3 BC
_______________________________________________________________
email: Peter.Dzvonyar@ops.de p.dzvonyar@t-online.de
_______________________________________________________________