SAP Mix

Veritas Netbackup, OnBar, and onsmsync -help requested

Posted By:
Date:

Calling all OnBar gurus.....advice needed.

I had a problem with Onbar yesterday on a freshly built system (built
from an alternate client restore). We have Veritas Netbackup and are
using onbar (IDS 7.31.FC6x2).

After the rebuild and database rename/application rename steps (yeah,
this is SAP), I took my first level 0 backup on the rebuilt system.

Netbackup successfully recorded 16 images for the dbspaces it backed up.
Informix online.log showed the rootdbs backup started, then aborted,
then started again, and completed.
Sysutils and ixbar have only 15 images. Sysutils and ixbar do not have
the ROOTDBS that Netbackup recorded as successful.

Netbackup has a successful rootdbs image:
Time: Wed Feb 19 10:12:43 2003 ID: sapdev12_1045671163 UBAK (2)

My problem was how to get this Netbackup record into ixbar so I could do
a cold restore. I could not go back to a previous day and restore/roll
logs as there was NO previous day. The next backup was at 6 PM, but my
customers wanted me to restore to the 10AM physical image and roll logs
to 3 PM. I needed that rootdbs record in ixbar in order to do the
physical cold restore.

1) I tried doing onsmsync to regenerate the ixbar file. My database was
UP. onsmsync created an ixbar file from sysutils. Sysutils did not
have the rootdbs record, so my new ixbar didn't have it.

2) I did not get to try this, but would I have been able to take the
database down and run onsmsync to regenerate the ixbar? Would onsmsync
have recreated ixbar from the Netbackup catalog?

3) Maybe I could have added the ixbar line manually from the Netbackup
record above. Netbackup told me the important thing - the image name.
The other fields, I could have mostly guessed at, but I am not sure what
they are all for. Maybe someone can help me understand.
Here is an example of the ixbar record I would have needed. The record
below is the second dbspace that backed up (logdbs), rootdbs would have
been recorded just before this.

sapdev12sp1shm logdbs CD 0 31731 0 0 1045671416
2003-02-19 10:16:50 1 0 0 31731

HERE is a GOOD record of rootdbs as it was also backed up at 6 PM that
night:

sapdev12sp1shm rootdbs R 0 31907 0 0 1045699322
2003-02-19 18:01:58 1 0 0 31907

From the above 2 lines, I would have tried to manually enter the missing
10:12 AM rootdbs record in ixbar....
In the good rootdbs ixbar record above, after the fields "rootdbs R",
I have "0 31907 0 0", what are those? (31907 must be a log number?)
Then comes the Netbackup image timestamp/number info: "1045699322
2003-02-19 18:01:58" which I could have created.
At the end of the line is :"1 0 0 31907", what are
those?
I assume 31907 would be a log number, the other fields of mostly 0's and
one 1, I would have created the same way. If I GUESSED at the log
number, might that have worked?

Any advice/insight would be appreciated.
thanks,
Norma Jean Sebastian
Tellabs


--openmail-part-398c5427-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Sat, 22 Feb 2003 12:29:09 -0600"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw
XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls
XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l
dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1
NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIENhbGxpbmcgYWxsIE9u
QmFyIGd1cnVzLi4uLi5hZHZpY2UgbmVlZGVkLlxwYXINClxwYXINCkkgaGFkIGEgcHJvYmxl
bSB3aXRoIE9uYmFyIHllc3RlcmRheSBvbiBhIGZyZXNobHkgYnVpbHQgc3lzdGVtIChidWls
dCBmcm9tIGFuIGFsdGVybmF0ZSBjbGllbnQgcmVzdG9yZSkuICBXZSBoYXZlIFZlcml0YXMg
TmV0YmFja3VwIGFuZCBhcmUgdXNpbmcgb25iYXIgKElEUyA3LjMxLkZDNngyKS5ccGFyDQpc
cGFyDQpBZnRlciB0aGUgcmVidWlsZCBhbmQgZGF0YWJhc2UgcmVuYW1lL2FwcGxpY2F0aW9u
IHJlbmFtZSBzdGVwcyAoeWVhaCwgdGhpcyBpcyBTQVApLCBJIHRvb2sgbXkgZmlyc3QgbGV2
ZWwgMCBiYWNrdXAgb24gdGhlIHJlYnVpbHQgc3lzdGVtLlxwYXINClxwYXINCk5ldGJhY2t1
cCBzdWNjZXNzZnVsbHkgcmVjb3JkZWQgMTYgaW1hZ2VzIGZvciB0aGUgZGJzcGFjZXMgaXQg
YmFja2VkIHVwLlxwYXINCkluZm9ybWl4IG9ubGluZS5sb2cgc2hvd2VkIHRoZSByb290ZGJz
IGJhY2t1cCBzdGFydGVkLCB0aGVuIGFib3J0ZWQsIHRoZW4gc3RhcnRlZCBhZ2FpbiwgYW5k
IGNvbXBsZXRlZC5ccGFyDQpTeXN1dGlscyBhbmQgaXhiYXIgaGF2ZSBvbmx5IDE1IGltYWdl
cy4gIFN5c3V0aWxzIGFuZCBpeGJhciBkbyBub3QgaGF2ZSB0aGUgUk9PVERCUyB0aGF0IE5l
dGJhY2t1cCByZWNvcmRlZCBhcyBzdWNjZXNzZnVsLlxwYXINClxwYXINCk5ldGJhY2t1cCBo
YXMgYSBzdWNjZXNzZnVsIHJvb3RkYnMgaW1hZ2U6XHBhcg0KVGltZTogV2VkIEZlYiAxOSAx
MDoxMjo0MyAyMDAzICAgSUQ6IHNhcGRldjEyXzEwNDU2NzExNjMgICBVQkFLICgyKVxwYXIN
ClxwYXINCk15IHByb2JsZW0gd2FzIGhvdyB0byBnZXQgdGhpcyBOZXRiYWNrdXAgcmVjb3Jk
IGludG8gaXhiYXIgc28gSSBjb3VsZCBkbyBhIGNvbGQgcmVzdG9yZS4gIEkgY291bGQgbm90
IGdvIGJhY2sgdG8gYSBwcmV2aW91cyBkYXkgYW5kIHJlc3RvcmUvcm9sbCBsb2dzIGFzIHRo
ZXJlIHdhcyBOTyBwcmV2aW91cyBkYXkuICBUaGUgbmV4dCBiYWNrdXAgd2FzIGF0IDYgUE0s
IGJ1dCBteSBjdXN0b21lcnMgd2FudGVkIG1lIHRvIHJlc3RvcmUgdG8gdGhlIDEwQU0gcGh5
c2ljYWwgaW1hZ2UgYW5kIHJvbGwgbG9ncyB0byAzIFBNLiAgSSBuZWVkZWQgdGhhdCByb290
ZGJzIHJlY29yZCBpbiBpeGJhciBpbiBvcmRlciB0byBkbyB0aGUgcGh5c2ljYWwgY29sZCBy
ZXN0b3JlLlxwYXINClxwYXINCjEpIEkgdHJpZWQgZG9pbmcgb25zbXN5bmMgdG8gcmVnZW5l
cmF0ZSB0aGUgaXhiYXIgZmlsZS4gIE15IGRhdGFiYXNlIHdhcyBVUC4gIG9uc21zeW5jIGNy
ZWF0ZWQgYW4gaXhiYXIgZmlsZSBmcm9tIHN5c3V0aWxzLiAgU3lzdXRpbHMgZGlkIG5vdCBo
YXZlIHRoZSByb290ZGJzIHJlY29yZCwgc28gbXkgbmV3IGl4YmFyIGRpZG4ndCBoYXZlIGl0
LlxwYXINClxwYXINCjIpIEkgZGlkIG5vdCBnZXQgdG8gdHJ5IHRoaXMsIGJ1dCB3b3VsZCBJ
IGhhdmUgYmVlbiBhYmxlIHRvIHRha2UgdGhlIGRhdGFiYXNlIGRvd24gYW5kIHJ1biBvbnNt
c3luYyB0byByZWdlbmVyYXRlIHRoZSBpeGJhcj8gIFdvdWxkIG9uc21zeW5jIGhhdmUgcmVj
cmVhdGVkIGl4YmFyIGZyb20gdGhlIE5ldGJhY2t1cCBjYXRhbG9nP1xwYXINClxwYXINCjMp
IE1heWJlIEkgY291bGQgaGF2ZSBhZGRlZCB0aGUgaXhiYXIgbGluZSBtYW51YWxseSBmcm9t
IHRoZSBOZXRiYWNrdXAgcmVjb3JkIGFib3ZlLiAgTmV0YmFja3VwIHRvbGQgbWUgdGhlIGlt
cG9ydGFudCB0aGluZyAtIHRoZSBpbWFnZSBuYW1lLiAgVGhlIG90aGVyIGZpZWxkcywgSSBj
b3VsZCBoYXZlIG1vc3RseSBndWVzc2VkIGF0LCBidXQgSSBhbSBub3Qgc3VyZSB3aGF0IHRo
ZXkgYXJlIGFsbCBmb3IuIE1heWJlIHNvbWVvbmUgY2FuIGhlbHAgbWUgdW5kZXJzdGFuZC5c
cGFyDQpIZXJlIGlzIGFuIGV4YW1wbGUgb2YgdGhlIGl4YmFyIHJlY29yZCBJIHdvdWxkIGhh
dmUgbmVlZGVkLiAgVGhlIHJlY29yZCBiZWxvdyBpcyB0aGUgc2Vjb25kIGRic3BhY2UgdGhh
dCBiYWNrZWQgdXAgKGxvZ2RicyksIHJvb3RkYnMgd291bGQgaGF2ZSBiZWVuIHJlY29yZGVk
IGp1c3QgYmVmb3JlIHRoaXMuXHBhcg0KXHBhcg0Kc2FwZGV2MTJzcDFzaG0gICAgIGxvZ2Ri
cyAgICAgICAgICAgICBDRCAwIDMxNzMxIDAgMCAgICAgICAgICAxMDQ1NjcxNDE2IDIwMDMt
MDItMTkgMTA6MTY6NTAgMSAgICAgMCAgICAgMCAgICAgICAgICAgMzE3MzFccGFyDQpccGFy
DQpIRVJFIGlzIGEgR09PRCByZWNvcmQgb2Ygcm9vdGRicyBhcyBpdCB3YXMgYWxzbyBiYWNr
ZWQgdXAgYXQgNiBQTSB0aGF0IG5pZ2h0OlxwYXINClxwYXINCnNhcGRldjEyc3Axc2htICAg
ICByb290ZGJzICAgICAgICAgICAgUiAgMCAzMTkwNyAwIDAgICAgICAgICAgMTA0NTY5OTMy
MiAyMDAzLTAyLTE5IDE4OjAxOjU4IDEgICAgIDAgICAgIDAgICAgICAgICAgIDMxOTA3XHBh
cg0KXHBhcg0KRnJvbSB0aGUgYWJvdmUgMiBsaW5lcywgSSB3b3VsZCBoYXZlIHRyaWVkIHRv
IG1hbnVhbGx5IGVudGVyIHRoZSBtaXNzaW5nIDEwOjEyIEFNIHJvb3RkYnMgcmVjb3JkIGlu
IGl4YmFyLi4uLiBccGFyDQpJbiB0aGUgZ29vZCByb290ZGJzIGl4YmFyIHJlY29yZCBhYm92
ZSwgYWZ0ZXIgdGhlIGZpZWxkcyAicm9vdGRicyAgIFIiLCBJIGhhdmUgIjAgMzE5MDcgMCAw
Iiwgd2hhdCBhcmUgdGhvc2U/ICgzMTkwNyBtdXN0IGJlIGEgbG9nIG51bWJlcj8pXHBhcg0K
VGhlbiBjb21lcyB0aGUgTmV0YmFja3VwIGltYWdlIHRpbWVzdGFtcC9udW1iZXIgaW5mbzog
IjEwNDU2OTkzMjIgMjAwMy0wMi0xOSAxODowMTo1OCIgd2hpY2ggSSBjb3VsZCBoYXZlIGNy
ZWF0ZWQuXHBhcg0KQXQgdGhlIGVuZCBvZiB0aGUgbGluZSBpcyA6IjEgICAgIDAgICAgIDAg
ICAgICAgICAgIDMxOTA3Iiwgd2hhdCBhcmUgdGhvc2U/ICBccGFyDQpJIGFzc3VtZSAzMTkw
NyB3b3VsZCBiZSBhIGxvZyBudW1iZXIsIHRoZSBvdGhlciBmaWVsZHMgb2YgbW9zdGx5IDAn
cyBhbmQgb25lIDEsIEkgd291bGQgaGF2ZSBjcmVhdGVkIHRoZSBzYW1lIHdheS4gIElmIEkg
R1VFU1NFRCBhdCB0aGUgbG9nIG51bWJlciwgIG1pZ2h0IHRoYXQgaGF2ZSB3b3JrZWQ/XHBh
cg0KXHBhcg0KQW55IGFkdmljZS9pbnNpZ2h0IHdvdWxkIGJlIGFwcHJlY2lhdGVkLlxwYXIN
CnRoYW5rcyxccGFyDQpOb3JtYSBKZWFuIFNlYmFzdGlhblxwYXINClRlbGxhYnNccGFyDQp9

--openmail-part-398c5427-00000002--

SAP Mix is maintained by Administrator with WebBBS 5.12.