Re: Onbar Restore Sequence Question
Thank guys for your suggestions/info. Will look into them and pass on to
vendor.
Regards
Stefan
dryburghj@yahoo.c
om (scottishpoet) To: informix-list@iiug.org
Sent by: cc:
owner-informix-li Subject: Re: Onbar Restore Sequence Question
st@iiug.org
26/06/2004 01:01
Please respond to
dryburghj
the restore occurs in
first the "Critical" dbspaces 9rootdbs log logs etc)
then the other dbpsaces in alphabetical order.
Workaround:
edit ixbar.servernum file to get the order of dbspaces
you want
alternatively right a script which restores dbpsace by dbspace in the
order you want, remembering you would need to restore the critical
dbspaces first
Stefan.Gabriel@nylex.com.au wrote in message
news:<cbgfql$q80$1@news.xmission.com>...
> Hi There,
>
> I have a restore problem with a third party backup software that conects
> via xbsa to onbar. The problem we are having is that the backup software
is
> not 'asking' for the second tape when the dbspaces to restore are on the
> second tape.
>
> An issue has been raised with the software vendor is question but I have
a
> couple of onbar related questions:
> When a restore via onbar occurs, what is the sequence of the restore
order
> for the dbspaces?
> What governs which dbspace is restored in which sequence? Looking below,
it
> seems to be in alphabetical order, is this correct?
> I think that the rserved pages in the rootdbs dbspace get restored first,
> the informix gets started in fast recovery mode, followed by the rootdbs
> dbspace being restored. Are there other critical dspaces that need to be
> restored in order?
> Is there a way to govern the order the dbspaces will restore?
>
> OS is Windows 2000, informix version is 7.31.TD1X2.
>
> To give you an example of what I mean, backups occur as follows:
> session dbspace
> 1 rootdbs
> 2 physdbs
> 3 logdbs
> 4 psappool
> 5 psapbtab
> 6 psapel46c
> 7 psapsource
> 8 psapstab
> 9 psapes46c
> 10 psapdocu
> 11 psapuser1
> 12 psapload
> 13 psapprot
> 14 psapddic
> 15 psapclu
>
> The restore sequence process is as follows:
> session dbspace
> 1 rootdbs
> 3 logdbs
> 2 physdbs
> 5 psapbtab
> 15 psapclu
> 14 psapddic
> 10 psapdocu
> 6 psapel46c
> 9 psapes46c
> 12 psapload
> 4 psappool
> 13 psapprot
> 7 psapsource
> 8 psapstab
> 11 psapuser1
>
> Any comments etc most welcome.
>
> Regards
> Stefan
>
>
>
>
> **********************************************************************
>
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this email in error
> please notify the sender and delete the material from any computer.
>
> You can visit Nylex at http://www.nylex.com.au
>
>
> **********************************************************************
>
> sending to informix-list
sending to informix-list