{"id":1354,"date":"2013-05-08T13:00:49","date_gmt":"2013-05-08T12:00:49","guid":{"rendered":"http:\/\/www.data-protector.org\/wordpress\/?p=1354"},"modified":"2015-12-09T19:03:21","modified_gmt":"2015-12-09T18:03:21","slug":"list-files-backed-catalog","status":"publish","type":"post","link":"https:\/\/www.data-protector.org\/wordpress\/2013\/05\/list-files-backed-catalog\/","title":{"rendered":"List files backed up from catalog"},"content":{"rendered":"<p>Have you ever asked yourself what have been backed up in a Data Protector job? In the internal database, within sessions you only see the objects done, however no information regarding backed up files and folders. You normally would see the files and folders when browsing to restore context or when using &#8220;restore by query&#8221; function in Data Protector.<\/p>\n<p>With a simple command you now can retrieve the content of the backup done. The command queries the catalog of the internal database for a given session ID and object.<\/p>\n<p>The command I used: <code>omnidb -winfs server.demo.local:\/F \"server.demo.local [\/F]\" -session 2013\/04\/02-4 -catalog<\/code>.<\/p>\n<p>The output (cutted) is displayed below.<\/p>\n<p><b>Update:<\/b> If your session spawns one media only you might also use the command <code>omnimm -catalog < medium ><\/code> which delivers a similiar output. In GUI you could use the function &#8220;list from media&#8221; in restore context. <\/p>\n<pre>\r\nProtection    Owner    Group       Size    Time              Path\r\n===============================================================================\r\nd----w----       -2  nogroup          0  03.12.2012 11:04:11 \/Install\/NB\/8540p\/SWSetup\/\r\n----r-----       -2  nogroup     604672  27.04.2012 13:09:13 \/Install\/NB\/8540p\/sp48109.exe\r\n----r-----       -2  nogroup  266051536  27.04.2012 13:16:44 \/Install\/NB\/8540p\/sp53191.exe\r\n----r-----       -2  nogroup    8638840  27.04.2012 13:14:17 \/Install\/NB\/8540p\/sp53375.exe\r\n----r-----       -2  nogroup   23839856  27.04.2012 13:14:48 \/Install\/NB\/8540p\/sp53394.exe\r\n----r-----       -2  nogroup    4019352  27.04.2012 13:09:07 \/Install\/NB\/8540p\/sp53694.exe\r\n----r-----       -2  nogroup    9721920  27.04.2012 13:14:19 \/Install\/NB\/8540p\/sp53795.exe\r\n----r-----       -2  nogroup    8111712  27.04.2012 13:05:46 \/Install\/NB\/8540p\/sp53806.exe\r\n----r-----       -2  nogroup   28550392  27.04.2012 13:09:34 \/Install\/NB\/8540p\/sp54149.exe\r\n----r-----       -2  nogroup   22394016  27.04.2012 13:14:11 \/Install\/NB\/8540p\/sp54248.exe\r\n----r-----       -2  nogroup    9481856  27.04.2012 13:18:38 \/Install\/NB\/8540p\/sp54257.exe\r\n----r-----       -2  nogroup    4180808  27.04.2012 13:05:37 \/Install\/NB\/8540p\/sp54549.exe\r\n----r-----       -2  nogroup   81326552  27.04.2012 13:12:07 \/Install\/NB\/8540p\/sp54600.exe\r\n----r-----       -2  nogroup   48868760  27.04.2012 13:19:57 \/Install\/NB\/8540p\/sp54620.exe\r\n----r-----       -2  nogroup   28575632  27.04.2012 13:12:10 \/Install\/NB\/8540p\/sp54635.exe\r\n----r-----       -2  nogroup    6580120  27.04.2012 13:14:10 \/Install\/NB\/8540p\/sp54714.exe\r\n----r-----       -2  nogroup    2912216  27.04.2012 13:17:53 \/Install\/NB\/8540p\/sp54740.exe\r\n----r-----       -2  nogroup   27476040  27.04.2012 13:06:05 \/Install\/NB\/8540p\/sp54841.exe\r\n----r-----       -2  nogroup    4711104  27.04.2012 13:09:02 \/Install\/NB\/8540p\/sp54887.exe\r\n----r-----       -2  nogroup   24835752  27.04.2012 13:10:41 \/Install\/NB\/8540p\/sp54890.exe\r\n----r-----       -2  nogroup  251788408  27.04.2012 13:07:22 \/Install\/NB\/8540p\/sp55192.exe\r\n----r-----       -2  nogroup    8594016  27.04.2012 13:01:01 \/Install\/NB\/8540p\/sp56768.exe\r\nd----w----       -2  nogroup          0  03.12.2012 10:40:50 \/Install\/NB\/8540p\/SWSetup\/SP45229\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:03 \/Install\/NB\/8540p\/SWSetup\/SP46063\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:13 \/Install\/NB\/8540p\/SWSetup\/SP46768\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:15 \/Install\/NB\/8540p\/SWSetup\/SP46972\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:16 \/Install\/NB\/8540p\/SWSetup\/SP47231\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:18 \/Install\/NB\/8540p\/SWSetup\/SP47527\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:41:33 \/Install\/NB\/8540p\/SWSetup\/SP47593\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:43:18 \/Install\/NB\/8540p\/SWSetup\/SP47594\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:43:29 \/Install\/NB\/8540p\/SWSetup\/SP48061\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:45:26 \/Install\/NB\/8540p\/SWSetup\/SP48062\/\r\nd----w----       -2  nogroup          0  03.12.2012 10:45:51 \/Install\/NB\/8540p\/SWSetup\/SP480\r\nd----w----       -2  nogroup          0  03.12.2012 10:45:53 \/Install\/NB\/8540p\/SWSetup\/SP48109\/\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever asked yourself what have been backed up in a Data Protector job? In the internal database, within sessions you only see the objects done, however no information regarding backed up files and folders. You normally would see the files and folders when browsing to restore context or when using &#8220;restore by query&#8221; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[11],"tags":[177,16],"translation":{"provider":"WPGlobus","version":"2.8.8","language":"en","enabled_languages":["en","de"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"de":{"title":false,"content":true,"excerpt":false}}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p28cjj-lQ","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":114,"url":"https:\/\/www.data-protector.org\/wordpress\/2010\/07\/614039-no-more-space-in-any-of-the-detail-catalog-directories\/","url_meta":{"origin":1354,"position":0},"title":"[61:4039] No more space in any of the Detail Catalog directories","date":"7. July 2010","format":false,"excerpt":"{:en}The error [61:4039] could occur when the limit of the detail catalog is reached. In Data Protector 6.11 the size limit for a DCBF directory was increased up to 16 GB, in former versions the limit was set to 4 GB. For my customers I usually add at least addidtional\u2026","rel":"","context":"In &quot;HowTo&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":62,"url":"https:\/\/www.data-protector.org\/wordpress\/2010\/06\/export-import\/","url_meta":{"origin":1354,"position":1},"title":"Export \/ Import","date":"28. June 2010","format":false,"excerpt":"{:en}No translation for this article available.{:} {:de} Immer wieder mal findet man Anleitungen wie ein Export \/ Import der internen Datenbank von Data Protector vorzunehmen ist. Diese Prozedur wird immer dann eingesetzt wenn Probleme in der Datenbank auftreten (korrupte Medien, ...) - Stichwort Healthcheck und omnidbcheck. Bei der nachfolgenden Prozedur\u2026","rel":"","context":"In &quot;HowTo&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1892,"url":"https:\/\/www.data-protector.org\/wordpress\/2014\/03\/migrate-dp-8-xx-dp-8-xx-hardware-ms-windows-operating-system\/","url_meta":{"origin":1354,"position":2},"title":"Migrate DP 8.XX to DP 8.XX using new hardware or different MS Windows operating system","date":"26. March 2014","format":false,"excerpt":"{:en}The migration of the internal database to new hardware or to a new Microsoft Windows operating system was no big deal in the past and before the release of Data Protector 8.xx. With the introduction of PostgreSQL as the new internal database this has been changed and several steps are\u2026","rel":"","context":"In &quot;HowTo&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1428,"url":"https:\/\/www.data-protector.org\/wordpress\/2013\/06\/basics-dp-catalog-protection-data-protection\/","url_meta":{"origin":1354,"position":3},"title":"BASICS &#8211; DP Catalog Protection and Data Protection","date":"10. June 2013","format":false,"excerpt":"{:en}Within Data Protector the protection is set per backup job and not for the tape, which might be misunderstood by customers. In the GUI a distinction is made between \"Data Protection\" and \"Catalog Protection\". \"Data Protection\" describes how long the data is kept on media and \"Catalog Protection\" describes how\u2026","rel":"","context":"In &quot;BASICS&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3004,"url":"https:\/\/www.data-protector.org\/wordpress\/2016\/07\/runbook-migrate-data-protector-7-0x-data-protector-9-0x\/","url_meta":{"origin":1354,"position":4},"title":"RUNBOOK \u2013 Migrate Data Protector 7.0x to Data Protector 9.0x","date":"5. July 2016","format":false,"excerpt":"{:en} Update 2016\/0705: In section installation source it was recommended to use a patched installation source for the upgrade. This method must not be used for upgrades from Data Protector versionen 8.13 and newer, as it will cause serious damages in the internal database (no fix available\/possible). For versions older\u2026","rel":"","context":"In &quot;HowTo&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3086,"url":"https:\/\/www.data-protector.org\/wordpress\/2016\/06\/omniofflr-offline-restore-data-protector-internal-database\/","url_meta":{"origin":1354,"position":5},"title":"OMNIOFFLR &#8211; Offline Restore Data Protector Internal Database","date":"1. June 2016","format":false,"excerpt":"{:en} In one of my previous articles I briefy informed about EADR for Data Protector 9.06 on Windows 2012 R2 - please refer to https:\/\/www.data-protector.org\/wordpress\/2016\/05\/prepare-and-execute-eadr-cell-server-on-windows-2012-r2-data-protector-9-06\/. However, if you don't need EADR as a complete recovery option and the preparation for disaster recovery for the IDB is required only, then you\u2026","rel":"","context":"In &quot;HowTo&quot;","img":{"alt_text":"","src":"https:\/\/i2.wp.com\/www.data-protector.org\/wordpress\/wp-content\/uploads\/2016\/06\/offlr1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/1354"}],"collection":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/comments?post=1354"}],"version-history":[{"count":7,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/1354\/revisions"}],"predecessor-version":[{"id":2657,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/1354\/revisions\/2657"}],"wp:attachment":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/media?parent=1354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/categories?post=1354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/tags?post=1354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}