{"id":52460,"date":"2022-09-22T08:13:12","date_gmt":"2022-09-22T08:13:12","guid":{"rendered":"https:\/\/dbtut.com\/?p=52460"},"modified":"2022-09-22T08:13:42","modified_gmt":"2022-09-22T08:13:42","slug":"backup-and-recovery-in-data-guard-configuration","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/","title":{"rendered":"Backup And Recovery In Data Guard Configuration"},"content":{"rendered":"

Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs taken from Standby database can be used in Primary database.<\/p>\n

However, it is necessary to use Recovery Catalog for such use.<\/p>\n

On the other hand, SPFILE backups cannot be used between each other as there may be parameter changes. There are some rules for a backup like this.<\/p>\n

Backup must be taken from the physical database,<\/p>\n

You must be connected to the recovery catalog while taking a backup,<\/p>\n

The physical standby database must be connected with TARGET.<\/p>\n

Normally all database files and backup files are associated with DB_UNIQUE_NAME.<\/p>\n

However, it is associated with a different database with the CHANGE \u2026 RESET DB_UNIQUE_NAME command.<\/p>\n

However, this does not mean that a backup taken cannot be used in other databases.<\/p>\n

Attribution can only be thought of as ownership.<\/p>\n

The owner of that backup or database file can be thought of as the database from which it was taken.<\/p>\n

Disk backups can only be accessed by the database it is associated with, while tape backups can be accessed by all databases.<\/p>\n

However, with the CATALOG command, the image copy backup file is also associated with other databases.<\/p>\n

Since Logical Standby Databases are not the same block by block, the backups taken cannot be used in the Primary database.<\/p>\n

Likewise, a backup taken from the Primary database cannot be used in the Logical Standby database. Because,<\/p>\n

In case of a problem in the Datafile or online redo log files, the backups taken from the Logical Standby database should be used.<\/p>\n

If the entire Logical Standby Database is lost, the database must be rebuilt.<\/p>\n

If we lose all copies of the control file, we need to create a binary copy of the control file in order to perform the Recovery.<\/p>\n

This copy cannot be created with the Trace File or CREATE CONTROLFILE command. But it is created as follows.<\/p>\n

Logical Standby Database is closed and the control file is copied to a backup.<\/p>\n

Or when the database is open, ALTER DATABASE BACKUP TO CONTROL FILE TO ‘<filename>’;<\/p>\n

According to Oracle, Maximum Availability Architecture (MAA),<\/p>\n

Taking daily incremental backups of both Primary and Standby databases in Data Guard Environment,<\/p>\n

Setting the MTTR parameter,<\/p>\n

Recommends using a separate server for Recovery Catalog.<\/p>\n

<\/div>\n

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

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

Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs taken from Standby database can be used in Primary database. However, it is necessary to use Recovery Catalog for such use. On the other hand, SPFILE backups cannot be used between each other as …<\/p>\n

<\/div>\n

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

<\/div>\n","protected":false},"author":484,"featured_media":52461,"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-52460","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nBackup And Recovery In Data Guard Configuration - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs\" \/>\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\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup And Recovery In Data Guard Configuration - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T08:13:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-22T08:13:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png\" \/>\n\t<meta property=\"og:image:width\" content=\"748\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Backup And Recovery In Data Guard Configuration\",\"datePublished\":\"2022-09-22T08:13:12+00:00\",\"dateModified\":\"2022-09-22T08:13:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\"},\"wordCount\":400,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\",\"name\":\"Backup And Recovery In Data Guard Configuration - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png\",\"datePublished\":\"2022-09-22T08:13:12+00:00\",\"dateModified\":\"2022-09-22T08:13:42+00:00\",\"description\":\"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png\",\"width\":748,\"height\":337},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup And Recovery In Data Guard Configuration\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup And Recovery In Data Guard Configuration - Database Tutorials","description":"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs","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\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/","og_locale":"en_US","og_type":"article","og_title":"Backup And Recovery In Data Guard Configuration - Database Tutorials","og_description":"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs","og_url":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/","og_site_name":"Database Tutorials","article_published_time":"2022-09-22T08:13:12+00:00","article_modified_time":"2022-09-22T08:13:42+00:00","og_image":[{"width":748,"height":337,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Backup And Recovery In Data Guard Configuration","datePublished":"2022-09-22T08:13:12+00:00","dateModified":"2022-09-22T08:13:42+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/"},"wordCount":400,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/","url":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/","name":"Backup And Recovery In Data Guard Configuration - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png","datePublished":"2022-09-22T08:13:12+00:00","dateModified":"2022-09-22T08:13:42+00:00","description":"Physical Standby Databases Since Primary and block by block are the same, backups of datafile, control file and archive redo logs","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/09\/Ekran-goruntusu-2022-09-22-111127.png","width":748,"height":337},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/09\/22\/backup-and-recovery-in-data-guard-configuration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Backup And Recovery In Data Guard Configuration"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52460","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=52460"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52460\/revisions"}],"predecessor-version":[{"id":52462,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52460\/revisions\/52462"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/52461"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=52460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=52460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=52460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}