{"id":2848,"date":"2013-04-17T22:15:54","date_gmt":"2013-04-17T19:15:54","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=2848"},"modified":"2013-06-26T11:51:28","modified_gmt":"2013-06-26T08:51:28","slug":"oracle-dataguard-kurulum-yapilandirma-ve-yonetimi","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=2848","title":{"rendered":"Oracle DataGuard 11g R2 Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimi"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDataguard.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2849\" alt=\"OracleDataguard\" src=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDataguard.jpg\" width=\"250\" height=\"188\" \/><\/a><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalamezinde Oracle Veritaban\u0131 Enterprise s\u00fcr\u00fcm se\u00e7ene\u011fi ve felaketten kurtarma \u00e7\u00f6z\u00fcm\u00fc olan Oracle DataGuard yap\u0131land\u0131rmas\u0131n\u0131 inceleyce\u011fiz.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard Nedir ?<\/span><\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle Data Guard , Oracle\u2019da y\u00fcksek eri\u015filebilirlik ve beklenmeyen sistem hatalar\u0131 neticesinde olu\u015fabilecek veri kay\u0131plar\u0131n\u0131 en aza hatta s\u0131f\u0131ra indiren oracle veritaban\u0131 ile b\u00fct\u00fcnle\u015fik bir veri koruma eklentisidir. Oracle enterprise s\u00fcr\u00fcm\u00fc gerektirir.B\u00fct\u00fcnle\u015fiktir, ek kurulum gerektirmez. Veritaban\u0131 hizmeti veren birincil sisteme (Primary) ek olarak bir veya daha fazla yedek (Secondary) sistem veya sistemlerin e\u015f zamanl\u0131 veya e\u015f zamanl\u0131 olmayan \u015fekilde e\u015fle\u015ftirilmesi prensibiyle \u00e7al\u0131\u015f\u0131r. \u00c7al\u0131\u015fma prensibi , birincil veritaban\u0131nda olu\u015fan ar\u015fivlenmi\u015f gerid\u00f6n\u00fc\u015f loglar\u0131n\u0131n (Archived Redo Logs) ikincil veritaban\u0131na aktar\u0131lmas\u0131 ve bu loglar\u0131n iki farkl\u0131 y\u00f6ntemle ikincil veritab\u0131na i\u015flenmesine dayan\u0131r. Loglar\u0131n ikincil veritaban\u0131na i\u015flenmesi y\u00f6ntemi e\u015fitlemenin fiziksel (Physical) mi mant\u0131ksal (Logical) m\u0131 oldu\u011funu belirler. bu iki farkl\u0131 i\u015fletim temel farkl\u0131l\u0131klar getirir. Sistemler birbirleriyle \u201cOracle Net\u201d ile haberle\u015firler. Sistemler ayn\u0131 ortamda veya uzak mesefalerde olabilirler. Sistemlerin yerle\u015fimleri ile ilgili bir k\u0131s\u0131tlama yoktur.<\/span><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Fiziksel Bekleme Veritaban\u0131 (Physical Standby Database)<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil veritaban\u0131n birebir kopyas\u0131n\u0131n ikincil veritaban\u0131nda tutulmas\u0131d\u0131r. \u0130kincil veritaban\u0131 birincil veritaban\u0131n birebir kopyas\u0131 olarak haz\u0131rlan\u0131r, birincil veritaban\u0131nda olu\u015fan ar\u015fiv gerid\u00f6n\u00fc\u015f\u00fcm loglar\u0131n\u0131n ikincil veritaban\u0131na uygulanmas\u0131 ile e\u015fitlik sa\u011flanm\u0131\u015f olur. Fiziksel Bekleme Veritabanlar\u0131 a\u00e7\u0131k veritabanlar\u0131 de\u011fillerdir. Startup Mount komutu ile a\u00e7\u0131l\u0131rlar. birincil veritaban\u0131ndan gelen loglar Veritaban\u0131 Kurtarma (Database Recover) mant\u0131\u011f\u0131yla ikincil veritaban\u0131na i\u015flenir. \u0130stenirse ikincil vertaban\u0131 salt-okunur olarak a\u00e7\u0131labilir, fakat bu s\u00fcre zarf\u0131nda loglar i\u015flenmez, biriktirilir. Tekrar i\u015fleme moduna al\u0131narak loglar\u0131n i\u015flenmesine devam edilebilir. Fiziksel Bekleme Veritabanlar\u0131 \u00e7o\u011funlukla felaket durumda kurtarma(disaster recovery) ama\u00e7l\u0131 olarak kullan\u0131l\u0131rlar. Felaket durumunda birincil veritaban\u0131n\u0131n yerine ge\u00e7ecek olan veritaban\u0131 budur. B\u00f6ylece veri kayb\u0131 olmadan ve s\u00fcre kaybetmeden kurtar\u0131m yap\u0131lm\u0131\u015f olur.<\/span><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Mant\u0131ksal Bekleme Veritaban\u0131 (Logical Standby Database)<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil veritaban\u0131n\u0131n mant\u0131ksal olarak bir kopyas\u0131d\u0131r, yani tablolar ve indexler gibi nesneler ayn\u0131d\u0131r fakat datafile dosyalar\u0131n\u0131n d\u00fczeni farkl\u0131l\u0131k g\u00f6sterebilir. Birincil veritaban\u0131ndan gelen loglar SQL c\u00fcmleciklerine \u00e7evrilerek i\u015flenirler. Veritaban\u0131 a\u00e7\u0131kt\u0131r, yani veritaban\u0131 \u00fczerinde raporlama i\u015flemleri yap\u0131labilmektedir.Mant\u0131ksal veritaban\u0131na ait birtak\u0131m k\u0131s\u0131tlamalar vard\u0131r. Baz\u0131 veri tipleri desteklenmemetedir. Ayr\u0131ca sistemdeki e\u015fle\u015fecek tablolar\u0131n birincil anahtar indeksinin olmas\u0131 gerekmektedir. Olu\u015fturulan SQL c\u00fcmlecikler bu birincil anahtarlar kullan\u0131larak i\u015flenmektedir. Mant\u0131ksal veritabanlar\u0131 hem yedekleme i\u00e7in kullan\u0131l\u0131rlar hem de a\u00e7\u0131k veritaban\u0131 olduklar\u0131 i\u00e7in raporlama gibi i\u015flemlerde de kullan\u0131l\u0131rlar. B\u00f6ylece birincil veritaban\u0131n\u0131n \u00fczerinden y\u00fck al\u0131narak performans art\u0131\u015f\u0131 sa\u011flanm\u0131\u015f olur. Ancak baz\u0131 veri tipleri desteklememektedir. \u00d6rne\u011fin Oracle Spatial (shape) vb. veri tiplerini desteklemez.<\/span><\/p>\n<p><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard 3 Farkl\u0131 Se\u00e7enekte Kullan\u0131labilir<\/span><\/strong><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Maksimum Koruma<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu seviyede hi\u00e7bir veri kayb\u0131 olmamas\u0131 sa\u011flan\u0131r. Birincil veritaban\u0131nda olu\u015fan redo log dosyas\u0131 e\u015f zamanl\u0131 olarak en ez bir ikincil veritaban\u0131na kopyalan\u0131p i\u015flenemelidir. E\u011fer bir sorun olur da ikincil veritaban\u0131na i\u015flenemez ise birincil veritaban\u0131 otomatik kapat\u0131l\u0131r.<\/span><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Maksimum Kullan\u0131labilirlik<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu seviye de maksimum korumada oldu\u011fu gibi s\u0131f\u0131r veri kayb\u0131 hedeflenir, fakat hata durumunda veritaban\u0131 kapat\u0131lmaz, commit i\u015flemi yap\u0131lmaz. hata d\u00fczelene kadar maksimum performans seviyesine ge\u00e7ilir. b\u00f6ylece veritaban\u0131n\u0131n devaml\u0131l\u0131\u011f\u0131 sa\u011flan\u0131r. Hata d\u00fczeldikten sonra tekrar maksimum kullan\u0131labilir seviye ge\u00e7ilir.<\/span><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Maksimum Performans<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu seviye varsay\u0131lan seviyedir ve birincil veritaban\u0131n performans\u0131nda azalma olmadan koruma sa\u011flar. Birincil veritaban\u0131nda i\u015flem commit edilir ve online redo log dosyas\u0131na yaz\u0131l\u0131r. Bu redo loglar e\u015fzamans\u0131z olarak ikincil veritaban\u0131na aktar\u0131l\u0131r ve i\u015flenir. Log dosyalar\u0131n\u0131n aktar\u0131lmas\u0131nda sorun olursa sorun d\u00fczeldikten sonra kal\u0131nan yerden i\u015fleme devam edilir.<\/span><\/p>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sistem Gereksinimleri<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sistemler ayn\u0131 donan\u0131m platformlar\u0131na sahip olmal\u0131d\u0131rlar. \u00d6rne\u011fin 64-bit Intel i\u015flemcili Linux sisteme sahip olabilirler. Donan\u0131msal olarak bir k\u0131s\u0131t yoktur. Farkl\u0131 say\u0131da i\u015flemci , ram disk birimlerinden olu\u015fabilirler. Ancak burada Oracle DataGuard sunucumuz i\u00e7in bi\u00e7ti\u011fimiz rol \u00f6nemlidir. E\u011fer sadece verinin bir yede\u011fi g\u00fcvenli bir ortama \u00e7\u0131ks\u0131n d\u00fc\u015f\u00fcncesi varsa donan\u0131m olarak birincil (primary) sunucumuzdan daha d\u00fc\u015f\u00fck bir donan\u0131ma sahip olabilir. Fakat Birincil (Primary) sunucum durdu\u011funda \u0130kincil (Standby) sunucumdan \u00e7al\u0131\u015fma devam etsin d\u00fc\u015f\u00fcncesi varsa o zaman donan\u0131m olarak Birincil (Primary) sunucumuzun y\u00fck\u00fcn\u00fc kald\u0131rabilecek bir sunucu olmal\u0131d\u0131r. Aksi takdirde performans s\u0131k\u0131nt\u0131s\u0131ndan kullan\u0131c\u0131lar\u0131m\u0131z \u00e7al\u0131\u015famaz hale gelebilir. Oracle veritaban\u0131n\u0131n enterprise s\u00fcr\u00fcm olmas\u0131 ve s\u00fcr\u00fcmlerinin ayn\u0131 olmas\u0131 gerekmektedir. Standart s\u00fcr\u00fcmde \u00e7al\u0131\u015fmamaktad\u0131r. Birincil veritaban\u0131n\u0131n ARCHIVELOG modunda \u00e7al\u0131\u015fmas\u0131 gerekmektedir. B\u00fct\u00fcn sistemlerde &#8220;COMPATIBLE&#8221; parametrelerinin ayn\u0131 olmas\u0131 gerekmektedir. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u015eimdi Oracle DataGuard yap\u0131land\u0131rmas\u0131na ge\u00e7ebiliriz.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130\u015fletim sistemi kurulumu i\u00e7in <a title=\"Oracle Enterprise Linux 6.x Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=228\">\u201cOracle Enterprise Linux Kurulumu\u201d<\/a> makalemizi kullanabilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131 kurulumu i\u00e7in tercihimize g\u00f6re;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><a title=\"Oracle Grid Infrastructure ile Single Instance (Standalone) Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=520\">Oracle Grid Infrastructure ile Single Instance (Standalone) Veritaban\u0131 Kurulumu<\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"><a title=\"Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=1565\">Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle Veritaban\u0131 Kurulumu<\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Kurulumda birincil (primary) veritaban\u0131m\u0131z kurulu ve \u00e7al\u0131\u015f\u0131r durumda olmal\u0131d\u0131r. \u0130kincil (standby)\u00a0veritaban\u0131m\u0131z ise sadece <span style=\"text-decoration: underline;\">&#8220;Install Database Software Only&#8221;<\/span> se\u00e7ene\u011fi ile kurulmu\u015f &#8220;netca&#8221; komutu ile &#8220;LISTENER&#8221; servisi yarat\u0131lm\u0131\u015f ve \u00e7al\u0131\u015f\u0131r durumda olmal\u0131d\u0131r. Bununla ilgili ad\u0131mlar\u0131 yukar\u0131da\u00a0ba\u011flant\u0131lar\u0131n\u0131 verdi\u011fim veritaban\u0131 kurulum makalelerinde bulabilirsiniz.\u00a0Ayr\u0131ca birincil (primary) ve \u00a0\u0130kincil (standby) veritaban\u0131 yaz\u0131l\u0131mlar\u0131n\u0131n versiyonlar\u0131 patchset seviyeleri ayn\u0131 olmal\u0131d\u0131r.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda Birincil ve \u0130kincil veritabanlar\u0131ndaki &#8220;\/etc\/hosts&#8221; dosyas\u0131na sunucular\u0131m\u0131z\u0131n bilgileri yaz\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\"># vim \/etc\/hosts\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve sunucular\u0131m\u0131z\u0131n bilgilerini\r\ngiriyoruz.\r\n\r\n192.168.2.121           koraykey-db1.localdomain        koraykey-db1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">192.168.2.122           koraykey-db2.localdomain        koraykey-db2<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil Veritaban\u0131 (Primary Server) Yap\u0131lacak Ayarlar<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">1.<span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\"> \u0130\u015fletim Sistemi ve Veritaban\u0131 kurulum i\u015flemlerimizi tamamlad\u0131ktan sonra \u201cOracle DataGuard\u201d kurulumuna ba\u015flayabiliriz. \u00d6ncelikle Birincil veritaban\u0131m\u0131zda yap\u0131lacak i\u015flemleri yap\u0131yoruz. Veritaban\u0131m\u0131z\u0131n &#8220;ArchiveLog&#8221; modunun a\u00e7\u0131k olmas\u0131 gerekiyor e\u011fer kapal\u0131ysa a\u015fa\u011f\u0131daki i\u015flemlerle a\u00e7\u0131yoruz.<br \/>\n<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 01:57:21 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select log_mode from v$database;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LOG_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ARCHIVELOG<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">E\u011fer yukar\u0131daki gibi archive log modumuz a\u00e7\u0131k de\u011filse (NOARCHIVELOG) a\u00e7mak i\u00e7in<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izlemeliyiz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 tutarl\u0131 bir \u015fekilde kapat\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database closed.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database dismounted.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance shut down.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 \"mount\" modda a\u00e7\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE instance started.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Total System Global Area 1068937216 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Fixed Size                  2235208 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Variable Size             641729720 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database Buffers          419430400 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Redo Buffers                5541888 bytes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database mounted.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 \"ARCHIVELOG\" moda al\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database archivelog;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Tekrar sorgulad\u0131\u011f\u0131m\u0131zda \"ARCHIVELOG\" modda oldu\u011funu g\u00f6r\u00fcyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select log_mode from v$database;   <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LOG_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ARCHIVELOG<\/span><\/pre>\n<p style=\"text-align: justify;\">2. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda ge\u00e7ici Tablespace\u2019lerin haricindeki t\u00fcm aktivitelerin loglanmas\u0131 sa\u011flan\u0131r. Bu komuttan sonra &#8220;NOLOGGING&#8221; olarak ayarlanm\u0131\u015f nesnelerde loglanmaya ba\u015flan\u0131r. B\u00f6ylelikle b\u00fct\u00fcn aktivitelerin log dosyalar\u0131na yaz\u0131lmas\u0131 ve ikincil veritabanlar\u0131na uygulanmas\u0131 sa\u011flanm\u0131\u015f olur.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:00:47 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database force logging;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database altered.<\/span><\/pre>\n<p style=\"text-align: justify;\">3. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda &#8220;DB_NAME&#8221; ve &#8220;DB_UNIQUE_NAME&#8221; parametrelerinin isimlerini \u00f6\u011freniyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:02:21 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; show parameter db_name<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">NAME                                 TYPE        VALUE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------------------------------ ----------- -----<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">db_name                              string      orcl<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; show parameter db_unique_name<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">NAME                                 TYPE        VALUE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------------------------------ ----------- -----<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">db_unique_name                       string      orcl<\/span><\/pre>\n<p style=\"text-align: justify;\">4. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda &#8220;LOG_ARCHIVE_CONFIG&#8221; parametresini ayarl\u0131yoruz. Burda birincil veritaban\u0131m\u0131z\u0131n ismini yaz\u0131yoruz.\u00a0 Burada yazaca\u011f\u0131m\u0131z isimler a\u015fa\u011f\u0131daki gibi birbirinden farkl\u0131 olmal\u0131d\u0131r.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:07:50 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_config='DG_CONFIG=(ORCL,ORCL_STBY)';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span><\/pre>\n<p style=\"text-align: justify;\">5. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda &#8220;remote archive log&#8221; se\u00e7ene\u011fimizi yap\u0131land\u0131r\u0131yoruz. Burada kullanaca\u011f\u0131m\u0131z alan tercihimize g\u00f6re de\u011fi\u015febilir. Biz yap\u0131land\u0131rmam\u0131zda &#8220;Fast Recovery Area&#8221; alan\u0131m\u0131z\u0131 kullanaca\u011f\u0131z.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:16:50 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_dest_2='SERVICE=orcl_stby<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\u00a0 2\u00a0 NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) \r\n  3  DB_UNIQUE_NAME=ORCL_STBY';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_dest_state_2=enable;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span><\/pre>\n<p style=\"text-align: justify;\">6. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda &#8220;LOG_ARCHIVE_FORMAT&#8221;, &#8220;LOG_ARCHIVE_MAX_PROCESSES&#8221;, &#8220;REMOTE_LOGIN_PASSWORDFILE&#8221; parametrelerini a\u015fa\u011f\u0131daki gibi ayarl\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:22:23 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_max_processes=30;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set remote_login_passwordfile=exclusive scope=spfile;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span><\/pre>\n<p style=\"text-align: justify;\">7. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Yukar\u0131daki ayarlar ek olarak Birincil veritaban\u0131ndan \u0130kincil veritaban\u0131na ge\u00e7i\u015fe haz\u0131r olmas\u0131 i\u00e7in a\u015fa\u011f\u0131daki parametrelerimizi ayarl\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:27:58 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set fal_server=orcl_stby;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set standby_file_management=auto;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">System altered.\r\n\r\nBu i\u015flemlerimizden sonra veritaban\u0131m\u0131z\u0131 yeniden ba\u015flatmal\u0131y\u0131z.\r\n\r\nSQL&gt; shu immediate;\r\nSQL&gt; startup;\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">8. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131zda &#8220;tnsnames.ora&#8221; dosyam\u0131z\u0131 a\u015fa\u011f\u0131daki gibi yap\u0131land\u0131r\u0131yoruz. Mevcut olan veritaban\u0131 bilgilerimize ikincil veritaban\u0131m\u0131z\u0131n bilgisinide yaz\u0131yoruz. Bu de\u011fi\u015fikli\u011fi her iki sunucumuzda yap\u0131yoruz. (Birincil ve \u0130kincil). \u0130kincil sunucumuzda veritaban\u0131 kurulumunu &#8220;software only&#8221; yapt\u0131\u011f\u0131m\u0131z i\u00e7in bu dosya mevcut olmayabilir. birincil sunucumuzdan kopyalayabiliriz veya &#8220;\/u01\/app\/oracle\/product\/11.2.0.3\/db\/network\/admin\/tnsnames.ora&#8221; alt\u0131nda kendimiz yarataray a\u015fa\u011f\u0131daki bilgileri girebiliriz.<br \/>\n<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ vim $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki gibi ikincil <\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">veritaban\u0131m\u0131z\u0131 ekliyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># Generated by Oracle configuration tools.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORCL =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (DESCRIPTION =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (ADDRESS = (PROTOCOL = TCP)(HOST = koraykey-db1.localdomain)(PORT = 1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (CONNECT_DATA =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVER = DEDICATED)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVICE_NAME = orcl)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORCL_STBY =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (DESCRIPTION =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (ADDRESS = (PROTOCOL = TCP)(HOST = koraykey-db2.localdomain)(PORT = 1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (CONNECT_DATA =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVER = DEDICATED)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVICE_NAME = orcl)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span><\/pre>\n<p style=\"text-align: justify;\">9. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">E\u011fer Oracle DataGuard kurulumumuzu a\u015fa\u011f\u0131daki elle yap\u0131land\u0131rma se\u00e7ene\u011fi ile kuracaksak <\/span><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil veritaban\u0131m\u0131z\u0131n &#8220;ArchiveLog&#8221; lar\u0131 dahil yede\u011finiz al\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ rman target=\/<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Recovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 16 23:34:36 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">connected to target database: ORCL (DBID=1340705877)<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RMAN&gt; backup database plus archivelog;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Starting backup at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">current log archived<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">using target database control file instead of recovery catalog<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">allocated channel: ORA_DISK_1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: SID=234 device type=DISK<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting archived log backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: specifying archived log(s) in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">input archived log thread=1 sequence=6 RECID=1 STAMP=812935104<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">input archived log thread=1 sequence=7 RECID=2 STAMP=812936102<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: finished piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/2013_04_16\/o1_mf_annnn_TAG20130416T233504_8pvfhrq5_.bkp<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">tag=TAG20130416T233504 comment=NONE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Finished backup at 16-APR-13<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Starting backup at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">using channel ORA_DISK_1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting full datafile backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: specifying datafile(s) in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 8px;\">input datafile file number=00001 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_system_8pv2vzn6_.dbf<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 8px;\">input datafile file number=00003 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_undotbs1_8pv2ww0f_.dbf<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 8px;\">input datafile file number=00002 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_sysaux_8pv2whjw_.dbf\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 8px;\">input datafile file number=00004 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_users_8pv2x7j2_.dbf<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: finished piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/2013_04_16\/o1_mf_nnndf_TAG20130416T233530_8pvfjlo5_.bkp<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">tag=TAG20130416T233530 comment=NONE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting full datafile backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: specifying datafile(s) in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">including current control file in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">including current SPFILE in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: finished piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/2013_04_16\/o1_mf_ncsnf_TAG20130416T233530_8pvfn77s_.bkp<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">tag=TAG20130416T233530 comment=NONE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Finished backup at 16-APR-13<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Starting backup at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">current log archived<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">using channel ORA_DISK_1<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting archived log backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: specifying archived log(s) in backup set<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">input archived log thread=1 sequence=8 RECID=3 STAMP=812936248<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: starting piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: finished piece 1 at 16-APR-13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/2013_04_16\/o1_mf_annnn_TAG20130416T233728_8pvfn8kl_.bkp<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">tag=TAG20130416T233728 comment=NONE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Finished backup at 16-APR-13<\/span><\/pre>\n<p style=\"text-align: justify;\">10. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil veritaban\u0131m\u0131z i\u00e7in &#8220;Control File&#8221; ve PFILE&#8221; yarat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba \r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 23:45:11 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; alter database create standby controlfile as '\/u01\/orainstall\/orcl_stby.ctl';\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; create pfile='\/u01\/orainstall\/initorcl_stby.ora' from spfile;\r\n\r\nFile created.\r\n\r\n-- Burada yaratm\u0131\u015f oldu\u011fumuz \"initorcl_stby.ora\" dosyas\u0131nda ikincil\r\nveritaban\u0131 i\u00e7in d\u00fczenlemeler yap\u0131yoruz.\r\n\r\n$ vim \/u01\/orainstall\/initorcl_stby.ora\r\n\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz \"db_unique_name\" parametremizi ekliyoruz.\r\nMevcut olan di\u011fer iki parametreyide a\u015fa\u011f\u0131daki gibi d\u00fczenliyoruz.\r\n\r\n*.db_unique_name='ORCL_STBY'\r\n*.fal_server='ORCL'\r\n<span style=\"font-size: 10px;\">*.log_archive_dest_2='SERVICE=orcl ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL'<\/span>\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard yap\u0131land\u0131rmam\u0131zda ikincil sunucu taraf\u0131ndaki i\u015flemlerimizi iki ba\u015fl\u0131kta inceleyece\u011fiz.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">A-) \u0130kincil Veritaban\u0131 (Standby Server) Yap\u0131lacak Ayarlar (Elle Yap\u0131land\u0131rma)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">B-) \u0130kincil Veritaban\u0131 (Standby Server) Yap\u0131lacak Ayarlar (RMAN Dublicate)<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil Veritaban\u0131 (Primary Server) Yap\u0131lacak Ayarlar (Elle Yap\u0131land\u0131rma)<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">1. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil veritaban\u0131m\u0131zda e\u011fer yoksa\u00a0 a\u015fa\u011f\u0131daki gerekli dizinlerimizi yarat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ mkdir -p \/u01\/app\/oracle\/oradata\/ORCL\r\n$ cd \/u01\/app\/oracle\/oradata\/ORCL\r\n$ mkdir controlfile\u00a0 datafile\u00a0 onlinelog\r\n\r\n$ mkdir -p \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/\r\n$ cd \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/\r\n$ mkdir archivelog\u00a0 backupset\u00a0 controlfile\u00a0 onlinelog<\/span><\/pre>\n<p style=\"text-align: justify;\">2. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil veritaban\u0131nda yaratt\u0131\u011f\u0131m\u0131z dosyalar\u0131m\u0131z\u0131 ikincil veritaban\u0131m\u0131za kopyal\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki \u0130\u015flemleri \u0130kincil veritaban\u0131nda yap\u0131yoruz.\r\n\r\n-- Birincil veritaban\u0131nda \"controlfile\" dosyam\u0131z\u0131 kopyal\u0131yoruz\r\n<span style=\"font-size: 8px;\">$ scp oracle@koraykey-db1:\/u01\/orainstall\/orcl_stby.ctl \/u01\/app\/oracle\/oradata\/ORCL\/control01.ctl\r\n$ cp \/u01\/app\/oracle\/oradata\/ORCL\/control01.ctl \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/control02.ctl\r\n<\/span>\r\n-- Archivelogs ve Backup dosyalar\u0131m\u0131z\u0131 kopyal\u0131yoruz.\r\n<span style=\"font-size: 8px;\">$ scp -r oracle@koraykey-db1:\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/archivelog \/u01\/app\/oracle\/fast_recovery_area\/ORCL\r\n$ scp -r oracle@koraykey-db1:\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset \/u01\/app\/oracle\/fast_recovery_area\/ORCL\r\n\r\n<\/span>-- Parametre dosyam\u0131z\u0131 kopyal\u0131yoruz\r\n<span style=\"font-size: 10px;\">$ scp oracle@koraykey-db1:\/u01\/orainstall\/initorcl_stby.ora \/u01\/orainstall\/initorcl_stby.ora<\/span>\r\n\r\n-- Password dosyam\u0131z\u0131 kopyal\u0131yoruz\r\n$ scp oracle@koraykey-db1:$ORACLE_HOME\/dbs\/orapworcl $ORACLE_HOME\/dbs<\/span><\/pre>\n<p style=\"text-align: justify;\">3. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda Listener Servisimizi\u00a0 yeniden ba\u015flat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ lsnrctl reload<\/span><\/pre>\n<p style=\"text-align: justify;\">4. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda birincil veritaban\u0131nda al\u0131p kopyalad\u0131\u011f\u0131m\u0131z yede\u011fimizden d\u00f6n\u00fcyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ rman target=\/<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RMAN&gt; <\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RMAN&gt; restore database;<\/span><\/pre>\n<p style=\"text-align: justify;\">5. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Maksimum Koruma ve Maksimum Kullan\u0131labilirlik seviyelerinin kullan\u0131labilmesi i\u00e7in Standby Redo Loglar\u0131n olu\u015fturulmas\u0131 gerekmektedir. Maksimum performans seviyesinde zorunlu de\u011fil fakat kullan\u0131lmas\u0131 performans ve koruma a\u00e7\u0131s\u0131ndan fayda sa\u011flar. Standby Redo Log dosyalar\u0131 bekleme modundanki veritabanlar\u0131nda \u00e7al\u0131\u015f\u0131rlar. Bekleme modunda \u00e7al\u0131\u015fma i\u00e7in dizayn edildiklerinden online redo loglara veya ar\u015fivlenmi\u015f loglara g\u00f6re daha fazla koruma sa\u011flarlar. Olu\u015fturulacak olan Standby Redo Loglar\u0131n boyutlar\u0131n\u0131n mevcut Online Redo Loglar\u0131n boyutlar\u0131yla ayn\u0131 olmas\u0131 gerekmektedir. A\u015fa\u011f\u0131da bir Standby Redo Log dosyalar\u0131n\u0131n olu\u015fturulmas\u0131 g\u00f6sterilmi\u015ftir. Standby Redo Loglar ikincil veritabanlar\u0131nda \u00e7al\u0131\u015f\u0131rlar. Birincil veritab\u0131n\u0131nda olu\u015fturulmas\u0131 \u015fart\u0131 yoktur. Fakat birincil ve ikincil veritabanlar\u0131n\u0131n yer de\u011fi\u015ftirilmesi (switchover) i\u015flemlerinden sonra d\u00fczg\u00fcn \u00e7al\u0131\u015f\u0131labilmesi i\u00e7in birincil veritaban\u0131nda da ayn\u0131 \u015fekilde Standby Redo Loglar\u0131n olu\u015fturulmas\u0131 yararl\u0131 olacakt\u0131r.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Birincil Veritaban\u0131nda olu\u015fturulmas\u0131\r\n\r\n$ sqlplus \/ as sysdba\r\n\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\"><span style=\"font-size: 10px;\">SQL&gt; alter system set standby_file_management=manual;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/online_redo01.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/online_redo02.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/online_redo03.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter system set standby_file_management=auto;<\/span>\r\n\r\n-- \u0130kincil Veritaban\u0131nda olu\u015fturulmas\u0131\r\n\r\n$ sqlplus \/ as sysdba\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo01.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo02.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo03.log') size 512m;<\/span>\r\n<span style=\"font-size: 10px;\">SQL&gt; alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo04.log') size 512m;<\/span>\r\n<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil Veritaban\u0131 (Standby Server) Yap\u0131lacak Ayarlar (RMAN Dublicate)<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">1. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil veritaban\u0131m\u0131zda e\u011fer yoksa\u00a0 a\u015fa\u011f\u0131daki gerekli dizinlerimizi yarat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ mkdir -p \/u01\/app\/oracle\/oradata\/ORCL\r\n$ cd \/u01\/app\/oracle\/oradata\/ORCL\r\n$ mkdir controlfile\u00a0 datafile\u00a0 onlinelog\r\n\r\n$ mkdir -p \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/\r\n$ cd \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/\r\n$ mkdir archivelog\u00a0 backupset\u00a0 controlfile\u00a0 onlinelog<\/span><\/pre>\n<p style=\"text-align: justify;\">2. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Birincil veritaban\u0131nda yaratt\u0131\u011f\u0131m\u0131z dosyalar\u0131m\u0131z\u0131 ikincil veritaban\u0131m\u0131za kopyal\u0131yoruz.<br \/>\n<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Buradaki i\u015flemleri ikincil veritaban\u0131m\u0131zdan yap\u0131yoruz.\r\n\r\n-- Birincil veritaban\u0131nda \"controlfile\" dosyam\u0131z\u0131 kopyal\u0131yoruz<\/span>\r\n<span style=\"font-size: 8px;\"><span style=\"font-family: courier new,courier;\">$scp oracle@koraykey-db1:\/u01\/orainstall\/orcl_stby.ctl \/u01\/app\/oracle\/oradata\/ORCL\/control01.ctl<\/span>\r\n<span style=\"font-family: courier new,courier;\">$cp \/u01\/app\/oracle\/oradata\/ORCL\/control01.ctl \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/control02.ctl<\/span>\r\n\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Parametre dosyam\u0131z\u0131 kopyal\u0131yoruz<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">$ scp oracle@koraykey-db1:\/u01\/orainstall\/initorcl_stby.ora \/u01\/orainstall\/initorcl_stby.ora<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\r\n-- Password dosyam\u0131z\u0131 kopyal\u0131yoruz<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ scp oracle@koraykey-db1:$ORACLE_HOME\/dbs\/orapworcl $ORACLE_HOME\/dbs<\/span><\/pre>\n<p style=\"text-align: justify;\">4. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda &#8220;dublicate&#8221; yap\u0131land\u0131rma kullanabilmek i\u00e7in ikincil sunucumuzdaki &#8220;listener.ora&#8221; dosyam\u0131zda a\u015fa\u011f\u0131daki gibi d\u00fczenleme yapmal\u0131y\u0131z.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ vim \/u01\/app\/oracle\/product\/11.2.0.3\/db\/network\/admin\/listener.ora<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Dosyam\u0131z\u0131 a\u00e7arak a\u015fa\u011f\u0131daki gibi yap\u0131land\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SID_LIST_LISTENER =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (SID_LIST =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (SID_DESC =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (GLOBAL_DBNAME = orcl)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.3\/db)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SID_NAME = orcl)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LISTENER =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (DESCRIPTION_LIST =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (DESCRIPTION =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (ADDRESS = (PROTOCOL = TCP)(HOST = koraykey-db2.localdomain)(PORT = 1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ADR_BASE_LISTENER = \/u01\/app\/oracle<\/span><\/pre>\n<p style=\"text-align: justify;\">5. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda Listener Servisimizi\u00a0 yeniden ba\u015flat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ lsnrctl reload<\/span><\/pre>\n<p style=\"text-align: justify;\">6. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucumuzda &#8220;dublicate&#8221; komutu ile ikincil sunucumuzda &#8220;redo log&#8221; dosyalar\u0131 otomatik olu\u015facakt\u0131r. Bu y\u00fczden sadece birincil veritaban\u0131nda &#8220;redo log&#8221; dosyalar\u0131m\u0131z\u0131 olu\u015fturuyoruz. Standby Redo Loglar ikincil veritabanlar\u0131nda \u00e7al\u0131\u015f\u0131rlar. Birincil veritab\u0131n\u0131nda olu\u015fturulmas\u0131 \u015fart\u0131 yoktur. Fakat birincil ve ikincil veritabanlar\u0131n\u0131n yer de\u011fi\u015ftirilmesi (switchover) i\u015flemlerinden sonra d\u00fczg\u00fcn \u00e7al\u0131\u015f\u0131labilmesi i\u00e7in birincil veritaban\u0131nda da ayn\u0131 \u015fekilde Standby Redo Loglar\u0131n olu\u015fturulmas\u0131 yararl\u0131 olacakt\u0131r.<br \/>\n<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba\r\n<\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">\r\nalter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo01.log') size 512m;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo02.log') size 512m;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo03.log') size 512m;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/ORCL\/standby_redo04.log') size 512m;<\/span><\/pre>\n<p style=\"text-align: justify;\">7. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil veritaban\u0131m\u0131zda &#8220;Dublicate&#8221; komutunu kullanarak Oracle DataGuard yap\u0131land\u0131rmam\u0131z\u0131 yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup nomount pfile='\/u01\/orainstall\/initorcl_stby.ora';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ rman TARGET sys\/parolamiz@ORCL AUXILIARY sys\/parolamiz@ORCL_STBY<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">DUPLICATE TARGET DATABASE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  FOR STANDBY<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  FROM ACTIVE DATABASE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  DORECOVER<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  SPFILE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    SET db_unique_name='orcl_stby' COMMENT 'Standby'<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 8px;\">      SET LOG_ARCHIVE_DEST_2='SERVICE=orcl ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    SET FAL_SERVER='orcl' COMMENT 'Primary'<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  NOFILENAMECHECK;<\/span><\/pre>\n<p style=\"text-align: justify;\">8. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard sunucumuzda &#8220;log&#8221; i\u015flemeyi ba\u015flat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki i\u015flemi ikincil (standby) veritaban\u0131m\u0131zda yap\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 19:29:27 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database disconnect from session;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">E\u011fer i\u015flemimiz hata verirse \u00f6nce a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131p sonras\u0131nda tekrar<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">deniyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database cancel;<\/span><\/pre>\n<p style=\"text-align: justify;\">9. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard veritabanlar\u0131m\u0131zdaki &#8220;Log&#8221; i\u015flenme durumunu inceleyecelim.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Birincil veritaban\u0131nda son archived redo log dosyalar\u0131n\u0131n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">durumuna bak\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Session altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select sequence#, first_time, next_time<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  2  from   v$archived_log<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  3  order by sequence#;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"> SEQUENCE# FIRST_TIME           NEXT_TIME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">---------- -------------------- --------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">         6 17-APR-2013 11:32:15 17-APR-2013 11:43:14<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">         7 17-APR-2013 11:43:14 17-APR-2013 11:47:00<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">         8 17-APR-2013 11:47:00 17-APR-2013 11:48:38<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">         9 17-APR-2013 11:48:38 17-APR-2013 13:14:25<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        10 17-APR-2013 13:14:25 17-APR-2013 13:14:30<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        11 17-APR-2013 13:14:30 17-APR-2013 13:20:32<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        12 17-APR-2013 13:20:32 17-APR-2013 13:20:33<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        13 17-APR-2013 13:20:33 17-APR-2013 14:27:06<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        14 17-APR-2013 14:27:06 17-APR-2013 14:27:09<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        15 17-APR-2013 14:27:09 17-APR-2013 14:53:54<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        16 17-APR-2013 14:53:54 17-APR-2013 14:53:57<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"> SEQUENCE# FIRST_TIME           NEXT_TIME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">---------- -------------------- --------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        17 17-APR-2013 14:53:57 17-APR-2013 14:57:48<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        18 17-APR-2013 14:57:48 17-APR-2013 14:57:51<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        19 17-APR-2013 14:57:51 17-APR-2013 15:12:10<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        20 17-APR-2013 15:12:10 17-APR-2013 15:12:14<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        21 17-APR-2013 15:12:14 17-APR-2013 15:18:25<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        22 17-APR-2013 15:18:25 17-APR-2013 15:18:26<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        23 17-APR-2013 15:18:26 17-APR-2013 15:34:12<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        24 17-APR-2013 15:34:12 17-APR-2013 15:34:13<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        25 17-APR-2013 15:34:13 17-APR-2013 15:44:47<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        26 17-APR-2013 15:44:47 17-APR-2013 15:44:48<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        27 17-APR-2013 15:44:48 17-APR-2013 15:53:22<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"> SEQUENCE# FIRST_TIME           NEXT_TIME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">---------- -------------------- --------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        28 17-APR-2013 15:53:22 17-APR-2013 15:56:15<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        28 17-APR-2013 15:53:22 17-APR-2013 15:56:15<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        29 17-APR-2013 15:56:15 17-APR-2013 15:57:40<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        29 17-APR-2013 15:56:15 17-APR-2013 15:57:40<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        30 17-APR-2013 15:57:40 17-APR-2013 15:57:45<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        30 17-APR-2013 15:57:40 17-APR-2013 15:57:45<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        31 17-APR-2013 16:00:00 17-APR-2013 16:01:02<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        32 17-APR-2013 16:01:02 17-APR-2013 16:01:08<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        33 17-APR-2013 16:01:08 17-APR-2013 16:16:40<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        34 17-APR-2013 16:16:40 17-APR-2013 16:16:43<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        35 17-APR-2013 16:16:43 17-APR-2013 16:24:45<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130kincil veritaban\u0131nda i\u015flenen son archived redo log dosyalar\u0131n\u0131n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">durumuna bak\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Session altered.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select sequence#, first_time, next_time, applied<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  2  from   v$archived_log<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  3  order by sequence#;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"> SEQUENCE# FIRST_TIME           NEXT_TIME            APPLIED<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">---------- -------------------- -------------------- ---------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        27 17-APR-2013 15:44:48 17-APR-2013 15:53:22 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        28 17-APR-2013 15:53:22 17-APR-2013 15:56:15 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        29 17-APR-2013 15:56:15 17-APR-2013 15:57:40 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        30 17-APR-2013 15:57:40 17-APR-2013 15:57:45 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        31 17-APR-2013 16:00:00 17-APR-2013 16:01:02 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        31 17-APR-2013 16:00:00 17-APR-2013 16:01:02 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        32 17-APR-2013 16:01:02 17-APR-2013 16:01:08 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        32 17-APR-2013 16:01:02 17-APR-2013 16:01:08 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        33 17-APR-2013 16:01:08 17-APR-2013 16:16:40 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        33 17-APR-2013 16:01:08 17-APR-2013 16:16:40 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        34 17-APR-2013 16:16:40 17-APR-2013 16:16:43 YES<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"> SEQUENCE# FIRST_TIME           NEXT_TIME            APPLIED<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">---------- -------------------- -------------------- ---------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        34 17-APR-2013 16:16:40 17-APR-2013 16:16:43 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        35 17-APR-2013 16:16:43 17-APR-2013 16:24:45 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        35 17-APR-2013 16:16:43 17-APR-2013 16:24:45 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        36 17-APR-2013 16:24:45 17-APR-2013 16:24:49 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        36 17-APR-2013 16:24:45 17-APR-2013 16:24:49 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        37 17-APR-2013 16:25:38 17-APR-2013 16:25:48 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        38 17-APR-2013 16:25:48 17-APR-2013 16:25:48 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        39 17-APR-2013 16:25:48 17-APR-2013 16:31:19 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        40 17-APR-2013 16:31:19 17-APR-2013 16:32:13 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        41 17-APR-2013 16:32:13 17-APR-2013 16:32:19 YES<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">        42 17-APR-2013 16:32:56 17-APR-2013 16:33:06 YES<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Koruma Modu<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard veritaban\u0131m\u0131zdaki koruma modu varsay\u0131lan olarak &#8220;maximum performance&#8221; olarak gelmektedir. \u0130stersek yaz\u0131m\u0131z\u0131n ba\u015f\u0131nda bahsetti\u011fimiz koruma modlar\u0131ndan kendimize uygun olanla de\u011fi\u015ftirebiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Hangi koruma modunda oldu\u011funu sorguluyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; SELECT protection_mode FROM v$database;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">PROTECTION_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">MAXIMUM PERFORMANCE<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Maximum Availability koruma moduna ge\u00e7mek i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_dest_2='SERVICE=orcl_stby \r\n2&gt; AFFIRM SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL_STBY';<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database set standby database to maximize availability;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Maximum Performance koruma moduna ge\u00e7mek i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_dest_2='SERVICE=orcl_stby\r\n2&gt; NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL_STBY';<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database set standby database to maximize performance;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Maximum Protection koruma moduna ge\u00e7mek i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system set log_archive_dest_2='SERVICE=orcl_stby \r\n2&gt; AFFIRM SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL_STBY';<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database set standby database to maximize protection;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">SwitchOver<\/span><\/strong><\/li>\n<\/ul>\n<p><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard veritaban\u0131m\u0131zda rollerin de\u011fi\u015fimine bakal\u0131m bu yap\u0131land\u0131rmada Birincil veritaban\u0131n\u0131 \u0130kincil, \u0130kincil veritaban\u0131n\u0131 Birincil rol\u00fcne atayaca\u011f\u0131z. (SwitchOver)<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Birincil veritaban\u0131m\u0131z\u0131n ikincil rol\u00fcne ge\u00e7i\u015fi i\u00e7in uygunlu\u011funu sorguluyoruz.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\"Session active\" veya \"to standby\" olmas\u0131 gerekir.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select switchover_status from v$database;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SWITCHOVER_STATUS<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TO STANDBY<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Birincil veritaban\u0131m\u0131zda rol de\u011fi\u015fimini ger\u00e7ekle\u015ftiriyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database commit to switchover to physical standby with session shutdown;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Son olarak birincil veritaban\u0131m\u0131z\u0131 kapat\u0131p \"mount\" moduna al\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130kincil rol\u00fcnden birincil rol\u00fcne ge\u00e7ecek Standby sunucumuzda rol ge\u00e7i\u015fi i\u00e7in<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">uygunlu\u011funu sorguluyoruz. \"Session active\" veya \"to primary\" olmas\u0131 gerekir.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select switchover_status from v$database;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SWITCHOVER_STATUS<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TO PRIMARY<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130kincil rol\u00fcnden birincil rol\u00fcne ge\u00e7irme i\u015flemini ger\u00e7ekle\u015ftiriyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database commit to switchover to primary with session shutdown;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- \u0130kincil rol\u00fcnden birincil rol\u00fcne ge\u00e7en veritaban\u0131m\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Birincil rol\u00fcnden ikincil rol\u00fcne ge\u00e7en yeni standby sunucumuzda \"redolog\"<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">dosyalar\u0131m\u0131z\u0131n i\u015flenmesi i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database using current\r\n2&gt; logfile disconnect from session;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Birincil rol\u00fcnden ikincil rol\u00fcne ge\u00e7en yeni standby veritab\u0131n\u0131m\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131 a\u00e7arken<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORA-10456: cannot open standby database; media recovery session may be in progress<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">hatas\u0131 al\u0131rken a\u015fa\u011f\u0131daki i\u015flemleri uygulad\u0131ktan sonra a\u00e7\u0131lacakt\u0131r.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database cancel;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">FailOver<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard veritaban\u0131m\u0131zda Birincil (Primary) sunucumuz kullan\u0131lmaz hale geldi\u011finde \u0130kincil (Standby) sunucumuzu Birincil rol\u00fcne atamal\u0131y\u0131z. Gerekli d\u00fczeltme i\u015flemlerinden sonra tekrar rolleri de\u011fi\u015ftirebiliriz.\u00a0 (FailOver)<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Kullan\u0131lmaz duruma gelen Birincil veritaban\u0131m\u0131z \"mount\" modunda a\u00e7\u0131labiliyorsa<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">g\u00f6nderilmemi\u015f redo log archive dosyalar\u0131m\u0131z\u0131 a\u015fa\u011f\u0131daki komutla g\u00f6nderiyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter system flush redo to orcl_stby;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- G\u00fcncel ArchiveLog dosyalar\u0131m\u0131z\u0131n durumuna bak\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select unique thread# as thread, max(sequence#) over (partition by thread#)\r\n2&gt; as last from v$archived_log;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- E\u011fer birincil olacak ikincil sunucumuzda olmayan ArchiveLog dosyalar\u0131m\u0131zdan<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">olmayanlar\u0131 kopyalay\u0131p a\u015fa\u011f\u0131daki komut ile kay\u0131t edebiliriz.<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Sorgumuz sonucu olmayan dosya g\u00f6r\u00fcrsek.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select thread#, low_sequence#, high_sequence# from v$archive_gap;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Kopyalad\u0131ktan sonra kay\u0131t edebiliriz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database register physical logfile 'dosyaozellikleri';<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Birincil olacak \u0130kincil sunucumuzda \"redo apply\" i\u015flemini durduruyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database cancel;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database finish;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database activate standby database;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Bu i\u015flem sonucu hata al\u0131rsak eksik dosyalar\u0131n kayd\u0131na devam etmeliyiz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- E\u011fer hatay\u0131 gideremiyorsak ve veri kayb\u0131n\u0131 g\u00f6ze al\u0131n\u0131p \u00e7al\u0131\u015fmaya devam<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">edeceksek a\u015fa\u011f\u0131daki i\u015flemi uygulamal\u0131y\u0131z.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database activate physical standby database;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Birincil olacak \u0130kincil sunucumuzun rol de\u011fi\u015fimi i\u00e7in uygunlu\u011funu<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">sorguluyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select switchover_status from v$database;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SWITCHOVER_STATUS<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TO PRIMARY<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">Bu mesajdan sonra art\u0131k rol de\u011fi\u015fimini yapabiliriz. Birincil olacak ikincil<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">sunucumuzda a\u015fa\u011f\u0131daki i\u015flemi uyguluyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database commit to switchover to primary with session shutdown;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- E\u011fer ortam\u0131m\u0131zda ba\u015fka standby sunucular\u0131m\u0131z varsa a\u015fa\u011f\u0131daki i\u015flemi uyguluyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database using current logfile\r\n2&gt; disconnect from session;\r\n\r\n-- \u0130lk Birincil sunucumuz \"orcl\"i tekrar primary yapmak i\u00e7in \u00f6nce kurulum\r\nad\u0131mlar\u0131 izlenerek stanby yap\u0131l\u0131r sonras\u0131nda \"switchover\" i\u015flemi ile\r\nbirincil olarak de\u011fi\u015ftirilir. Dikkat edilecek konu \" LOG_ARCHIVE_DEST\"\r\nparametresini d\u00fczenlememiz gerekebilir<\/span><\/pre>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">\u0130kincil veritaban\u0131m\u0131z kapat\u0131lmas\u0131 gereken durumlarda sunucumuz a\u00e7\u0131lmas\u0131ndan sonra a\u015fa\u011f\u0131daki i\u015flemlerin yap\u0131lmas\u0131 gerekir. Bu i\u015flemlerle veritaban\u0131m\u0131z yeniden &#8220;read only with apply&#8221; rol\u00fcne getirilir.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- \u0130kinci veritaban\u0131m\u0131z a\u00e7\u0131ld\u0131ktan sonra a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">SQL&gt; alter database recover managed standby database using current logfile disconnect;\r\n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select open_mode from v$database;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OPEN_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">READ ONLY<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; <\/span><span style=\"font-family: courier new,courier; font-size: 10px;\">alter database recover managed standby database using current logfile disconnect;\r\n<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select open_mode from v$database;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OPEN_MODE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">--------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">READ ONLY WITH APPLY<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Read Only Mode<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle DataGuard sunucular\u0131m\u0131zdan \u0130kincil (Standby) olan\u0131 raporlama vb. i\u015flemler i\u00e7in kullanacaksak sadece okuma &#8220;read only&#8221; modunda a\u00e7abilir raporlama vb. i\u015flemlerimizi buradan yapabiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- \u0130kincil sunucumuzu \"read only\" modunda a\u00e7mak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131\r\nuygulayabiliriz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open read only;<\/span>\r\n\r\n-- <span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130kincil sunucumuzu yeniden eski haline \"mount mode\" d\u00f6nd\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ad\u0131mlar\u0131 uygulayabiliriz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database disconnect from session;<\/span><\/pre>\n<ul>\n<li><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Active DataGuard<\/span><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Oracle 11g ile birlikte gelen bir yeni \u00f6zelli\u011fimiz &#8220;Active DataGuard&#8221;d\u0131r.Bu yap\u0131da &#8220;redo apply&#8221; i\u015flemi yap\u0131l\u0131rken ikincil veritaban\u0131 read-only modda a\u00e7\u0131k olabilmektedir &#8220;Read-Only with Apply&#8221;. Oracle &#8220;Active DataGuard&#8221;\u0131n bize sa\u011flad\u0131\u011f\u0131 avantajlar aras\u0131nda &#8220;redo apply&#8221; devam ederken anl\u0131k raporlama, yedek alma vb. i\u015flemlerimizi Oracle &#8220;Active Dataguard&#8221; veritaban\u0131 \u00fczerinden yapabiliriz. B\u00f6ylelikle birincil veritaban\u0131m\u0131z \u00fczerindeki y\u00fck\u00fc azaltabiliriz. A\u015fa\u011f\u0131daki i\u015flemleri uygulayarak &#8220;Oracle Active DataGuard&#8221; \u00f6zelli\u011fini devreye alabiliriz. Unutmamam\u0131z gereken bir konuda &#8220;Oracle Active DataGuard&#8221; \u00f6zelli\u011fini kullanmak Lisans bedeli gerektirir.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; shutdown immediate;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; startup mount;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database open read only;<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; alter database recover managed standby database disconnect from session;<\/span><\/pre>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalemizde &#8220;Oracle DataGuard Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimini&#8221; inceledik. Bu makalemizdeki i\u015flemler &#8220;Oracle Enterprise Linux 6.4&#8221; i\u015fletim sistemi \u00fczerinde denenmi\u015ftir.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu makalamezinde Oracle Veritaban\u0131 Enterprise s\u00fcr\u00fcm se\u00e7ene\u011fi ve felaketten kurtarma \u00e7\u00f6z\u00fcm\u00fc olan Oracle DataGuard yap\u0131land\u0131rmas\u0131n\u0131 inceleyce\u011fiz. Oracle DataGuard Nedir ? Oracle Data Guard , Oracle\u2019da y\u00fcksek eri\u015filebilirlik ve beklenmeyen sistem hatalar\u0131 neticesinde olu\u015fabilecek veri kay\u0131plar\u0131n\u0131 en aza hatta s\u0131f\u0131ra indiren &hellip; <a href=\"https:\/\/www.koraykey.com\/?p=2848\">Okumaya devam et <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[21,290,20,19,255,264,263,378,259,260,258,261,262,377,256,257,254,253],"class_list":["post-2848","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-linux-oracle-dataguard-kurulumu","tag-oracle-active-dataguard","tag-oracle-active-dataguard-kurulumu","tag-oracle-data-guard","tag-oracle-data-guard-11g-kurulum","tag-oracle-data-guard-11g-r2-kurulum","tag-oracle-data-guard-kurulum","tag-oracle-data-guard-kurulumu","tag-oracle-data-guard-nedir","tag-oracle-dataguard","tag-oracle-dataguard-11g-kurulumu","tag-oracle-dataguard-11g-r2-kurulumu","tag-oracle-dataguard-kurulumu","tag-oracle-dataguard-nedir"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2848"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2848\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}