Bill,
If you want to play safe and save some time. How about leaving untouched
the ixbar file and then try the following

onbar -r -w -p -t "2004-09-01 xx:xx:xx"
where xx:xx:xx is your time stamp on the 1st of the month. (usually I
chosen sometime right after the completion of the backup I wanted to
restore). That time seems to be very flexible, it does not have to be
exact.
Then restore logs to the point in time of  "2004-09-06 07:00:00"
onbar -r -l -t "2004-09-06 07:00:00"
This should definitely work for you too.

                                                                         
            Bill Dare                                                    
            <dareb@jevic.com>                                            
            Sent by:                                                   To
            owner-informix-li         "''" <informix-list@iiug.org>      
            st@iiug.org                                                cc
                                                                         
                                                                  Subject
            09/28/2004 07:50          onbar restore question              
            AM                                                            
                                                                         
                                                                         
                                                                         
                                                                         
                                                                         

IDS 9.40.FC3 AIX 5.2

I do a daily level 0 backup and a monthly level 0 backup on the 1st of the
month.  Hypothetically, say I want to restore from the monthly level 0 to a
point in time of 2004-09-06 07:00:00.  So I edit the ixbar file and remove
the entries for all the level 0's since the monthly and leave just the
logs.
Will this work?  Will onbar do logical restore on the logs after the other
level 0's?  Is there anything written to the logical logs to indicate that
a
level 0 backup took place?

Bill
sending to informix-list

sending to informix-list

A cold restore would work.

i.e. it would look at the ixbar file to pull out all the required
objects to start a physical restore.

The logical restore looks at the dbspace archive information to
determine which logical log to start restoring.

I would suggest you do :

onbar -r -p -t "2004-09-06 07:00:00"
then when that is completed
onbar -r -l -t "2004-09-06 07:00:00"

    [Bill Dare]  
    Why whole-system restore?  My backups are not done using the
whole-system option.  I never tried -w, but from reading the manual it seems
an onbar -b -L 0 -w would block the system for the duration of the backup.
Also, onbar would backup the server serially.  I use BAR_MAX_BACKUP  3.  We
are 24x7 here.

    Is there any reason this would not work without using whole-system
restore?

    Bill

sending to informix-list

Bill,
Sorry, I should have asked you if you are doing serial or parallel backup.
It is true the onbar -b -w -L 0 is serial, but it should not block the
system during its course or the duration of the backup . I am in a 24x7
environment also. I am doing it frequently and not seen this behavior yet.
However, I don't see why you can't achieve your task  with a backup taken
without the -w. The only difference would be in your command line .
Type onbar -- to verify the syntax
onbar -r  {-t <time> | -n <log> }
 up to the log number you want to restore to or point in time

It should work for both parallel and serial backups.

JP

                                                                         
            Bill Dare                                                    
            <dareb@jevic.com>                                            
                                                                       To
            09/28/2004 11:12          "'jpierrot@chubb.com'"              
            AM                        <jpierrot@chubb.com>                
                                                                       cc
                                      informix-list@iiug.org              
                                                                  Subject
                                      RE: onbar restore question          
                                                                         
                                                                         
                                                                         
                                                                         
                                                                         
                                                                         

            [Bill Dare]
            Why whole-system restore?  My backups are not done using the
whole-system option.  I never tried -w, but from reading the manual it
seems
an onbar -b -L 0 -w would block the system for the duration of the backup.
Also, onbar would backup the server serially.  I use BAR_MAX_BACKUP  3.  We
are 24x7 here.

            Is there any reason this would not work without using
whole-system
restore?

            Bill

To

cc

Subject

sending to informix-list

Bill,

Editing the ixbar file to do a point-in-time restore in your version
of IDS will not work, according to IBM techdoc #1143976. onbar will
initial uses the ixbar file to restore, but then will default to the
information in the sysutils database once the instance starts,
restoring past your ixbar editing.

This means that to ensure that you are running a point-in-time
restore, you'll need to use the "-t" option with your point-in-time
definition:

onbar -r -t "2004-09-06 07:00:00"

Please double-check the syntax; I'm writing this off the top of my
head. Hope this information helps.

Brice Avila

Bill,

Editing the ixbar file to run a point-in-time restore will not work
with your version of IDS, according to IBM techdoc #1143976. Onbar
will start the restore initially using the ixbar file, but will
default to the information in the sysutils database, and restore past
your ixbar editing.

To run a point-in-time restore correctly, use the "-t" option in the
onbar command, something similar to:

onbar -r -t "2004-09-06 07:00:00"

Please confirm the syntax; I'm writing this off the top of my head.
Hope this information helps.

Brice Avila

Bill,

Editing the ixbar file to run a point-in-time restore will not work
with your version of IDS, according to IBM techdoc #1143976. Onbar
will start the restore initially using the ixbar file, but will
default to the information in the sysutils database, and restore past
your ixbar editing.

To run a point-in-time restore correctly, use the "-t" option in the
onbar command, something similar to:

onbar -r -t "2004-09-06 07:00:00"

Please confirm the syntax; I'm writing this off the top of my head.
Hope this information helps.

Brice Avila

Thanks Brice.  

sending to informix-list