Unix Technical Forum

Re: Clarification on ONBAR restore sequence..

This is a discussion on Re: Clarification on ONBAR restore sequence.. within the Informix forums, part of the Database Server Software category; --> Hypothetically, when you begin the restore, you should have all the information from the Level-0 forward , which includes ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 07:13 PM
Abraham Kirubakaran
 
Posts: n/a
Default Re: Clarification on ONBAR restore sequence..


Hypothetically, when you begin the restore, you should
have all the information from the Level-0 forward ,
which includes the information about level-1. The
engine checks two places, the ixbar file and the
sysutils.bar_* tables. Unless you have them in place,
the backup will very likely fail.
I have done the restore using the "Manipulated" ixbar
file for a full point in time restore, but did'nt have
to use the level-1, which prevents me from affirming
my opinion.

Thksz
Abraham

--- "Rajasekaran, Rajesh"
<RRajasekaran@forestpharm.com> wrote:
> Hi
>
> I would like to clarify regarding the ONBAR
> restore.
>
> I want to perform an alternate client restore.The
> backups are serial whole
> system backup using "onbar -b -w -L 0".I have the
> ixbar file which contains
> only the recent level-0 entries. Assuming that the
> RESTARTABLE_RESTORE is
> enabled, i perform the physical restore with "onbar
> -r -p -w" and the
> database comes to "Fast recovery mode".
>
> At this point, i wanted to restore a subsequent
> level-1. So i will be either
> replacing the ixbar.0 file with another ixbar that
> contains level 1 entries
> or an ixbar which contains both the already restored
> level-0 and the new
> level 1 entries. I now start again the restore
> "onbar -r -p -w" since there
> is no specific command to restore only level 1.
>
> The whole issue is that I can take the level 1
> backup from the source system
> only towards the end time of level 0 restore on
> the alternate client.
> Hence I will not have the updated ixbar (level1)
> entries during the level0
> restore. Hence i got to replace the ixbar and hoping
> to kick off only level
> 1.
>
> 1)Will ONBAR restore only the level 1 ? or Will it
> go back and restore
> level-0 followed by level-1 ?
> 2)Will it restore only level 1 if the newly replace
> ixbar file contains
> only the level1 entries ?
>
> Your suggestions/comments are greatly appreciated.
>
> Rajesh Rajasekaran
> Informix Database Administrator
> Forest Pharmaceuticals Inc.
> 314-493-7073 (Work)
>
> sending to informix-list



__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:21 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com