Re: ONBAR, IXBAR, & Point in Time Recovery

T.E., Yes, you can restore past what the ixbar lists if there are images listed in the systuils database. You'll need to query it to see what images have been backed-up. Also, using the onsmsync command, you can: 1. Make a new ixbar file from the sysutils database 2. Make a new sysutils database from the ixbar file Hope this helps. Good luck. Brice Avila Minneapolis, Minnesota temammy@yahoo.com (Thom) wrote in message news:<5babca87.0407130759.439aede8@posting.google.com>... > The system crashed hard on Monday (SAN Failure). My last good full > database and file system backups (which includes the IXBAR file) are > from Friday morning. I have all the logs sent to tape since the last > db backup. My problem is can I recover to a point in time beyond the > IXBAR file? I have been doing some searching and I don't really see > anything and I am wondering if anyone has tried this? If the IXBAR > file needs to have all the log files info is there away to get that > information in the IXBAR file? > > Any help will be appreciated. > > Thanks in advance. > T.E.Mammoser > DBA > Nicor Gas

Hello, Thin ice: if i recall correctly onbar does query-ing the storage manager to see if there are more logs not listed in ixbar. (this is a rumour i heard and have not tested!!!! ) if not then you have to reconstruct the ixbar file yourself before you do the logical restore!!!!! you have to gointo the storeagemgr and look for logical logs; grab the uniqueid and put it in ixbar together with the rest of the stuff check the manuals for this. When reconstructed: you can check your handy work using export BAR_LOGCHECK=1 onbar -P <logid which you hacked in> |more if this displays the correct info then you should be ok. lotta manual work; sorry. hope it helps Superboer briceavila@hotmail.com (Brice Avila) wrote in message news:<c46e3ec5.0407131402.5e9be83a@posting.google.com>... > T.E., > > Yes, you can restore past what the ixbar lists if there are images > listed in the systuils database. You'll need to query it to see what > images have been backed-up. > > Also, using the onsmsync command, you can: > > 1. Make a new ixbar file from the sysutils database > 2. Make a new sysutils database from the ixbar file > > Hope this helps. Good luck. > > Brice Avila > Minneapolis, Minnesota > > temammy@yahoo.com (Thom) wrote in message news:<5babca87.0407130759.439aede8@posting.google.com>... > > The system crashed hard on Monday (SAN Failure). My last good full > > database and file system backups (which includes the IXBAR file) are > > from Friday morning. I have all the logs sent to tape since the last > > db backup. My problem is can I recover to a point in time beyond the > > IXBAR file? I have been doing some searching and I don't really see > > anything and I am wondering if anyone has tried this? If the IXBAR > > file needs to have all the log files info is there away to get that > > information in the IXBAR file? > > > > Any help will be appreciated. > > > > Thanks in advance. > > T.E.Mammoser > > DBA > > Nicor Gas