Oracle veritabanlar\u0131nda undo tablespace, veritaban\u0131 i\u015flemleri s\u0131ras\u0131nda yap\u0131lan de\u011fi\u015fikliklerin geri al\u0131nabilmesi i\u00e7in kritik bir bile\u015fendir. Zamanla bu alan\u0131n b\u00fcy\u00fcmesi veya performans sorunlar\u0131na yol a\u00e7mas\u0131 nedeniyle mevcut undo tablespace’ini de\u011fi\u015ftirmek gerekebilir. Bu yaz\u0131da, Oracle veritabanlar\u0131nda yeni bir undo tablespace olu\u015fturman\u0131n ve bunu veritaban\u0131 node\u2019una uygulaman\u0131n ad\u0131mlar\u0131n\u0131 inceleyece\u011fiz.<\/p>\n\n\n\n
Bu yaz\u0131da, mevcut undo tablespace’inin yerine yeni bir undo tablespace<\/strong> olu\u015fturma ve Oracle DB node<\/strong>‘una uygulama s\u00fcrecini ad\u0131m ad\u0131m anlataca\u011f\u0131z. Bu i\u015flem, veritaban\u0131 y\u00f6netiminizi daha verimli hale getirebilir ve sistem performans\u0131n\u0131 art\u0131rabilir.<\/p>\n\n\n\n <\/p>\n\n\n\n Hangi UNDO tablespace<\/strong>‘in \u015fu anda kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in:<\/p>\n\n\n\n <\/p>\n\n\n\n Yeni bir undo tablespace olu\u015fturmak i\u00e7in \u00f6ncelikle uygun bir disk alan\u0131na ihtiyac\u0131n\u0131z var. Bu alan\u0131n yeterli b\u00fcy\u00fckl\u00fckte olmas\u0131, veritaban\u0131 i\u015flemlerinin sa\u011fl\u0131kl\u0131 bir \u015fekilde devam etmesi i\u00e7in \u00f6nemlidir.<\/p>\n\n\n\n <\/p>\n\n\n\n Veritaban\u0131, varsay\u0131lan olarak bir undo tablespace kullan\u0131r. Yeni olu\u015fturdu\u011fumuz undo tablespace’ini veritaban\u0131 i\u00e7in varsay\u0131lan undo tablespace olarak ayarlamal\u0131y\u0131z. <\/p>\n\n\n\n Scope=BOTH<\/mark><\/strong> ifadesi, yap\u0131lan de\u011fi\u015fikli\u011fi hem aktif bellek \u00fczerinde uygular hem de spfile dosyas\u0131na kaydedilir.<\/p>\n\n\n\n sid=’node1′<\/mark><\/strong> ifadesi, yap\u0131lan de\u011fi\u015fikli\u011fin yaln\u0131zca belirli bir Oracle Instance<\/strong> (\u00f6rne\u011fin, <\/p>\n\n\n\n Yap\u0131lan de\u011fi\u015fikli\u011fi kontrol edelim:<\/p>\n\n\n\n <\/p>\n\n\n\n Mevcut undo tablespace’ini devre d\u0131\u015f\u0131 b\u0131rakmadan \u00f6nce, yeni undo tablespace’inin do\u011fru \u015fekilde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve t\u00fcm i\u015flemleri d\u00fczg\u00fcn bir \u015fekilde kaydetti\u011fini do\u011frulaman\u0131z gerekir.<\/p>\n\n\n\n <\/p>\n\n\n\n Eski undo tablespace dosyas\u0131n\u0131 tamamen silmek i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\n\n\n\n Burada, Oracle veritaban\u0131nda mevcut undo tablespace’inin yerine yeni bir undo tablespace olu\u015fturma ve DB node’lar\u0131na uygulama ad\u0131mlar\u0131n\u0131 ke\u015ffedin. Sistem performans\u0131n\u0131 art\u0131rarak veritaban\u0131 y\u00f6netimini kolayla\u015ft\u0131r\u0131n<\/p>","protected":false},"author":1,"featured_media":329,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[118,121,124,127,130],"class_list":["post-327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel-en","tag-db-nodea-undo-tablespace-uygulama-tr","tag-oracle-performans-artirma-tr","tag-oracle-undo-tablespace-tr","tag-oracle-veritabani-yonetimi-tr","tag-yeni-undo-tablespace-olusturma-tr"],"_links":{"self":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":7,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/327\/revisions"}],"predecessor-version":[{"id":591,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/posts\/327\/revisions\/591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media\/329"}],"wp:attachment":[{"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/categories?post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/en\/wp-json\/wp\/v2\/tags?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\n\n\nMevcut Undo Tablespace Kontrol\u00fc<\/h2>\n\n\n\n
SQL> sho spparameter undo;\n\nSID\t NAME\t\t\t TYPE\t VALUE\n-------- ----------------------------- ----------- ----------------------------\n*\t temp_undo_enabled\t boolean\n*\t undo_management\t string\n*\t undo_retention \t integer\norcl1\t undo_tablespace\t string\t UNDOTBS1\norcl2\t undo_tablespace\t string\t UNDOTBS2<\/code><\/pre>\n\n\n\n
\n\n\n\nYeni Undo Tablespace \u0130\u00e7in Disk Alan\u0131 Haz\u0131rlama<\/h2>\n\n\n\n
SQL> CREATE BIGFILE UNDO TABLESPACE UNDO_NEW_01\nDATAFILE '\/path\/to\/undo_tablespace01.dbf' SIZE 5G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED\nRETENTION NOGUARANTEE\nBLOCKSIZE 8K\nFLASHBACK ON;<\/code><\/pre>\n\n\n\n\n
CREATE BIGFILE UNDO TABLESPACE<\/mark><\/code><\/strong>:\n\n
BIGFILE<\/code>, tablespace’in yaln\u0131zca tek bir b\u00fcy\u00fck veri dosyas\u0131na sahip olaca\u011f\u0131n\u0131 belirtir (\u00e7oklu veri dosyalar\u0131na izin verilmez). BIGFILE<\/code> tablespace’ler genellikle ASM kullan\u0131ld\u0131\u011f\u0131nda tercih edilir \u00e7\u00fcnk\u00fc ASM dosya y\u00f6netimini kolayla\u015ft\u0131r\u0131r.<\/li>\n<\/ul>\n<\/li>\n\n\n\nUNDO_NEW_01<\/mark><\/code><\/strong>:\n\n
DATAFILE<\/mark><\/code><\/strong>:\n\n
+DATA\/UNDO\/undo_tablespace01.dbf<\/code> gibi olabilir.<\/li>\n<\/ul>\n<\/li>\n\n\n\nSIZE 5G<\/mark><\/code><\/strong>:\n\n
AUTOEXTEND ON<\/mark><\/code><\/strong>:\n\n
NEXT 1G<\/mark><\/code><\/strong>:\n\n
MAXSIZE UNLIMITED<\/mark><\/code><\/strong>:\n\n
MAXSIZE 50G<\/code> gibi bir de\u011fer belirtebilirsiniz.<\/li>\n<\/ul>\n<\/li>\n\n\n\nRETENTION NOGUARANTEE<\/mark><\/code><\/strong>:\n\n
GUARANTEE<\/code> <\/strong>olarak ayarlansayd\u0131, undo bilgileri belirli bir s\u00fcre boyunca korunur ve \u00fczerine yaz\u0131lamazd\u0131, bu da \u00f6zellikle Flashback i\u015flemleri i\u00e7in kullan\u0131l\u0131r.<\/li>\n\n\n\nNOGUARANTEE<\/strong><\/code>, daha fazla undo segmentine ihtiya\u00e7 duyulursa, eski bilgiler \u00fczerine yaz\u0131lmas\u0131na izin verir.<\/li>\n<\/ul>\n<\/li>\n\n\n\nBLOCKSIZE 8K<\/mark><\/code><\/strong>:\n\n
BLOCKSIZE<\/code> de\u011ferleri kullan\u0131labilir (\u00f6rne\u011fin, 2K, 4K, 8K, 16K).<\/li>\n<\/ul>\n<\/li>\n\n\n\n\n
FLASHBACK OFF<\/code> olarak ayarlarsan\u0131z, bu tablespace Flashback \u00f6zellikleri i\u00e7in kullan\u0131lamaz.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n\n\n\nYeni Undo Tablespace’ini Sistem Undo Tablespace Olarak Atama<\/h2>\n\n\n\n
ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDO_NEW_01' scope=BOTH sid='orcl1';<\/code><\/pre>\n\n\n\nnode1<\/code>) \u00fczerinde uygulanmas\u0131n\u0131 sa\u011flamak i\u00e7in kullan\u0131l\u0131r<\/p>\n\n\n\n
\n\n\n\nYeni Undo Tablespace’i Kontrol Etme<\/h2>\n\n\n\n
SQL> sho spparameter undo;\n\nSID\t NAME\t\t\t TYPE\t VALUE\n-------- ----------------------------- ----------- ----------------------------\n*\t temp_undo_enabled\t boolean\n*\t undo_management\t string\n*\t undo_retention \t integer\norcl1\t undo_tablespace\t string\t UNDO_NEW_01\norcl2\t undo_tablespace\t string\t UNDOTBS2<\/code><\/pre>\n\n\n\n
\n\n\n\nEski Undo Tablespace’ini Kullan\u0131m D\u0131\u015f\u0131 B\u0131rakma<\/h2>\n\n\n\n
ALTER DATABASE DATAFILE '\/path\/to\/old_undo.dbf' OFFLINE;<\/code><\/pre>\n\n\n\n
\n\n\n\nEski Undo Tablespace’ini Silme<\/h2>\n\n\n\n
DROP TABLESPACE old_undo INCLUDING CONTENTS AND DATAFILES;<\/code><\/pre>\n\n\n\nINCLUDING CONTENTS AND DATAFILES<\/code> ifadesi, hem tablespace\u2019in hem de i\u00e7indeki t\u00fcm veri dosyalar\u0131n\u0131n silinmesini sa\u011flar.<\/p>","protected":false},"excerpt":{"rendered":"