{"id":403,"date":"2017-03-09T11:50:30","date_gmt":"2017-03-09T10:50:30","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=403"},"modified":"2017-03-14T10:59:15","modified_gmt":"2017-03-14T09:59:15","slug":"rman-backup-volumen","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=403","title":{"rendered":"RMAN Backup Volumen"},"content":{"rendered":"

Mit folgendem SQL-Statement kann vom RMAN-Repository das Backup-Volumen vergangener Monate gelistet werden:<\/span><\/p>\n

SELECT TO_CHAR(completion_time, ‚YYYY-MON‘) completion_time, type, round(sum(bytes)\/1024\/1024\/1024\/1024) TB
\nFROM
\n(
\nSELECT
\nCASE
\nWHEN p.backup_type=’L‘ THEN ‚ARCHIVELOG‘
\nWHEN p.backup_type=’D‘ THEN ‚ONLINE_FULL‘
\nWHEN p.backup_type=’I‘ AND p.incremental_level=0 THEN ‚LEVEL0′
\nWHEN p.backup_type=’I‘ AND p.incremental_level=1 THEN ‚LEVEL1′
\nEND type,
\nTRUNC(p.completion_time) completion_time,
\np.bytes
\nFROM rc_backup_piece p
\nWHERE p.status=’A‘
\nAND p.completion_time > add_months(trunc(sysdate,’mm‘),-2)
\nand p.completion_time < add_months(trunc(sysdate, ‚mm‘),-1)
\nUNION ALL
\nSELECT ‚DATAFILECOPY‘ type, TRUNC(completion_time), output_bytes FROM rc_backup_copy_details
\nwhere completion_time > add_months(trunc(sysdate,’mm‘),-2)
\nand completion_time < add_months(trunc(sysdate, ‚mm‘),-1)
\n)
\ngroup by TO_CHAR(completion_time, ‚YYYY-MON‘), type
\norder by 1 asc,2,3
\n;<\/h5>\n

 <\/p>\n

COMPLETION_TIME\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GB\u00a0\u00a0\u00a0\u00a0\u00a0 HOURS<\/span><\/h5>\n
—————– ———— ———- ———-<\/h5>\n
2017-JAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ARCHIVELOG\u00a0\u00a0\u00a0\u00a0 28274\u00a0\u00a0\u00a0\u00a0 4367<\/span><\/h5>\n
2017-JAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEVEL0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8068\u00a0\u00a0\u00a0\u00a0\u00a0 134<\/span><\/h5>\n
2017-JAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEVEL1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 823\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 60<\/h5>\n
2017-JAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE_FULL\u00a0\u00a0\u00a0 41512\u00a0\u00a0\u00a0\u00a0 107<\/span><\/h5>\n

\n","protected":false},"excerpt":{"rendered":"

Mit folgendem SQL-Statement kann vom RMAN-Repository das Backup-Volumen vergangener Monate gelistet werden: SELECT TO_CHAR(completion_time, ‚YYYY-MON‘) completion_time, type, round(sum(bytes)\/1024\/1024\/1024\/1024) TB FROM ( SELECT CASE WHEN p.backup_type=’L‘ THEN ‚ARCHIVELOG‘ WHEN p.backup_type=’D‘ THEN ‚ONLINE_FULL‘ WHEN p.backup_type=’I‘ AND p.incremental_level=0 THEN ‚LEVEL0′ WHEN p.backup_type=’I‘ AND … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[18,35],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/403"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=403"}],"version-history":[{"count":6,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/403\/revisions"}],"predecessor-version":[{"id":409,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/403\/revisions\/409"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}