Onbar Restore Sequence Question
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
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
Stefan,
This behavior is Informix bug 163093, fixed in the following versions:
7.31.XD7
9.30.XC7
9.40.XC3
The only workaround I know of is to manually ask for the dbspaces in
the order that you'd like them in, similar to:
onbar -r -p rootdbs
onbar -r -p dbspace5
onbar -r -p dbspace4
onbar -r -l
onmode -m
If anyone else has other suggestions, I'd like to hear of them. Good
luck.
Brice Avila
Minneapolis, Minnesota
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
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