{"id":54700,"date":"2023-07-02T09:43:17","date_gmt":"2023-07-02T09:43:17","guid":{"rendered":"https:\/\/dbtut.com\/?p=54700"},"modified":"2023-07-02T09:44:31","modified_gmt":"2023-07-02T09:44:31","slug":"zdlra-space-management","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/","title":{"rendered":"ZDLRA Space management"},"content":{"rendered":"

In today’s article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.<\/p>\n

One of the important tasks of every Backup & Recovery manager is to provide appropriate disk space for the backup database and to make a capacity plan accordingly.<\/p>\n

As the conditions change, this planning becomes more difficult and the situation can become inextricable as a result of wrong actions.<\/p>\n

Oracle ZDLRA, when integrated with Enterprise Manager, uses the image \u201cRA_DATABASE \u201d to do the above planning and determine how and how much to keep a backup.<\/p>\n

The image \u201dRA_DATABASE \u201d contains Unique database name and meta information of this database, protection policies, time zone and more.<\/p>\n

ZDLRA also hosts and manages the backup with the following four methods.<\/p>\n

\"Description<\/p>\n

Recovery Window Goal<\/h3>\n

The recovery_window_goal parameter in the DBMS_RA.CREATE_PROTECTION_POLICY policies determines how much backup will be taken retrospectively from the current time.<\/p>\n

This parameter is usually set in days. In other words, if the policy is set to 8 days retrospectively, you can safely return to a desired slice in the “T” time interval with SYSDATE.<\/p>\n

Reserved Space<\/h3>\n

Reversed Space, DBMS_RA.ADD_VE also determines the disk space in DBMS_RA.UPDATE_DB that is guaranteed for each database to be backed up.<\/p>\n

It can be given a number between 0-9 and takes a value between Kilobytes and Yottabytes. If only a digit is specified, ZDLRA defines it in bytes.<\/p>\n

ZDLRA uses Recovery Window Goal targets and reserved space settings to dynamically allocate storage to meet business needs.<\/p>\n

If ZDLRA has cleared as much backup data as possible and more space is required while still meeting the Recovery Window Goal for each database, the Recovery Application evaluates each database’s reserved space setting.<\/p>\n

When any cleanup is done, it records the transaction in the RA_INCIDENT_LOG table.<\/p>\n

Databases in the purge queue can be queried from the RA_PURGING_QUEUE image.<\/p>\n

Guaranteed Copy<\/h3>\n

One of the important questions in Backup & Restore operations is how many copies of old backups will keep.<\/p>\n

With the DBMS_RA.CREATE_PROTECTION_POLICY parameter on ZDLRA, how many copies can be guaranteed can be set with the following values.<\/p>\n

NO;<\/h5>\n

This parameter comes by default. When the duplicated backups are taken to the storage medium (eg tape), they can be cleaned if necessary.<\/p>\n

This area can be more or less than the database area to be backed up.<\/p>\n

YES;<\/h5>\n

Using this parameter, ZDLRA will never clean a backup without the Recovery Application copying or duplicating it to tape space.<\/p>\n

Maximum Retention Window<\/h3>\n

Depending on the DBMS_RA.CREATE_PROTECTION_POLICY policy, you can specify how long the databases will keep their backups with the max_retention_window parameter.<\/p>\n

If a NULL value is specified, clearing will not occur unless the user performs an action.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In today’s article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself. One of the important tasks of every Backup & Recovery manager is to provide appropriate disk space for the backup database and to make a capacity plan accordingly. As the conditions change, this …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":574,"featured_media":54702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-54700","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nZDLRA Space management - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ZDLRA Space management - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-02T09:43:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-02T09:44:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png\" \/>\n\t<meta property=\"og:image:width\" content=\"687\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"ZDLRA Space management\",\"datePublished\":\"2023-07-02T09:43:17+00:00\",\"dateModified\":\"2023-07-02T09:44:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\"},\"wordCount\":479,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\",\"name\":\"ZDLRA Space management - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png\",\"datePublished\":\"2023-07-02T09:43:17+00:00\",\"dateModified\":\"2023-07-02T09:44:31+00:00\",\"description\":\"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png\",\"width\":687,\"height\":283},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ZDLRA Space management\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ZDLRA Space management - Database Tutorials","description":"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/","og_locale":"en_US","og_type":"article","og_title":"ZDLRA Space management - Database Tutorials","og_description":"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/","og_site_name":"Database Tutorials","article_published_time":"2023-07-02T09:43:17+00:00","article_modified_time":"2023-07-02T09:44:31+00:00","og_image":[{"width":687,"height":283,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"ZDLRA Space management","datePublished":"2023-07-02T09:43:17+00:00","dateModified":"2023-07-02T09:44:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/"},"wordCount":479,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/","url":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/","name":"ZDLRA Space management - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png","datePublished":"2023-07-02T09:43:17+00:00","dateModified":"2023-07-02T09:44:31+00:00","description":"In today's article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-02-123906.png","width":687,"height":283},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/02\/zdlra-space-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ZDLRA Space management"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54700"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54700\/revisions"}],"predecessor-version":[{"id":54704,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54700\/revisions\/54704"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54702"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}