Tuesday, 8 December 2015

HPE data protector 9.0x How to purge old records and reducing the IDB size in HP DP

To check current size IDB in HPE data protector 9.0x start command omnirpt -report db_size:


C:\Users\Administrator>omnirpt -report db_size
IDB Size Report
Cell Manager: dpcm
Creation Date: 12/8/2015 12:48:15 AM
Media Management DB
Part                   Allocated Space [MB]     Items Used      Max Items    Us
ed
____________________________________________________________
Devices                                0.11              4      unlimited 0%
Libraries                              0.16              1           1000 0%
Cartridges                             0.29             28      unlimited 0%
Compounds                              0.05              0      unlimited 0%
Pools                                  0.06             20      unlimited 0%
Media                                  0.23             28       10000000 0%

Catalog DB
Part                   Allocated Space [MB]     Items Used      Max Items    Us
ed
____________________________________________________________
Sessions                               0.22             51      100000000 0%
Objects                                0.36             16      500000000 0%
Object versions                        0.41             43      500000000 0%
Positions                              0.19             37     1000000000 0%

Archived Log Files
Directory                                                          Size [MB]
# Files
____________________________________________________________
C:/ProgramData/OmniBack/server/db80/pg/pg_xlog                         64.00        5
C:/ProgramData/OmniBack/server/db80/pg/pg_xlog_archive                 32.00        2
Datafiles

Directory
        Size [MB] Free Disk Space
____________________________________________________________
C:/ProgramData/OmniBack/server/db80/pg             17.79        15867.55
C:/ProgramData/OmniBack/server/db80/idb             13.53        15867.55
C:/ProgramData/OmniBack/server/db80/jce              6.61        15867.55

Detail Catalog Binary Files
Directory                                          Size [MB] Max Size     Used
_______________________________________________________________________________
C:/ProgramData/OmniBack/server/db80/dcbf/dcbf4          0.07 204800.00      0%
C:/ProgramData/OmniBack/server/db80/dcbf/dcbf2          0.06 204800.00      0%
C:/ProgramData/OmniBack/server/db80/dcbf/dcbf1          0.09 204800.00      0%
C:/ProgramData/OmniBack/server/db80/dcbf/dcbf3          0.01 204800.00      0%
C:/ProgramData/OmniBack/server/db80/dcbf/dcbf0          0.20 204800.00      0%

Session Messages Binary Files
Directory                                          Size [MB]  # Files
______________________________________________________________________
C:/ProgramData/OmniBack/server/db80/msg                 0.00        0

Serverless Integrations Binary Files
Directory                                          Size [MB]  # Files
______________________________________________________________________
C:/ProgramData/OmniBack/server/db80/meta                0.00        0 



Next run omnidb -strip in orgder to strip objects whose protection has expired:

C: \Users\Administrator>omnidb -strip
Objects whose protection has expired successfully stripped.

Also you could manually remove expired session and session massages older than XX days:

omnidbutil -purge -sessions XX
omnidbutil -purge -messages XX

To remove all backups whose catalog protection has expired, use the:

omnidbutil -purge -dcbf

After that recomended to start omnidbutil -fixmpos :

omnidbutil –fixmpos
DONE!


DP IDB may hold multiple copies of failed objects made during a backup. These multiple copies of failed objects may overload an IDB.  A special purge, omnidbutil -purge_failed_copies, removes any failed objects that are not the original from the IDB.



omnidbutil -purge_failed_copies



All options omnidb and omnidbutil :




C:\Users\Administrator>omnidbutil
Usage synopsis:

omnidbutil -version | -help
omnidbutil -readdb Directory
omnidbutil -writedb Directory
omnidbutil -show_locked_devs [-all]
omnidbutil -free_locked_devs [-all | DevName | MediumID | CartName
           PhyLocation | Serial_LDEV | WWW_LUN]
omnidbutil -changebdev FromDev ToDev [-session SessionID]
omnidbutil -purge {-sessions [NumberOfDays] | -days [NumberOfDays] |
           -messages [NumberOfDays] | -daily | -dcbf}
omnidbutil -purge_failed_copies
omnidbutil -purge_expired_poweron_vms
omnidbutil -clear
omnidbutil -change_cell_name [OldHost]
omnidbutil -show_cell_name
omnidbutil -set_session_counter NewSessionID
omnidbutil -show_db_files
omnidbutil -free_pool_update
omnidbutil -list_large_mpos MinNumberOfMPos [-top NumOfTopMedia] [-detail] [-csv
CSVFile]
omnidbutil -free_cell_resources
omnidbutil -mergemmdb CellManagerHostname
omnidbutil -cdbsync CellManagerHostname
omnidbutil -info
omnidbutil -autovacuum {-set -table TableName [-to_default] [-on_n_rows NRows]
           [-on_percentage Percent] [-freeze_max_age FreezeMax] |
           -get [-table TableName | -enabled | -disabled | -all]}
omnidbutil -list_dcdirs
omnidbutil -add_dcdir PathName [-maxsize MaxSizeInMB] [-maxfiles NumberOfFiles]
           [-spacelow SpaceLowInMB] [-seq SeqNumber]
omnidbutil -modify_dcdir PathName [-maxsize MaxSizeInMB]
           [-maxfiles NumberOfFiles] [-spacelow SpaceLowInMB] [-seq SeqNumber]
omnidbutil -remove_dcdir PathName
omnidbutil -remap_dcdir
omnidbutil -fixmpos
omnidbutil -cp {-set ParamName ParamValue | -get [-param ParamName]}
omnidbutil -set_passwd Username
omnidbutil -sync_srv
omnidbutil -orphan_dcbf [-delete] [-ignore_local_media]
omnidbutil -check_graph {-all_objects | -object_name <objectName>}



C:\Users\Administrator>omnidb
Usage synopsis:

omnidb -version | -help

omnidb -session [ -datalist Datalist] [-type { restore | backup | verification }
] [-user User]
       [ [-since Date] [-until Date] | -last Number | -latest |
         -wo start duration ]
       [ -detail ]

omnidb -session SessionID
       [ -report [warning | minor | major | critical ] |
         -detail |
         -encryptioninfo |
         -strip  |
         -purge  |
         -remove_msgs |
         -change_protection Protection |
         -change_catprotection Protection |
         -media [ -detail ] ]

omnidb { -object | -filesystem | -winfs | -vbfs |
         -rawdisk | -sap | -sapdb | -saphana | -stream | -oracle8 | -mssql | -ms
ese | -e2010 |
         -vmware | -veagent | -mbx | -informix | -sybase | -lotus | -vss | -db2
| -mssps | -mssharepoint | -idb }
         [ -detail | -encryptioninfo ]

omnidb Object
       [ [-since Date] [ -until Date ] | -last NumberOfDays | -latest ]
         [ -noexpand ] [ -detail | -encryptioninfo ]

omnidb Object
       [ [-since Date] [ -until Date ] | -last NumberOfDays ]
         [ -change_protection Protection |
           -change_catprotection Protection ]
         [ -noexpand ]

omnidb Object [ -noexpand ] -strip NumberOfDays

omnidb -strip

omnidb -change_protection Protection

omnidb -change_catprotection Protection

omnidb { -filesystem | -winfs | -vbfs } Host:MountPoint Label
       -fileversions FileName
       [ -detail | -encryptioninfo ] [ -noexpand ]

omnidb Object [ -noexpand ] -session SessionID [ -copyid CopyID ]
       [ -report [ warning | minor | major | critical ] |
         -change_protection Protection |
         -change_catprotection Protection |
         -strip | -catalog | -encryptioninfo ]

omnidb Object [ -noexpand ] -session SessionID [ -copyid CopyID ] -media [ -deta
il ]

omnidb Object [ -noexpand ] -session SessionID [ -copyid CopyID ] -listcopies [
-detail | -encryptioninfo ]

omnidb -filesearch [ -n N ] <client> <directory> <filename>

omnidb Object [ -session sessionID ] [ -copyid CopyID ] -listdir <directory>

omnidb -list_folders -session SessionID [ -mailbox {MailboxName...} ]

omnidb -veagent Host:Set -session SessionID [ -copyid CopyID] [ -catalog | -medi
a ] [ -vdiskuuid DiskUuid ]

omnidb -veagent Host:Set -session SessionID [ -copyid CopyID] [ -list_vdisks ]

omnidb -rpt SessionID [ -detail ]

omnidb -rpt -wo start duration

omnidb -addhost -servername ClientName -user UserName -passwd Password

omnidb -removehost -servername ClientName -user UserName

omnidb -listhost [-servername ClientName]

omnidb -auditing
       { -timeframe StartDate [ EndDate ] |
         -since Date [-until Date] |
         -last NumberOfDays }
       [ -detail ]


Object = { -filesystem Host:MountPoint Label |
           -winfs Host:MountPoint Label |
           -vbfs Host:MountPoint Label |
           -rawdisk Host Label |
           -stream Host:Set |
           -sap Host:Set |
           -sapdb Host:Set |
           -saphana Host:Set |
           -oracle8 Host:Set |
           -mssql Host:Set |
           -msese Host:Set |
           -e2010 Host:Set [Label] |
           -mbx Host:Set |
           -informix Host:Set |
           -sybase Host:Set |
           -lotus Host:Set |
           -vss Host:Set |
           -db2 Host:Set |
           -mssharepoint Host:Set |
           -vmware Host:Set |
           -veagent Host:Set |
           -idb Host:Set |
           -integ MySQL Host:Set }

Protection = { none | days Number | weeks Number | until Date | permanent }

Date = [YY]YY/MM/DD   (1969 < [YY]YY < 2038)



1 comment:

  1. No one can stop you writing a perfect blog or article if you are passionate to your job. Your aim is to satisfy your readers with a well written blog and your passion is always behind your every successful assignment. Impressive writing skills can be observed over here.HPE StoreOnce 3100

    ReplyDelete