{"id":359,"date":"2024-12-31T13:43:51","date_gmt":"2024-12-31T10:43:51","guid":{"rendered":"https:\/\/oraclius.com.tr\/?p=359"},"modified":"2025-04-05T21:25:36","modified_gmt":"2025-04-05T18:25:36","slug":"oracle-data-guard-kurulumu-rman-duplicate","status":"publish","type":"post","link":"https:\/\/oraclius.com.tr\/en\/oracle-data-guard-kurulumu-rman-duplicate\/","title":{"rendered":"Oracle Data Guard Kurulumu: RMAN DUPLICATE"},"content":{"rendered":"<p>Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) fiziksel veya mant\u0131ksal kopyalar\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. <strong>Data Guard Kurulumu \u0130\u00e7in Gereken Sunucu ve Veritaban\u0131 Bilgileri<\/strong><\/h2>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong>Primary Database Sunucusu<\/strong><\/mark>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hostname: oraclius.prod<\/li>\n\n\n\n<li>IP: 10.10.10.11<\/li>\n\n\n\n<li>\u0130\u015fletim Sistemi: Linux Server release 7.9 (Maipo)<\/li>\n\n\n\n<li>Database Versiyonu: 19.3.0.0<\/li>\n\n\n\n<li>DB_NAME: orac<\/li>\n\n\n\n<li>DB_UNIQUE_NAME: orac<\/li>\n\n\n\n<li>SID: orac<\/li>\n<\/ul>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong>Standby Database Sunucusu<\/strong><\/mark>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hostname: oraclius.dg<\/li>\n\n\n\n<li>IP: 10.10.10.12<\/li>\n\n\n\n<li>\u0130\u015fletim Sistemi: Linux Server release 7.9 (Maipo)<\/li>\n\n\n\n<li>Database Versiyonu: Kurulu De\u011fil<\/li>\n\n\n\n<li>DB_NAME: orac<\/li>\n\n\n\n<li>DB_UNIQUE_NAME: oracdg<\/li>\n\n\n\n<li>SID: oracdg<\/li>\n<\/ul>\n\n\n\n<p>Primary Database sunucusu, a\u015fa\u011f\u0131daki yaz\u0131y\u0131 takip ederek kurulmal\u0131d\u0131r.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/oraclius.com.tr\/en\/oracle-19c-single-instance-veritabani-kurulumu\/\" target=\"_blank\" rel=\" noreferrer noopener nofollow\">Single Instance Kurulum<\/a><\/div>\n<\/div>\n\n\n\n<p>Standby Database sunucusu ise a\u015fa\u011f\u0131daki yaz\u0131n\u0131n yaln\u0131zca 3.1 Oracle Database Binary Kurulumu ad\u0131m\u0131na kadar (3.1 dahil) takip edilerek kurulmal\u0131d\u0131r.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/oraclius.com.tr\/en\/oracle-19c-single-instance-veritabani-kurulumu\/\" target=\"_blank\" rel=\" noreferrer noopener nofollow\">Single Instance Kurulum<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. <strong><strong>Oracle Data Guard Kurulum A\u015famalar\u0131<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">2.<strong>1 Primary <strong>Sunucu<\/strong> <\/strong>Haz\u0131rl\u0131\u011f\u0131<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.1 \/etc\/hosts Dosyas\u0131n\u0131n G\u00fcncellenmesi<\/h4>\n\n\n\n<p>Primary sunucunuzun <code>\/etc\/hosts<\/code> dosyas\u0131na, Standby sunucusunun IP adresi ve hostname bilgilerini eklemeniz gerekiyor. Bu, iki sunucunun birbirini tan\u0131yabilmesi i\u00e7in gereklidir.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69f62d5d93b61&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69f62d5d93b61\" class=\"wp-block-image aligncenter size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"199\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2.png\" alt=\"\" class=\"wp-image-360\" srcset=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2.png 720w, https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2-300x83.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.2 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">FORCE LOGGING<\/mark> Kontrol\u00fc<\/h4>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><code>FORCE_LOGGING<\/code> <\/mark>parametresi, t\u00fcm veritaban\u0131 i\u015flemlerinin redo loglar\u0131na yaz\u0131lmas\u0131n\u0131 zorunlu k\u0131lar. Bu, Data Guard yap\u0131land\u0131rmas\u0131 i\u00e7in gereklidir.<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SELECT FORCE_LOGGING FROM V$DATABASE;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>FORCE_LOGGING\n---------------------------------------\nNO<\/code><\/pre>\n\n\n\n<p>E\u011fer <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><code>FORCE_LOGGING<\/code> <\/mark>de\u011feri <code>NO<\/code> ise, a\u015fa\u011f\u0131daki komutla a\u00e7\u0131lmal\u0131d\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>ALTER DATABASE FORCE LOGGING;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.3 ARCHIVELOG Modunun Kontrol\u00fc<\/h4>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ARCHIVELOG<\/mark> modu, redo loglar\u0131n\u0131n d\u00f6n\u00fc\u015ft\u00fcr\u00fclmeden \u00f6nce bir yedek olarak saklanmas\u0131n\u0131 sa\u011flar. Redo loglar ar\u015fivlenerek hem veri kurtarma hem de Data Guard i\u00e7in gerekli redo transferi sa\u011flan\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SELECT LOG_MODE FROM V$DATABASE;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>LOG_MODE\n---------------------------------------\nNOARCHIVELOG<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><\/p>\n<\/blockquote>\n\n\n\n<p>E\u011fer <code>NOARCHIVELOG<\/code> d\u00f6nerse, \u015fu komutlarla ARCHIVELOG modu a\u00e7\u0131lmal\u0131d\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SHU IMMEDIATE; \nSTARTUP MOUNT;\nALTER DATABASE ARCHIVELOG;\nALTER DATABASE OPEN;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.4 Flash Recovery Area (FRA) Ayarlar\u0131<\/h4>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong><code>db_recovery_file_dest<\/code><\/strong> <\/mark>parametresi ayarlanmazsa, Oracle veritaban\u0131 <strong>ar\u015fiv log<\/strong> dosyalar\u0131n\u0131 <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">$ORACLE_HOME\/dbs<\/mark><\/strong> dizinine kaydeder.<\/p>\n\n\n\n<p>\u00d6ncelikle, FRA&#8217;n\u0131n ne kadar disk alan\u0131 kullanabilece\u011fini belirlemek i\u00e7in <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><code>db_recovery_file_dest_size<\/code> <\/mark>parametresini ayarlaman\u0131z gerekir. Bu de\u011feri, FRA i\u00e7in tahsis etmek istedi\u011finiz maksimum disk alan\u0131na g\u00f6re belirleyin.<\/p>\n\n\n\n<p>FRA&#8217;n\u0131n depolanaca\u011f\u0131 bir dizin belirlemeniz i\u00e7in <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">db_recovery_file_dest<\/mark> parametresini ayarlaman\u0131z gerekir. Bu dizin genellikle veritaban\u0131n\u0131z\u0131n yede\u011fi, log dosyalar\u0131 ve geri y\u00fckleme verileri i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHO PARAMETER DB_RECOVERY_FILE_DEST<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>NAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ----------------------------\ndb_recovery_file_dest\t\t     string\ndb_recovery_file_dest_size\t     big integer 0<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/u01\/FRA\nchown -R oracle:oinstall \/u01\/FRA\nchmod -R 775 \/u01\/FRA<\/code><\/pre>\n\n\n\n<p>Oracle veritaban\u0131na <strong>Flash Recovery Area (FRA)<\/strong>&#8216;y\u0131 kullanmaya ba\u015flatmak i\u00e7in a\u015fa\u011f\u0131daki SQL komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rarak veritaban\u0131n\u0131n FRA parametrelerini ayarlay\u0131n:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER SYSTEM SET db_recovery_file_dest_size = 3G SCOPE=BOTH;\nALTER SYSTEM SET db_recovery_file_dest = '\/u01\/FRA' SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<p>Ayarlamalar\u0131n\u0131z\u0131 do\u011frulamak i\u00e7in \u015fu sorgular\u0131 \u00e7al\u0131\u015ft\u0131rarak yap\u0131land\u0131rman\u0131z\u0131 kontrol edebilirsiniz:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW PARAMETER db_recovery_file_dest;\n\nNAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- -----------------------------\ndb_recovery_file_dest\t\t     string\t \/u01\/FRA\ndb_recovery_file_dest_size\t     big integer 3G<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.4 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">DB_NAME VE DB_UNIEUQ_NAME  <\/mark>Kontrol\u00fc<\/h4>\n\n\n\n<p>DB_NAME ve DB_UNIQUE_NAME Sorgulama:<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SHO PARAMETER DB_NAME<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>NAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ----------------------------\ndb_name \t\t\t     string\t orac<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SHO PARAMETER DB_UNIQUE_NAME<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>NAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ----------------------------\ndb_unique_name\t\t\t     string\t orac<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.5 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">SERVICE  <\/mark>Kontrol\u00fc<\/h4>\n\n\n\n<p>Primary Database Sunucusunda <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">tnsnames.ora<\/mark> dosyas\u0131n\u0131 kullanarak Service bilgilerinin Eklenmesi: <\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>vi \/u01\/app\/oracle\/product\/19c\/dbhome_1\/network\/admin\/tnsnames.ora<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ORAC =\n    (DESCRIPTION =\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))\n        (CONNECT_DATA =\n            (SERVER = DEDICATED)\n            (SERVICE_NAME = orac)\n        )\n    )\n\nORACDG =\n    (DESCRIPTION =\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.12)(PORT = 1521))\n        (CONNECT_DATA =\n            (SERVER = DEDICATED)\n            (SERVICE_NAME = oracdg)\n        )\n    )<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.1.6 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">DG_CONFIG<\/mark>,<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\"> LOG_ARCHIVE_DEST VE LOG_ARCHIVE_DEST_STATE  <\/mark>Kontrol\u00fc<\/h4>\n\n\n\n<p><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">LOG_ARCHIVE_CONFIG<\/mark><\/code>, Oracle Data Guard yap\u0131land\u0131rmas\u0131nda kullan\u0131lan bir parametredir ve veritaban\u0131 ar\u015fivleme konfig\u00fcrasyonunun y\u00f6netilmesine yard\u0131mc\u0131 olur. \u00d6zellikle, <strong>Data Guard<\/strong> ortam\u0131nda <strong>primary<\/strong> and <strong>standby<\/strong> veritabanlar\u0131 aras\u0131ndaki <strong>log shipping (yaz\u0131l\u0131m g\u00fcnl\u00fc\u011f\u00fc g\u00f6nderimi)<\/strong> i\u015flemlerinin d\u00fczg\u00fcn \u00e7al\u0131\u015fabilmesi i\u00e7in kritik bir parametredir.<\/p>\n\n\n\n<p>DG_CONFIG=(PROD_DB_UNIQUE_NAME,STANDBY_DB_UNIQUE_NAME)<\/p>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0\"><code>SHO PARAMETER LOG_ARCHIVE_CONFIG<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>NAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ----------------------------\nlog_archive_config\t\t     string<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\" style=\"margin-top:0;margin-bottom:0;font-size:clamp(0.875rem, 0.875rem + ((1vw - 0.2rem) * 0.195), 1rem);\"><code>ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orac,oracdg)' SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<p>Oracle veritaban\u0131 y\u00f6netiminde <strong><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">LOG_ARCHIVE_DEST<\/mark><\/code><\/strong> and <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><code>LOG_ARCHIVE_DEST<\/code>_STATE<\/mark><\/strong> parametreleri, <strong>archive log<\/strong> dosyalar\u0131n\u0131n hedeflere y\u00f6nlendirilmesi ve bu hedeflerin durumlar\u0131n\u0131n y\u00f6netilmesi i\u00e7in kullan\u0131l\u0131r. Bu parametreler, \u00f6zellikle <strong>Data Guard<\/strong> and <strong>High Availability<\/strong> senaryolar\u0131nda \u00e7ok \u00f6nemlidir.<\/p>\n\n\n\n<p>SERVICE= tnsnames.ora dosyas\u0131nda yazd\u0131\u011f\u0131m\u0131z service ismi olmal\u0131.<\/p>\n\n\n\n<pre class=\"wp-block-code\" style=\"margin-top:0;margin-bottom:0;font-size:clamp(0.875rem, 0.875rem + ((1vw - 0.2rem) * 0.195), 1rem);\"><code>ALTER SYSTEM SET log_archive_dest_state_2=DEFER SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code wp-container-content-9cfa9a5a\" style=\"margin-top:0;margin-bottom:0;font-size:clamp(0.875rem, 0.875rem + ((1vw - 0.2rem) * 0.195), 1rem);\"><code>ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'SERVICE=ORACDG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracdg' SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<p>Dataguard sunucumuz i\u00e7in belirledi\u011fimiz de\u011ferleri ise \u015f\u00f6yle:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DB_NAME: orac<\/li>\n\n\n\n<li>DB_UNIQUE_NAME: oracdg<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2.<strong>2 Standby <strong>Sunucu<\/strong> <\/strong>Haz\u0131rl\u0131\u011f\u0131<\/h3>\n\n\n\n<p>Standby Database sunucusu ise a\u015fa\u011f\u0131daki yaz\u0131n\u0131n yaln\u0131zca 3.1 Oracle Database Binary Kurulumu ad\u0131m\u0131na kadar (3.1 dahil) takip edilerek kurulmal\u0131d\u0131r.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/oraclius.com.tr\/en\/oracle-19c-single-instance-veritabani-kurulumu\/\" target=\"_blank\" rel=\" noreferrer noopener nofollow\">Single Instance Kurulum<\/a><\/div>\n<\/div>\n\n\n\n<p>Standby Database sunucumuzun <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">\/etc\/hosts<\/mark> dosyas\u0131na Primary sunucumuzun bilgilerini ekleyelim.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69f62d5d94fbf&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69f62d5d94fbf\" class=\"wp-block-image aligncenter size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"199\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2.png\" alt=\"\" class=\"wp-image-360\" srcset=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2.png 720w, https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/resim-1-2-300x83.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.1 Profile Dosyas\u0131n\u0131n Ayarlanmas\u0131<\/h4>\n\n\n\n<p>Standby Sunucumuzda profile dosyas\u0131n\u0131n olu\u015fturulmas\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi .profile_db<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>export ORACLE_HOSTNAME=oraclius.dg\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/19c\/dbhome_1\nexport ORACLE_UNQNAME=oracdg\nexport ORACLE_BASE=\/u01\/app\/oracle\nexport ORACLE_SID=oracdg\n\nexport PATH=$ORACLE_HOME\/bin:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=\\$ORACLE_HOME\/jlib:\\$ORACLE_HOME\/rdbms\/jlib\nexport TNS_ADMIN=$ORACLE_HOME\/network\/admin\n\nexport TMPDIR=\/tmp\nexport TMP=\/tmp<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.2 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">SERVICE  <\/mark>Kontrol\u00fc<\/h4>\n\n\n\n<p>Standby Database Sunucusunda <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">tnsnames.ora<\/mark> dosyas\u0131n\u0131 kullanarak Service bilgilerinin Eklenmesi: <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi \/u01\/app\/oracle\/product\/19c\/dbhome_1\/network\/admin\/tnsnames.ora<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ORAC =\n    (DESCRIPTION =\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))\n        (CONNECT_DATA =\n            (SERVER = DEDICATED)\n            (SERVICE_NAME = orac)\n        )\n    )\n\nORACDG =\n    (DESCRIPTION =\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.12)(PORT = 1521))\n        (CONNECT_DATA =\n            (SERVER = DEDICATED)\n            (SERVICE_NAME = oracdg)\n        )\n    )<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.3 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">Password Dosyas\u0131n\u0131n Standby Sunucuya Kopyalanmas\u0131<\/mark><\/h4>\n\n\n\n<p>Password file&#8217;\u0131n\u0131n Primary Sunucudan Standby Sunucuya kopyalanmas\u0131:<\/p>\n\n\n\n<p>&#8211;Primary &gt; Standby<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>scp \/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/orapworac oracle@10.10.10.12:\/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/orapworacdg<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.4 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">Audit File Dizininin Ayarlanmas\u0131<\/mark><\/h4>\n\n\n\n<p><strong><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">AUDIT_FILE_DEST<\/mark><\/code><\/strong> parametresi, Oracle <strong>Data Guard<\/strong> yap\u0131land\u0131rmas\u0131nda, \u00f6zellikle <strong>audit (denetim)<\/strong> verilerini depolamak i\u00e7in kullan\u0131lan bir <strong>yol<\/strong> belirtir. Bu parametre, <strong>primary veritaban\u0131<\/strong> and <strong>standby veritabanlar\u0131<\/strong> aras\u0131nda <strong>audit<\/strong> verilerinin nas\u0131l toplanaca\u011f\u0131n\u0131 ve depolanaca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<p>Primary Database Sunucusundaki path&#8217;in benzerini Standby Database Sunucusunda olu\u015fturulmas\u0131 gerekir.<\/p>\n\n\n\n<p>&#8212; Primary:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sho parameter audit_file_dest<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>NAME\t\t\tTYPE\t VALUE\n----------------------  -------  ---------------------------------\naudit_file_dest         string   \/u01\/app\/oracle\/admin\/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">orac<\/mark>\/adump<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>&#8212; Standby:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/u01\/app\/oracle\/admin\/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">oracdg<\/mark>\/adump<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.5 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">Pfile Olu\u015fturma<\/mark><\/h4>\n\n\n\n<p>Production Database&#8217;den Spfile Pfile olu\u015fturup Standby sunucusuna at\u0131lmas\u0131 gerekir. Spfile&#8217;\u0131n nerede oldu\u011funu \u00f6\u011frenelim:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHO PARAMETER SPFILE;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>NAME\t\t\tTYPE\t VALUE\n----------------------  -------  ---------------------------------------------------------\nspfile                  string  \/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/spfileorac.ora<\/code><\/pre>\n\n\n\n<p>Spfile&#8217;dan Pfile Olu\u015fturup Standby Sunucumuza kopyalama:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PFILE='\/home\/oracle\/pfile_for_duplicate.ora' FROM SPFILE='\/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/spfileorac.ora';<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>scp \/home\/oracle\/pfile_for_duplicate.ora oracle@10.10.10.12:\/home\/oracle\/pfile_for_duplicate.ora<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>Standby Database&#8217;e at\u0131lan pfile&#8217;\u0131n d\u00fczeltilmesi gerekir. Instance id ile ba\u015flayan sat\u0131rlar\u0131n silinmesi(sadece * ile ba\u015flayanlar kalmal\u0131) ve Standby database&#8217;e g\u00f6re ayarlanmas\u0131 gerekir.<\/p>\n\n\n\n<p>Pfile ilk hali:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>orac.__data_transfer_cache_size=0\norac.__db_cache_size=1845493760\norac.__inmemory_ext_roarea=0\norac.__inmemory_ext_rwarea=0\norac.__java_pool_size=16777216\norac.__large_pool_size=16777216\norac.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\norac.__pga_aggregate_target=117440512\norac.__sga_target=2147483648\norac.__shared_io_pool_size=16777216\norac.__shared_pool_size=234881024\norac.__streams_pool_size=0\norac.__unified_pga_pool_size=0\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/orac\/adump'\n*.audit_trail='db'\n*.compatible='19.0.0'\n*.control_files='\/u01\/app\/oracle\/oradata\/ORAC\/control01.ctl','\/u01\/app\/oracle\/oradata\/ORAC\/control02.ctl'\n*.db_block_size=8192\n*.db_name='orac'\n*.db_recovery_file_dest_size=3221225472\n*.db_recovery_file_dest='\/u01\/FRA'\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=oracXDB)'\n*.local_listener='LISTENER_ORAC'\n*.log_archive_config='DG_CONFIG=(orac,oracdg)'\n*.log_archive_dest_2='SERVICE=ORACDG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracdg'\n*.log_archive_dest_state_2='DEFER'\n*.memory_max_target=0\n*.memory_target=0\n*.nls_language='AMERICAN'\n*.nls_territory='AMERICA'\n*.open_cursors=300\n*.pga_aggregate_target=104857600\n*.processes=300\n*.remote_login_passwordfile='EXCLUSIVE'\n*.sga_target=2147483648\n*.undo_tablespace='UNDOTBS1'\n*.use_large_pages='FALSE'<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/u01\/app\/oracle\/oradata\/ORACDG\/\nmkdir -p \/u01\/FRA<\/code><\/pre>\n\n\n\n<p>Eklenecek parametreler:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>*.log_archive_dest_1='LOCATION=\/u01\/FRA'\n*.standby_file_management='AUTO'\n*.fal_server='orac'\n*.fal_client='oracdg'\n*.db_unique_name='oracdg'\n*.parameter_value_convert 'ORAC','ORACDG'\n*.set db_file_name_convert='\/u01\/app\/oracle\/oradata\/ORAC', '\/u01\/app\/oracle\/oradata\/ORACDG'\n*.set log_file_name_convert='\/u01\/app\/oracle\/oradata\/ORAC', '\/u01\/app\/oracle\/oradata\/ORACDG'<\/code><\/pre>\n\n\n\n<p>Pfile son hali:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>*.audit_file_dest='\/u01\/app\/oracle\/admin\/oracdg\/adump'\n*.audit_trail='db'\n*.compatible='19.0.0'\n*.control_files='\/u01\/app\/oracle\/oradata\/ORACDG\/control01.ctl','\/u01\/app\/oracle\/oradata\/ORACDG\/control02.ctl'\n*.db_block_size=8192\n*.db_name='orac'\n*.db_unique_name='oracdg'\n*.db_recovery_file_dest_size=3221225472\n*.db_recovery_file_dest='\/u01\/FRA'\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.log_archive_dest_1='LOCATION=\/u01\/FRA'\n*.standby_file_management='AUTO'\n*.fal_server='orac'\n*.fal_client='oracdg'\n*.db_unique_name='oracdg'\n*.db_file_name_convert='\/u01\/app\/oracle\/oradata\/ORAC', '\/u01\/app\/oracle\/oradata\/ORACDG'\n*.log_file_name_convert='\/u01\/app\/oracle\/oradata\/ORAC', '\/u01\/app\/oracle\/oradata\/ORACDG'\n*.log_archive_config='DG_CONFIG=(orac,oracdg)'\n*.log_archive_dest_2='SERVICE=ORACDG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracdg'\n*.log_archive_dest_state_2='DEFER'\n*.memory_max_target=0\n*.memory_target=0\n*.nls_language='AMERICAN'\n*.nls_territory='AMERICA'\n*.open_cursors=300\n*.pga_aggregate_target=104857600\n*.processes=300\n*.remote_login_passwordfile='EXCLUSIVE'\n*.sga_target=2147483648\n*.undo_tablespace='UNDOTBS1'\n*.use_large_pages='FALSE'<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2.2.6 <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-contrast-color\">Listener.ora Dosyas\u0131n\u0131 Static Registlirasyon ile D\u00fczenlenmesi<\/mark><\/h4>\n\n\n\n<p>listener.ora dosyas\u0131na a\u015fa\u011f\u0131daki sat\u0131r eklenmesi gerekir. <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">GLOBAL_DBNAME <\/mark>and <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SID_NAME <\/mark>de\u011ferleri <mark style=\"background-color:rgba(0, 0, 0, 0);color:#ff0000\" class=\"has-inline-color\">Case Sensitive<\/mark>&#8216;dir<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">GLOBAL_DBNAME <\/mark>=&gt; tnsnames.ora dosyas\u0131ndaki service name.<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SID_NAME <\/mark>=&gt; Oracle SID<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>LISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = oraclius.dg)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER=\n  (SID_LIST=\n    (SID_DESC=\n      (GLOBAL_DBNAME=oracdg)\n      (SID_NAME=oracdg)\n      (ORACLE_HOME=\/u01\/app\/oracle\/product\/19c\/dbhome_1)\n    )\n  )<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>Listener Stop, Start edilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>lsnrctl stop listener\nlsnrctl start listener<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>lsnrctl status\n\n\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-MAR-2025 16:25:53\n\nCopyright (c) 1991, 2022, Oracle.  All rights reserved.\n\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production\nStart Date                05-MAR-2025 13:21:50\nUptime                    0 days 3 hr. 4 min. 3 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/oracle\/product\/19c\/dbhome_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/orac\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.11)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.13)(PORT=1521)))\nServices Summary...\nService \"oracdg\" has 1 instance(s).\n  Instance \"oracdg\", status <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">UNKNOWN<\/mark>, has 1 handler(s) for this service...\nThe command completed successfully<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. <strong><strong>Oracle Data Guard Test A\u015famalar\u0131<\/strong><\/strong><\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">3.1 Startup Nomount<\/h4>\n\n\n\n<p>Standby Database sunucumuzu nomount modunda Production Sunucumuzdan kopyalay\u0131p birka\u00e7 de\u011fi\u015fiklik yapt\u0131\u011f\u0131m\u0131z pfile ile a\u00e7\u0131yoruz:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>. .profile_db\nsqlplus \/ as sysdba\nstartup nomount pfile='\/home\/oracle\/pfile_for_duplicate.ora';<\/code><\/pre>\n\n\n\n<p>Database nomount modda a\u00e7t\u0131ktan sonra listener kontrol edelim. Nomount modda <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">UNKNOWN <\/mark>and <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">BLOCKEN <\/mark>\u015feklinde 2 servis olmal\u0131.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>lsnrctl status\n\n\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-MAR-2025 16:25:53\n\nCopyright (c) 1991, 2022, Oracle.  All rights reserved.\n\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production\nStart Date                05-MAR-2025 13:21:50\nUptime                    0 days 3 hr. 4 min. 3 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/oracle\/product\/19c\/dbhome_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/orac\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.11)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.13)(PORT=1521)))\nServices Summary...\nService \"oracdg\" has 1 instance(s).\n  Instance \"oracdg\", status <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">UNKNOWN<\/mark>, has 1 handler(s) for this service...\n  Instance \"oracdg\", status <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">BLOCKED<\/mark>, has 1 handler(s) for this service...\nThe command completed successfully<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3.2 Test Connection<\/h4>\n\n\n\n<p>Primary ve Standby sunucuda da tnsping testi yap\u0131lmas\u0131 gerekir. Test s\u0131ras\u0131nda sunuculardaki listenerlar a\u00e7\u0131k olmal\u0131. Sqlplus ile test i\u015fleminde password file dosyas\u0131 \u00f6nceki ad\u0131mlarda kopyaland\u0131\u011f\u0131 i\u00e7in Standby sunucumuzun sys \u015fifresi Prod ile ayn\u0131d\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>tnsping ORAC\ntnsping ORACDG\n\nsqlplus sys\/&lt;sifre&gt;@ORAC as sysdba\nsqlplus sys\/&lt;sifre&gt;@ORACDG as sysdba<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3.3 Duplicate.sh Script&#8217;inin Haz\u0131rlanmas\u0131<\/h4>\n\n\n\n<p>Oracle Home dizinine duplicate.sh ad\u0131nda bir dosya olu\u015fturup a\u015fa\u011f\u0131daki sat\u0131rlar\u0131 ekleyelim:<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>rman &lt;&lt; EOF\nconnect target sys\/1234@ORAC\nconnect auxiliary sys\/1234@ORACDG\n  run {\n    allocate channel prmy1 type disk;\n    allocate channel prmy2 type disk;\n    allocate channel prmy3 type disk;\n    allocate channel prmy4 type disk;\n    \n    allocate auxiliary channel stby type disk;\n    duplicate target database for standby from active database section size 512G;\n  }\nEOF<\/code><\/pre>\n\n\n\n<p>Olu\u015fturdu\u011fumuz script dosyas\u0131na execute yetkisi verelim:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod +x duplicate.sh<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. <strong><strong>Oracle Data Guard Kurulum<\/strong><\/strong><\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">4.1 Haz\u0131rlad\u0131\u011f\u0131m\u0131z Duplicate.sh Script&#8217;inin \u00c7al\u0131\u015ft\u0131r\u0131lmas\u0131<\/h4>\n\n\n\n<p>Duplicate.sh script&#8217;i ister prduction ister Standby sunucuda \u00e7al\u0131\u015ft\u0131r\u0131labilir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sh duplicate.sh\n...\nFinished Duplicate Db at 05-APR-25\nreleased channel: prmy1\nreleased channel: prmy2\nreleased channel: prmy3\nreleased channel: prmy4\nreleased channel: stby\n\nRMAN> \n\nRecovery Manager complete.<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4.2 Duplicate Sonras\u0131 Yap\u0131lmas\u0131 Gerekenler<\/h4>\n\n\n\n<p>Duplicate sonras\u0131nda kendi haz\u0131rlad\u0131\u011f\u0131m\u0131z pfile&#8217;\u0131 kullanarak devam edece\u011fiz.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SPFILE='\/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/spfileoracdg.ora' from pfile='\/home\/oracle\/pfile_for_duplicate.ora';<\/code><\/pre>\n\n\n\n<p>Database Spfile&#8217;\u0131 kullanmas\u0131 i\u00e7in kapat\u0131l\u0131p a\u00e7\u0131lmas\u0131 gerekir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>shu immediate;<\/code><\/pre>\n\n\n\n<p>Daha sonra database a\u00e7\u0131labilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>startup mount<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL> sho parameter spfile\n\nNAME      TYPE\t   VALUE\n--------- -------- ----------------------------------------------------------\nspfile\t  string   \/u01\/app\/oracle\/product\/19c\/dbhome_1\/dbs\/spfileoracdg.ora<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.3 Duplicate Sonras\u0131 Standby Dosya Kontrol\u00fc<\/h4>\n\n\n\n<p>Duplicate sonras\u0131 standby logfile dosyalar\u0131 olu\u015fmazsa elle olu\u015fturulmas\u0131 gerekir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM V$STANDBY_LOG;<\/code><\/pre>\n\n\n\n<p>Standby Redolog dosyalar\u0131n\u0131 birincil redolog dosyalar\u0131 ile ayn\u0131 dizine, ayn\u0131 boyutta ve bir adet fazla say\u0131da olmak \u00fczere olu\u015fturulmas\u0131 gerekir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT GROUP#,MEMBER FROM V$LOGFILE;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>    GROUP# MEMBER\n---------- --------------------------------------------------------------------------------\n\t 3 \/u01\/app\/oracle\/oradata\/ORACDG\/redo03.log\n\t 2 \/u01\/app\/oracle\/oradata\/ORACDG\/redo02.log\n\t 1 \/u01\/app\/oracle\/oradata\/ORACDG\/redo01.log<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT GROUP#,BYTES FROM V$LOG;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    GROUP# BYTES\n---------- ----------\n\t 1  209715200\n\t 3  209715200\n\t 2  209715200<\/code><\/pre>\n\n\n\n<p>3 Adet Log file mevcut. Ayn\u0131 path ve boyuttan 1 adet fazla Standby Logfile olu\u015fturulmas\u0131 gerekir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>alter database add standby logfile group 11 ('\/u01\/app\/oracle\/oradata\/ORACDG\/standby11.log') SIZE 209715200;\nalter database add standby logfile group 12 ('\/u01\/app\/oracle\/oradata\/ORACDG\/standby12.log') SIZE 209715200;\nalter database add standby logfile group 13 ('\/u01\/app\/oracle\/oradata\/ORACDG\/standby13.log') SIZE 209715200;\nalter database add standby logfile group 14 ('\/u01\/app\/oracle\/oradata\/ORACDG\/standby14.log') SIZE 209715200;<\/code><\/pre>\n\n\n\n<p>Standby Logfile&#8217;lar\u0131 olu\u015fturduktan sonra kontrol edelim:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT GROUP#, TYPE, MEMBER FROM V$LOGFILE;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>    GROUP# TYPE    MEMBER\n---------- ------- -----------------------------------------------------------------------------\n\t 3 ONLINE  \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/onlinelog\/o1_mf_3_mwkgp6t2_.log\n\t 2 ONLINE  \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/onlinelog\/o1_mf_2_mwkgp6j5_.log\n\t 1 ONLINE  \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/onlinelog\/o1_mf_1_mwkgp66h_.log\n\t11 STANDBY \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/standby1.log\n\t12 STANDBY \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/standby2.log\n\t13 STANDBY \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/standby3.log\n\t14 STANDBY \/u01\/app\/oracle\/oradata\/ORACDG\/ORACDG\/standby4.log\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4.4 Apply Ba\u015flat\u0131lmas\u0131<\/h4>\n\n\n\n<p>Apply&#8217;\u0131 ba\u015flatmadan \u00f6nce Production Sunucumuzda <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">log_archive_dest_state_2<\/mark> parametresi DEFER olarak ayarlanm\u0131\u015ft\u0131. Bu de\u011fer Production sunucumuzda ENABLE olarak ayarlan\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER SYSTEM SET log_archive_dest_state_2=ENABLE SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>Standby Sunucumuzda Apply ba\u015flat\u0131lmas\u0131:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.5 Son Kontroller<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL> r\n  1* select name, value, time_computed from v$dataguard_stats\n\nNAME\t\t    VALUE\t\t        TIME_COMPUTED\n------------------- --------------------------- -----------------------------\ntransport lag\t        +00 00:00:00\t\t04\/05\/2025 21:17:43\napply lag\t        +00 00:00:00\t\t04\/05\/2025 21:17:43\napply finish time       +00 00:00:00\t\t04\/05\/2025 21:17:43\nestimated startup time\t14\t                04\/05\/2025 21:17:43<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>select process,status, thread#, sequence#,block#,blocks from v$managed_standby;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>select sequence#, first_time, next_time, applied from v$archived_log order by 1;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel; <\/code><\/pre>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.<\/p>","protected":false},"author":1,"featured_media":364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Data Guard Kurulumu: RMAN DUPLICATE<\/title>\n<meta name=\"description\" content=\"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oraclius.com.tr\/en\/oracle-data-guard-kurulumu-rman-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Guard Kurulumu: RMAN DUPLICATE\" \/>\n<meta property=\"og:description\" content=\"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oraclius.com.tr\/en\/oracle-data-guard-kurulumu-rman-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"oraclius\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-31T10:43:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-05T18:25:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"YUNUS EMRE ATAY\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"YUNUS EMRE ATAY\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/\"},\"author\":{\"name\":\"YUNUS EMRE ATAY\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"headline\":\"Oracle Data Guard Kurulumu: RMAN DUPLICATE\",\"datePublished\":\"2024-12-31T10:43:51+00:00\",\"dateModified\":\"2025-04-05T18:25:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/\"},\"wordCount\":1146,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/banner.png\",\"articleSection\":[\"Genel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/\",\"name\":\"Oracle Data Guard Kurulumu: RMAN DUPLICATE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/banner.png\",\"datePublished\":\"2024-12-31T10:43:51+00:00\",\"dateModified\":\"2025-04-05T18:25:36+00:00\",\"description\":\"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/banner.png\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/banner.png\",\"width\":640,\"height\":640,\"caption\":\"oracle data guard\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-guard-kurulumu-rman-duplicate\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/oraclius.com.tr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Guard Kurulumu: RMAN DUPLICATE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/\",\"name\":\"oraclius\",\"description\":\"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.\",\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"alternateName\":\"oracle\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oraclius.com.tr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\",\"name\":\"YUNUS EMRE ATAY\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"width\":512,\"height\":512,\"caption\":\"YUNUS EMRE ATAY\"},\"logo\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\"},\"description\":\"oracle\",\"sameAs\":[\"https:\\\/\\\/oraclius.com.tr\",\"https:\\\/\\\/instagram.com\\\/lemratal\",\"https:\\\/\\\/linkedin.com\\\/in\\\/emreatayy\",\"https:\\\/\\\/www.youtube.com\\\/@lemratal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Data Guard Kurulumu: RMAN DUPLICATE","description":"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.","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:\/\/oraclius.com.tr\/en\/oracle-data-guard-kurulumu-rman-duplicate\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Data Guard Kurulumu: RMAN DUPLICATE","og_description":"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.","og_url":"https:\/\/oraclius.com.tr\/en\/oracle-data-guard-kurulumu-rman-duplicate\/","og_site_name":"oraclius","article_published_time":"2024-12-31T10:43:51+00:00","article_modified_time":"2025-04-05T18:25:36+00:00","og_image":[{"width":640,"height":640,"url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png","type":"image\/png"}],"author":"YUNUS EMRE ATAY","twitter_card":"summary_large_image","twitter_misc":{"Written by":"YUNUS EMRE ATAY","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#article","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/"},"author":{"name":"YUNUS EMRE ATAY","@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"headline":"Oracle Data Guard Kurulumu: RMAN DUPLICATE","datePublished":"2024-12-31T10:43:51+00:00","dateModified":"2025-04-05T18:25:36+00:00","mainEntityOfPage":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/"},"wordCount":1146,"commentCount":0,"publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"image":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png","articleSection":["Genel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/","url":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/","name":"Oracle Data Guard Kurulumu: RMAN DUPLICATE","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#primaryimage"},"image":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png","datePublished":"2024-12-31T10:43:51+00:00","dateModified":"2025-04-05T18:25:36+00:00","description":"Oracle Data Guard, birincil veritaban\u0131n\u0131n (Primary Database) bir ya da daha fazla fiziksel veya mant\u0131ksal kopyas\u0131n\u0131 (Standby Database) olu\u015fturarak veri yedekleme ve kurtarma i\u015flemlerini otomatikle\u015ftiren bir Oracle teknolojisidir. Data Guard, felaket kurtarma (\u201cDisaster Recovery\u201d) ve y\u00fck dengesini optimize etme (\u201cLoad Balancing\u201d) gibi avantajlar sunar.","breadcrumb":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#primaryimage","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/banner.png","width":640,"height":640,"caption":"oracle data guard"},{"@type":"BreadcrumbList","@id":"https:\/\/oraclius.com.tr\/oracle-data-guard-kurulumu-rman-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/oraclius.com.tr\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Guard Kurulumu: RMAN DUPLICATE"}]},{"@type":"WebSite","@id":"https:\/\/oraclius.com.tr\/#website","url":"https:\/\/oraclius.com.tr\/","name":"oraclius","description":"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.","publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"alternateName":"oracle","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oraclius.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09","name":"YUNUS EMRE ATAY","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","width":512,"height":512,"caption":"YUNUS EMRE ATAY"},"logo":{"@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg"},"description":"oracle","sameAs":["https:\/\/oraclius.com.tr","https:\/\/instagram.com\/lemratal","https:\/\/linkedin.com\/in\/emreatayy","https:\/\/www.youtube.com\/@lemratal"]}]}},"_links":{"self":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":79,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":585,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/359\/revisions\/585"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media\/364"}],"wp:attachment":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}