PROBLEM IN OMNI II BACKUP

[karthik narayanan_1]

we use omni II for 10.20 hpux our database has grown upto 2gb hence the backup often hangs and it is slow please tell us a way to reduce database size or how to make our backup to run smooth

[Tommy Brown]

You can add space to your file system and increase the OBII database. You can try to delete sessions, but that would also delete them from you catalog.
To speed up the backup, I do not think it is your database, unless it is on a slow system. You may want to change the level of cataloging to Directory level. I hope this helps a little,
Tommy

[Rita C Workman]

You could increase the the size of the database with omnidbutil -extend options....or you could increase /var.
Both of these are options you need to decide on...or...
I would recommend removing old backup sessions you will not (more than likely) restore anything from. Then after you have done this..you need to do a write/read ascii to clean up your fragmented database.
To do this, create a directory someplace you have better than 2gb of free space and do the following as root:
#omnidbutil -writeascii -mmdb //mmdb -cdb //cdb
This will run for a good while (4gb I think takes several hours)...when it's done do:
#omnidbutil -readascii -mmdb //mmdb -cdb //cdb
This will run for a couple hours....but when finished your framented database will be smaller.

Hope this helps,
/rcw

[Rita C Workman]

I remembered there was something about a patch if you have done an OBII upgrade. You didn't mention if you had done this or what version of OBII your on, but I figured to throw this out there.
Seems OBII at ver 3.x had a performance problem, and recommended loading patch PHSS_23105.

Just another thought,
/rcw

[Darrel Louis]

Hi,

Below you'll find a way to strip your OBII database. But I don't think this is the cause of your slow OBII performance.
It can be the tape device or your network or the disk.
- Is your tape device a DLT or DDS
- Is it connect on a shared SCSI-bus
etc.

Hi,

# Check if the protection on your Catalog and tape are not set to permanent.
# Check if the purge is running oke, that Sessions are deleted
(/var/opt/omni/log/purge.log)
You can double check this by running a
omnidb -session (to see if there are no old sessions in the databse).

This is a procedure I've used frequently:
- Ensure that no omniback sessions are running.
- Execute an omnidbcheck
- Stop omniback.
- Make a backup of /var/opt/omni/db(tar)
- Start omniback
- omnidbutil -info >/tmp/omni_db_before.info

Export the OBII-database
- omnidbutil -writeascii [-mmdb Directory -cdb Directory -no_detail
e.g: omnidbutil -writeascii -mmdb /tmp/mmdb -cdb /tmp/cdb -no_detail

Initialize the OBII-database
- omnidbinit

- omnidbutil -info >/tmp/omni_db_middle.info

Import OBII database
- omnidbutil -readascii [-mmdb Directory -cdb Directory -no_detail
e.g: omnidbutil -readascii -mmdb /tmp/mmdb -cdb /tmp/cdb -no_detail

- omnidb -strip
- omnidbutil -purge -days #

- omnidbutil -info >/tmp/omni_db_after.info

Good Luck