onbar restore question

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

Bill Dare wrote: > 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 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, 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 Dare <dareb@jevic.com> wrote in message news:<cjbrjg$h5r$1@news.xmission.com>... > 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

Bill Dare <dareb@jevic.com> wrote in message news:<cjbrjg$h5r$1@news.xmission.com>... > 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 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 Dare <dareb@jevic.com> wrote in message news:<cjbrjg$h5r$1@news.xmission.com>... > 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 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