OnBar & Ontape
Steven asked whether he could take archives with ON-Bar but back up/roll forward logical logs with ontape. Most respondents said no: the two tools track backup information separately, so you must use one or the other; mixing them would leave you with only a physical restore and dbspaces needing to be marked consistent by support. One poster noted ON-Bar's -w (whole) backup avoids restoring logs manually, and another suggested third-party XBSA tools. However, Martin reported having successfully done an ON-Bar physical restore followed by an ontape logical restore, while admitting he may have been lucky and advising testing. No definitive resolution.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
On Fri, 08 Oct 1999 15:45:20 -0700, Steven Lee
<stevenl@eds-bridge.com> wrote:
>Hi,
>Just wondering is it possible to archive using OnBar, and the logical
>logs to be done by ontape?
>
>In times of restoration, OnBar to restore the archive, followed by
>ontape for rolling forward transactions.
>
>Thanks
>Steven
No you cannot.
Steven,
NO, you cannot mix Onbar and Ontape. You must use one or the other not
both. The information of what
has been archived is stored in different locations. If you were to do
what you described, the best you could
hope for if you had to restore would be to do a physical restore, then
have tech support dial-in to you system
and mark all you dbspaces consistent. You would not be able to apply any
logical logs.
Greg
Steven Lee wrote:
> Hi,
> Just wondering is it possible to archive using OnBar, and the logical
> logs to be done by ontape?
>
> In times of restoration, OnBar to restore the archive, followed by
> ontape for rolling forward transactions.
>
> Thanks
> Steven
Or buy a third party product for use instead of the informix Onbar, like e.g. SQLBacktrack for Informix (BMC). This tool also uses the Informix XBSA interface, but allows backup and restore of logical database objects like databases and tables, and not only physical dbspaces. It also backs up and restores the corresponding database schema. Christoph
Greg Dewinter wrote in message <37FDDF05.9055DCA2@spf.fairchildsemi.com>...
>Steven,
>
>NO, you cannot mix Onbar and Ontape. You must use one or the other not
>both. The information of what
>has been archived is stored in different locations. If you were to do
>what you described, the best you could
>hope for if you had to restore would be to do a physical restore, then
>have tech support dial-in to you system
>and mark all you dbspaces consistent. You would not be able to apply any
>logical logs.
With Onbar you can do a physical restore without restoring the logical logs
yourself, if the database was backed up with the -w switch (whole backup).
Drawback is that you cannot stream to multiple tape devices with the -w
switch. Either way, you still cannot restore the logs from an ontape
backup.
Scott Kolaya
>
>Greg
>
>Steven Lee wrote:
>
>> Hi,
>> Just wondering is it possible to archive using OnBar, and the logical
>> logs to be done by ontape?
>>
>> In times of restoration, OnBar to restore the archive, followed by
>> ontape for rolling forward transactions.
>>
>> Thanks
>> Steven
>
Hi,
Just wondering is it possible to archive using OnBar, and the logical
logs to be done by ontape?
In times of restoration, OnBar to restore the archive, followed by
ontape for rolling forward transactions.
Thanks
Steven
Steven Lee wrote:
>
> Hi,
> Just wondering is it possible to archive using OnBar, and the logical
> logs to be done by ontape?
>
> In times of restoration, OnBar to restore the archive, followed by
> ontape for rolling forward transactions.
>
> Thanks
> Steven
Contrary to the answers recieved so far. I believe you can
do this. Or, maybe I just got lucky (yes, i did do this successfully).
After a physical restore via onbar, start a logical
restore with ontape.
Why wouldn't you be able to do this? Whether you do your
physical restore with ontape or onbar, the instance ends
up in the same state, waiting for logical restore.
A caveat....test it. Maybe I really just got lucky once.
BTW, I don't do this anymore. I'm using onbar for both
logs and archives now.
-Martin
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Martin Birecki
DHL Airways Inc.
Email: mbirecki@us.dhl.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I guess the question for me is not 'Can I?' but rather 'Why would I even
want to???'
Doug
Martin Birecki wrote in message <38016A10.991283B8@us.dhl.com>...
>Steven Lee wrote:
>>
>> Hi,
>> Just wondering is it possible to archive using OnBar, and the logical
>> logs to be done by ontape?
>>
>> In times of restoration, OnBar to restore the archive, followed by
>> ontape for rolling forward transactions.
>>
>> Thanks
>> Steven
>
>Contrary to the answers recieved so far. I believe you can
>do this. Or, maybe I just got lucky (yes, i did do this successfully).
>
>After a physical restore via onbar, start a logical
>restore with ontape.
>
>Why wouldn't you be able to do this? Whether you do your
>physical restore with ontape or onbar, the instance ends
>up in the same state, waiting for logical restore.
>
>A caveat....test it. Maybe I really just got lucky once.
>BTW, I don't do this anymore. I'm using onbar for both
>logs and archives now.
>
>-Martin
>
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>Martin Birecki
>DHL Airways Inc.
>Email: mbirecki@us.dhl.com
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-