The sysutils database is the place where OnBar stores information about every backup/restore it performed. Information on every dbspace, and logical log is aslo stores there. Onbar Utilizes these tables when performing warm restores.

BAR_SERVER	BAR_OBJECT	BAR_ACTION	BAR_INSTANCE	BAR_VERSION
srv_name <=>	obj_srv_name
srv_node	obj_oid <===>	act_oid <====>	ins_oid
	obj_name	act_aid <====>	ins_aid
	obj_type	act_type	ins_time	bar_version
		act_status	ins_level	bsa_version
		act_start	ins_copyid_hi	bar_sm
		act_end	ins_copyid_lo
			ins_version <==>	sm_version
			ins_first_log

Home   Index

BAR_SERVER- Records the instances online that is backed up. Only used on XPS. This get populated from the values in the sqlhosts file.

• srv_name- the online instance name DBSERVERNAME
• srv_node- the instance node name

BAR_OBJECT- Records each object that was backed up by OnBar.

• obj_srv_name- The servername of the instance that is being backed up.
• obj_oid- (serial datatype)A unique identifier associated with what ever is being backed up. This is NOT the same identifier that we use when requesting an object from the storage manager.
• obj_name- Name of the object that is backed up. It will either be the dbspace name for the dbspace that is being backed up or a number. A number indicates that it is a log backup and that number is the log unique id.
• obj_type- Type of object that is backed up. Possible values are:
  • "L" = Log backup
  • "ND" = Non critical Dbspace
  • "R" = Root dbspace
  • "CD = Critical Dbspace
  • "MR" = ? unused ?
  • "B" = Blobspace

BAR_ACTION- Records all backups/restores that were performed on a particular object.

• act_aid- Unique action id
• act_oid- Object id that this action was done on. (see bar_object.obj_oid)
• act_type- The kind of action that was done. Possible values are:
  • 1 = "backup"
  • 2 = "restore"
  • 3 = "foreign, importted restore"
  • 4 = "fake backup"
  • 5 = "whole instance backup (onbar -b -w)"
  • 6 = "whole instance restore"
• act_status- The status of how that action completed. 0 = SUCCESS; anything else means an error.
• act_start- Time action startted.
• act_end- Time action completed

BAR_INSTANCE- Records each info about each object that was sent/recevied from the storage manager. This table will store the copyid_hi (the unique identifier that is assiciated with the object that was sent to the storage manager.

• ins_aid- The action id of what was done.
• ins_oid- The object that the action was done on.
• ins_time- The time
• ins_level- The level of the backup/restore
• ins_copyid_hi- The unique identifer that is associated with the backup in the storage manager.
• ins_copyid_lo- The Storage manager version. ties to bar_server.sm_version.
• ins_version- The Onbar Version used for this.
• ins_first_log- The first log needed for the restore.

BAR_VERSION- list the compatable versons of Storage Managers and XBSA libraries.

• bar_version- Onbar Version
• bsa_version- XBSA library version.
• bar_sm- Storage manager name (not implimented yet)
• sm_version- Storage manager version (not implimented yet)

Home   Index