{"id":3370,"date":"2013-05-12T10:51:45","date_gmt":"2013-05-12T07:51:45","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=3370"},"modified":"2013-06-24T14:59:59","modified_gmt":"2013-06-24T11:59:59","slug":"oracle-veritabanlarinda-export-import-uygulamalari-data-pump","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=3370","title":{"rendered":"Oracle Veritabanlar\u0131nda Export & Import Uygulamalar\u0131 (Data Pump)"},"content":{"rendered":"

\"OracleBackup\"<\/a><\/p>\n

\u00a0Bu makalemizde Oracle taraf\u0131ndan sa\u011flanan export ve import arac\u0131 olan “DataPump” inceleyece\u011fiz.<\/span><\/p>\n

DataPump Nedir ?<\/span><\/strong><\/p>\n

Oracle DataPump komut sat\u0131r\u0131ndan “expdp” ve “impdp” ara\u00e7lar\u0131 ile kontrol edilen yedekleme arac\u0131d\u0131r. \u0130\u015flem tamam\u0131yla veritaban\u0131 sunucusu \u00fczerinde yap\u0131lmakta, istemci sadece i\u015flem i\u00e7in talimat vermektedir. Sa\u011flanan bir API ile PL\/SQL procedure’ler i\u00e7inden de kullan\u0131labilmesi sa\u011flanm\u0131\u015ft\u0131r. Paralel i\u015fleme kabiliyeti olan bu ara\u00e7la ayn\u0131 zamanda harici tablolar da kullan\u0131labilmektedir. Oracle Data Pump ile t\u00fcm veritaban\u0131 yede\u011fi alabildi\u011fimiz gibi Rman ile yapamad\u0131\u011f\u0131m\u0131z “Se\u00e7ilen Tablolar” “Se\u00e7ilen Schema”lar vb. i\u00e7in export ve import i\u015flemi m\u00fcmk\u00fcn olmaktad\u0131r. Bu arac\u0131n kullan\u0131labilmesi i\u00e7in \u00f6ncelikle veritaban\u0131 \u00fczerinde kullan\u0131lacak yedekleme dizinin yarat\u0131lmas\u0131 gerekmektedir.<\/span><\/p>\n

1. Oracle DataPump kullanabilmek i\u00e7in \u00f6ncelikle veritaban\u0131 sunucumuz \u00fczerinde oracle kullan\u0131c\u0131n\u0131n yazabildi\u011fi bir dizine ihtiyac\u0131m\u0131z var. Bu dizinimizi yarat\u0131p veritaban\u0131m\u0131za “DataPump” dizini olarak tan\u0131t\u0131yoruz.<\/span><\/p>\n

-- Oracle kullan\u0131c\u0131s\u0131 ile sistemimize ba\u011flan\u0131p \"datapump\" dosyalar\u0131n\u0131n yaz\u0131laca\u011f\u0131\r\ndizinimizi yarat\u0131yoruz.\r\n\r\n$ mkdir -p \/u01\/backups\/datapump\r\n\r\n-- Veritaban\u0131m\u0131za ba\u011flan\u0131p yaratt\u0131\u011f\u0131m\u0131z dizini \"datapump\" dizini olarak at\u0131yoruz.\r\n\r\n$ sqlplus \/ as sysdba \r\n\r\nSQL> create or replace directory dp_dir as '\/u01\/backups\/datapump';\r\n\r\nDirectory created.\r\n\r\n-- Belli bir kullan\u0131c\u0131ya bu dizine yazma hakk\u0131 vermek istiyorsak a\u015fa\u011f\u0131daki i\u015flemi\r\nyapmal\u0131y\u0131z.\r\n\r\nSQL> grant read, write on directory dp_dir to koraykey;<\/span><\/pre>\n
2. Veritaban\u0131m\u0131zda bulunan bir veya birden fazla tabloyu export \/ import etmek i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n
-- Veritaban\u0131m\u0131zda bulunan tablolar\u0131 d\u0131\u015fa aktarmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.\r\n\r\n$ expdp koraykey\/parolamiz@orcl tables=KRY,KEY directory=dp_dir dumpfile=KRY_KEY.dmp logfile=expdpKRY_KEY.log\r\n\r\n-- Veritaban\u0131m\u0131za tablo aktarmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz. Burada dikkat\r\netmemiz Import edece\u011fimiz tablolar\u0131n veritaban\u0131m\u0131zda mevcut olmamas\u0131.\r\n\r\n$ impdp koraykey\/parolamiz@orcl tables=KRY,KEY directory=dp_dir dumpfile=KRY_KEY.dmp logfile=impdpKRY_KEY.log<\/span><\/pre>\n
3. Veritaban\u0131m\u0131zda bulunan bir \u015femay\u0131 export \/ import etmek istiyorsak a\u015fa\u011f\u0131daki komutlar\u0131 kullan\u0131yoruz.<\/span><\/p>\n
-- Veritaban\u0131m\u0131zda bir \u015femay\u0131 export etmek istiyorsak a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.\r\n\r\n$ expdp koraykey\/parolamiz@orcl schemas=koraykey directory=dp_dir dumpfile=koraykey.dmp logfile=expdpkryky.log\r\n\r\n-- Veritaban\u0131m\u0131zda bir \u015femay\u0131 import etmek istiyorsak a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz. Burada dikkat\r\netmemiz Import edece\u011fimiz \u015fema i\u00e7eri\u011finin veritaban\u0131m\u0131zda mevcut olmamas\u0131.\r\n\r\n$ impdp koraykey\/parolamiz@orcl schemas=koraykey directory=dp_dir dumpfile=koraykey.dmp logfile=impdpkryky.log<\/span><\/pre>\n
4. Veritaban\u0131m\u0131z\u0131n tamam\u0131n\u0131 export ve import etmek istiyorsak a\u015fa\u011f\u0131daki komutlar\u0131 kullan\u0131yoruz.<\/span><\/p>\n
-- Veritaban\u0131m\u0131z\u0131n tamam\u0131n\u0131 export etmek i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.<\/span>\r\n\r\n$ expdp system\/parolamiz@orcl full=Y directory=dp_dir dumpfile=orcl.dmp logfile=expdpORCL.log<\/span>\r\n\r\n-- Veritaban\u0131m\u0131z\u0131 mevcut bir veritaban\u0131 \u00fczerine import etmek i\u00e7in a\u015fa\u011f\u0131daki komutu\r\nkullan\u0131yoruz. <\/span>Burada dikkat edece\u011fimiz varolan objeleri atlayacakt\u0131r. Bu y\u00fczden d\u00f6nme\r\ni\u015fleminde veritaban\u0131m\u0131z\u0131n <\/span>bo\u015f yeni kurulu halde olmas\u0131 gerekmektedir.<\/span>\r\n\r\n$ impdp system\/parolamiz@orcl full=Y directory=dp_dir dumpfile=orcl.dmp logfile=impdpORCL.log<\/span><\/pre>\n
5. Veritaban\u0131m\u0131zda export ve import i\u015flemlerini “dblink” \u00fczerinden yapabiliriz. \u00d6rne\u011fin bu i\u015flem sayesinde uzak veritaban\u0131nda bulunan bir tabloyu import ve export edebiliriz.<\/span><\/p>\n
-- Veritaban\u0131m\u0131zda \u00f6ncelikle \"DBLink\" yarat\u0131yoruz.<\/span>\r\n\r\n-- Bu i\u015fleme ba\u015flamadan \u00f6nce \"tnsnames.ora\" dosyam\u0131za veritaban\u0131 bilgilerini giriyoruz.<\/span>\r\n\r\n$ vim \/u01\/app\/oracle\/product\/11.2.0.3\/db\/network\/admin\/tnsnames.ora<\/span>\r\n\r\n-- Veritaban\u0131m\u0131za \"sqlplus\" ile ba\u011flan\u0131p \"public\" bir \"dblink\" yarat\u0131yoruz.<\/span>\r\n\r\n$ sqlplus \/ as sysdba<\/span>\r\n\r\nSQL> create public database link <link_name><\/span>\r\n\r\n  2 connect to <user_name><\/span>\r\n\r\n  3 identified by <password><\/span>\r\n\r\n  4 using '<service_name>';<\/span>\r\n\r\n<link_name>\t--> DBLink \u0130smimiz<\/span>\r\n<user_name> \t--> Ba\u011flant\u0131 kuraca\u011f\u0131m\u0131z veritaban\u0131ndaki kullan\u0131c\u0131 ad\u0131<\/span>\r\n<password>\t--> Ba\u011flant\u0131 kuraca\u011f\u0131m\u0131z veritaban\u0131ndaki parola<\/span>\r\n<service_name>\t--> TNS Dosyam\u0131zdaki tan\u0131m ismi.<\/span>\r\n\r\n-- Veritaban\u0131m\u0131zda export i\u015flemi yapabilmek i\u00e7in<\/span>\r\n\r\n$ expdp system\/parolamiz@orcl tables=KRY.KEY network_link=DBLINKNAME directory=dp_dir dumpfile=kry.dmp logfile=expdpKEY.log<\/span>\r\n\r\n-- Veritaban\u0131m\u0131zda import i\u015flemi yapabilmek i\u00e7in<\/span>\r\n\r\n$ impdp system\/parolamiz@orcl tables=KRY.KEY network_link=DBLINKNAME directory=dp_dir dumpfile=kry.dmp logfile=impdpKEY.log remap_schema=KRY:KEY<\/span><\/pre>\n
6. Veritaban\u0131m\u0131zda belli bir zamana veya belli bir “SCN” numaras\u0131na g\u00f6re “export” i\u015flemi yapabiliriz. Bunun i\u00e7in komutlar\u0131m\u0131z\u0131n sonuna a\u015fa\u011f\u0131daki parametreleri eklememiz yeterlidir.<\/span><\/p>\n
-- Kullanmak i\u00e7in \"expdp\" komutlar\u0131m\u0131z\u0131n sonuna eklemeliyiz.\r\n\r\n-- Belli bir zamana g\u00f6re export i\u015flemi yapabilmek i\u00e7in<\/span>\r\n\r\nflashback_time=\\\"to_timestamp\\(\\'09-05-2013 22:10:00\\', \\'DD-MM-YYYY HH24:MI:SS\\'\\)\\\"<\/span>\r\n\r\n-- Belli bir SCN numaras\u0131na g\u00f6re export i\u015flemi yapabilmek i\u00e7in<\/span>\r\n\r\nflashback_scn=22102012<\/span><\/pre>\n
7. Veritaban\u0131m\u0131zda “expdp” ve “impdp” komutlar\u0131 ile b\u00fcy\u00fck verilerde i\u015flem yaparken “parallel” parametresi ile yedek alma i\u015flemini h\u0131zland\u0131rabiliriz. Bunun i\u00e7in a\u015fa\u011f\u0131daki parametreyi komut sat\u0131r\u0131m\u0131za eklememiz yeterlidir.<\/span><\/p>\n
parallel=3<\/span><\/pre>\n
8. Veritaban\u0131m\u0131zda “expdp” ve “impdp” komutlar\u0131 ile neler yapabilece\u011fimiz konusunda yard\u0131m almak i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 kullanabiliriz.<\/span><\/p>\n
-- Import arac\u0131m\u0131z\u0131n yard\u0131m\u0131n\u0131 kullanmak i\u00e7in<\/span>\r\n\r\n$ impdp help=y<\/span>\r\n\r\n-- Export arac\u0131m\u0131z\u0131n yard\u0131m\u0131n\u0131 kullanmak i\u00e7in<\/span>\r\n\r\n$ expdp help=y<\/span><\/pre>\n
Bu makalemizde Oracle Export ve Import ara\u00e7lar\u0131m\u0131z olan “expdp” ve “impdp” inceledik. Data detayl\u0131 Oracle yedekleme i\u015flemleri i\u00e7in “Oracle Veritabanlar\u0131nda Backup & Recovery Uygulamalar\u0131 (Rman)”<\/a> yaz\u0131m\u0131z\u0131 inceleyebilirsiniz.
\n<\/span><\/p>\n
Ba\u015fka bir makalede g\u00f6r\u00fc\u015fmek \u00fczere\u2026<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0Bu makalemizde Oracle taraf\u0131ndan sa\u011flanan export ve import arac\u0131 olan “DataPump” inceleyece\u011fiz. DataPump Nedir ? Oracle DataPump komut sat\u0131r\u0131ndan “expdp” ve “impdp” ara\u00e7lar\u0131 ile kontrol edilen yedekleme arac\u0131d\u0131r. \u0130\u015flem tamam\u0131yla veritaban\u0131 sunucusu \u00fczerinde yap\u0131lmakta, istemci sadece i\u015flem i\u00e7in talimat vermektedir. … Okumaya devam et →<\/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":[306,21,290,307,20,19,586,305,588,304,589,590,591,308,317,592,309],"class_list":["post-3370","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-expdp-komutlari","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-impdp-komutlari","tag-koray-gunduz","tag-koraykey","tag-oracle-backup-alma","tag-oracle-data-pump","tag-oracle-data-pump-backup-alma","tag-oracle-datapump","tag-oracle-datapump-backup-alma","tag-oracle-expdp-backup-alma","tag-oracle-expdp-komutlari","tag-oracle-export-database","tag-oracle-export-import-komutlari","tag-oracle-impdp-komutlari","tag-oracle-import-database"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/3370","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=3370"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/3370\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}