欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

OracleRAC之:ASM概念及基本操作維護(hù)

Oracle RAC系列之:ASM基本操作維護(hù)

ASM(自動存儲管理)是一個專門為Oracle數(shù)據(jù)庫服務(wù)的數(shù)據(jù)文件存儲機(jī)制,通過ASM管理數(shù)據(jù)文件,DBA不用再擔(dān)心I/O性能問題,也不需要知道文件的名稱,同時ASM也提供了文件系統(tǒng)到卷管理器的集成,下面依次介紹。
一、 ASM的特點
(1)自動調(diào)整I/O負(fù)載
ASM可以在所有可用的磁盤中自動調(diào)整I/O負(fù)載,不但避免了人工調(diào)整I/O的難度,而且也優(yōu)化了性能,同時,利用ASM可以在線增加數(shù)據(jù)庫的大小,而無需關(guān)閉數(shù)據(jù)庫。

(2)條帶化存儲
ASM將文件分為多個分配單元(Allocation Units, AU)進(jìn)行存儲,并在所有磁盤間平均分配每個文件的AU。

(3)在線自動負(fù)載均衡
當(dāng)共享存儲設(shè)備有變化時,ASM中的數(shù)據(jù)會自動均勻分配到現(xiàn)有存儲設(shè)備中。同時,還可以調(diào)節(jié)數(shù)據(jù)的負(fù)載均衡速度。

(4)自動管理數(shù)據(jù)庫文件
在ASM存儲管理中,Oracle數(shù)據(jù)文件是ASM自動管理的。ASM創(chuàng)建的任何文件一旦不再需要,就會被自動刪除。但是,ASM不管理二進(jìn)制文件、跟蹤文件、預(yù)警日志和口令文件。

(5)數(shù)據(jù)冗余
ASM通過磁盤組鏡像可以實現(xiàn)數(shù)據(jù)冗余,不需要第三方工具。

(6)支持各種Oracle數(shù)據(jù)文件
ASM存儲支持Oracle數(shù)據(jù)文件、日志文件、控制文件、歸檔日志、RMAN備份集等。

二、ASM的體系結(jié)構(gòu)與后臺進(jìn)程
圖1顯示了ASM的物理構(gòu)成。
 Oracle RAC之:ASM概念及基本操作維護(hù)dNsXL+0e9ff2I3+1DrX5+5+69fKGouF02xRmXDQBcsCyHwqM448ovgBf1oY1HcSzA2baoj24Mitfq5y6XC6PMtqWzq7u8f6SsOQbFf9/8487de+wXGnDxj8RManZOWXMMis88S3GVSIETULxkH4PiXPVR4BA+lLYHBoeUNcegOMqFbU55/6izq1tZcwyKm8Mj6uv/wDlAcWdxfHLKfg6aAcX5cXu88uuDw2rr/Y9PTpPpTCP03WxuzTq7EFvWNzYbW2lsurS125SmJykf3/lAcU7CkWhpa1fYky8UfX6zcbdkOuP2eAXzC0tujzeZzsTiCXpBO9DOgWBofmGJNooDXnZk8S5xHBlb37OdEhRvChT/BrfHe3xyKtvp9nh9fjMQDIl/xcn7/CaF1dLWLvkqdw/x4uCwms2tkYLZ3Bq9JRyJBoIh5W6+UKRuQGbnC8XWMV5+TWdFnc3nN+k82a9kC6A4JySKYRhujzcWT/j8pjCehBZaW98qflkUt8V7ggym3cKRKG1pVJx8laFjktOGYfj8Jt12Slu7sXgiFk+UtnazubWm3cM5QHE28oUixT9h0vzC0sFhlSK0z2/S66aK02vSi5yTPaNMJhyJ0g8upxxkudhTvgmI/Ft4TKcnjl/a2t0pV8RxKFGxNe1AoDgbsXhifmHJ+upZLJ6wzi6yuTVSUI7lNL6kSJ9MZ1onKnQ3iMUT4UiUXlA8pu5BRxDn0Ph363sDUwKKXwYUb4Lb483m1qj0EQiG8oWikPgyxUVeQfmDSCrCkWgsnqD9qf8k05njk1PRneTbgjgO3Q0CwRBhGIZ4TfUZ66viO+UKBXXqPPKdhP0yXgYU54RyFVKKpr8hs0WslQOksHOnXKFcQk5UKKkgBWPxRCAYou2UWtCRDw6rtqGt2+Nd39g8PjmV6y0tojjdGahr2dJ3kcM4DSjORjKd8flNOVEW9RPS0bpEcUFjkkAK2uSjb1F2LhJxMpLeTlFZlBrF2JQCv3i7dXZBZ0VdxeH5iQCK8yPSbkrHk+mMKMM1VVwum1A0JUR9UHgcjkRFphGLJwzDsF0KOj4NAOgERGGRknjraxWSmqATC0eiNGyVR66OBYrzQ57RSZJMcrCkfUTe7PZ4RUrQdKhHyU8gGKJauNhO76VeZGuacm7bXUKMB8hsqvZYX4ez1tkF1TflSO9MoDg/QlPye31jUxTvyFGqf1MR8PjkVFT35Fxcft4u6txyqi2epNqKhjvlinwbaYziMlRWtw1Yw5Hod3/pgBEozo+ci5M99LSl6Rhup1xpfEYjnjJSDuPzm1SfyReK1A2E1iQlPbihPcXQ9ruK01nZxgNUvHdyxgLF+bnGilu+UGzsFeI3sWTobiBvadqd2C/OjwPFgeZAcaA5UBxoDhQHmqO/4pgKq835tLfv7bmtrDkGxaem44wTqgN28oWiOTyisjnViqdm554mZtgvNODi5eLKo8dPlDXHoDimpW1zJsKTKn3jmZlW8cSNwDnU6ucdHbdULp3AozjS8bZF8YSGFpfilaMvnV3dmH+5Dent6/+4vaeyRbaFUDDobEPUh4CLUfFa/fxvd/+OZ0DtQ3n/aGBwSP2q4ZyLEn6uWr19/Rh4tgO1+vnA4JDiFIVgXlqWCogfStvsnwH4eVD8/n3zD5bW+RcIrxx9MX8dQYFFV968e88Vvwl+xa2zi1r9fGo63tnVvZxdRZlFG3Kv3/b29Y+OjavPv2UcoThR3j+aCE+6XK7RsfHl7Gq+UEQCc7P4uL2XLxRzr9/ef/DQ5XLdf/CQMXgLHKQ4Uaufv3n3fiI8aQ6PDAwOGfi6OV+9ff3m8Aj9Jqlzln53nOIAXC9QHGgOFAeaA8WB5kBxoDlQHGgOFAeaA8WB5vxH8aeJGVoUAQDNeP7i1chvvxkjv/0GgK7885//NP6NL3xp/fX/2/xgV8ufZfwAAAAASUVORK5CYII=">
         從圖1可以看出,第一部分是頂層的ASM磁盤組,ASM實例和數(shù)據(jù)庫實例可以直接訪問這些磁盤組;第二部分是ASM文件,每個ASM文件只能包含在一個磁盤組中,不過,一個磁盤組中可以包含屬于多個數(shù)據(jù)庫的多個ASM文件,并且單個數(shù)據(jù)庫可以使用來自多個磁盤組的存儲空間;第三部分是ASM磁盤,多個ASM磁盤組成了ASM磁盤組,但每個ASM磁盤只能屬于一個磁盤組;第四部分是AU(分配單元),AU是ASM磁盤組分配的最小連續(xù)磁盤空間,ASM磁盤按照AU進(jìn)行分區(qū),每個AU的大小默認(rèn)為1MB;這個結(jié)構(gòu)的底層是Oracle數(shù)據(jù)塊,由于AU是ASM分配的最小連續(xù)磁盤空間,因此,ASM是不允許跨分配單元拆分一個Oracle數(shù)據(jù)塊的。
          要使用ASM,需要在啟動數(shù)據(jù)庫實例之前,先啟動一個名為“+ASM”的實例,ASM實例不會裝載數(shù)據(jù)庫,啟動它的目的是為了管理磁盤組和保護(hù)其中的數(shù)據(jù)。同時,ASM實例還可以向數(shù)據(jù)庫實例傳遞有關(guān)文件布局的信息。通過這種方式,數(shù)據(jù)庫實例就可以直接訪問磁盤組中存儲的文件。圖2顯示了ASM的一般體系結(jié)構(gòu)。
 Oracle RAC之:ASM概念及基本操作維護(hù)cDnlpFPbfPo0SO4042JiWFWNXK5/OjRo6wj4TBSM5OQQn0C/+23rPX09BgMhn379qnVaghvTEzM0aNHmQXQ2qWa1zZOVRdpxmZlZT22Ql5enpwBRVH79++3eAz8zfyjq6uLpumamhr475kzZ2pqahQKxYYNG86cOZOYmHjmzBmapru6usrLy/Py8pYtWwbf3bBhg0KhOMOgpqZm//79eXl5cDYOCgoKIFDcL3iRnlKOU8nNYB1w7949uVyel5cH17xhwwb4Y9myZfv371coFPBfmqYfP34MJQr+OHPmDITXaDSSSIAT0jSdl5dHAl5eXl5TU5OXl7d///579+5xhx2aU9wveNXV1UH8bN26lftsjx8/rqmpgVBDipD9YF9WWtA0DWEh+zds2JCYmEjTNMQMHFNTU3PmzBmIB6PRuH///mXLltXU1MAxeXl5GzZskMvliYmJ8PUNz5DL5Rs2bIDYZrF161bmna/E1UU6zY4cOcIKCGQeiBwS0q6uLrlcvmzZMsgkBFLFkz0KhaK8vBzKGjNRjEZjV1cXZEuS35j5FuKWGdtkZ78lDuB5ywg9pePGjbN2HsfGQE1NzbJly86cOXPv3r39+/fv379/w4YNRqMRyiAEzc4YuH37dr+3jHxqm8fP6kxS6IDExES5XM6qdeHyli1blpiYCHtqamqgoEEl85hHWYM/FAoF1MnMsCsUCvgvx9Wyahunqqu2ttZaESLQNM2MNWbUEM6cOWOurmXLlpHK+vEzdcHBoK4NGzZAcYIaGepx5g9B3JEsBfFr/ussGhoaIFDcq2PAklRjx461dp79+/czMxBYyjwTk3qZqAuKGanBmdcMtT/8CyUKjmeVSTgnyVLMQsUddng4JJPJOAJOZtA4fvw499ngIqFsQKCYFwklSqFQkJ1QS+bl5RHJkdsXUlQgLKDnxMTEZcuWwfFdXV3kW1C3kj9InHMkfU1NDQQKplORuLrIDBoXL15kBYTksf379zPDC/EDRmce/PjxY8gkj59VXo8ZZY1kHpqmoc6C4pyYmAg3gnAectcI91vkLop5s9IvRUVFECjuOXlJT6m18zg2BqAQJSYmwi0U5CiwEbPCsTMGfvOb31AUNXXqVJtrG1Z4Wa6CtgHrphAcTOoohUIBYoaT8Cxrjx8/hvsYCCzJEtCu4A71ggULIDXFVNfHH3/8nSVaW1vlcjlzD6nCwPkQg1Aw4AByPBy5f/9+sv/s2bPffffd2bNnoeTAGc6ePQuxCbeE5PgNGzbA8XDCs2fPbtiw4bvvvlMoFBYvldDR0QGB4p6QFzLThAkTrJ0Hcjxzz7JlyyCYkPtBJ3K5vLW1FS4YrhCOpGmaBIT8rVAozp49S9N0a2srWOHjjz9etmxZa2srM1zwNzkh/JfEAAcRERHMzMStLmuJzgRudckdaF5eHvNTSDWS4jRNkyTr6uqCWoBEFwQEDoYKBZpueXl5NE3L5XK4HshyH3zwAfkJyCrmycGEJLprqaujo4MZio8//hiqG1bWYh6A0zTJKhCZ8K3vvvsO6qbvGGUN6jtIAohwyMMkIb777ju4Revq6iI/8fHHH0MCkcLIh58//pi/uqKioqydxIExcPbsWTgbVDKQzcAQgKNiYMyYMXzUxVHbfPcsjUiNal7RbdiwgRRbZuWwf/9+qGy/Y9Q2fMoa/CizWOXl5X3wwQfwlX5D/dZbb4mvrtra2u8tUVtbm5+fz9qZn59fW1trMpk0Gk1ERERsbGxJSQn5VKPRMI9k7v/666+///77+vr6iIgIjUaj0Wjkcjn8GxsbGxERERERERwcDMesXr26pKSkvr5eLpfX19eXlJSsXr26vr4+ODi4vr4eTmWRy5cv81fXyJEjrZ1Ho9GYTCbmnra2NggdXExwcDDzmNraWhKNbW1t5G9mHMJXNBpNcHBwbGwshFoul8O/JSUlX3/9NQnj6tWrmUEmMWDtgr///vvp06fzV5e1RCeUlJRAAgGxsbGQOiwggSB08Mfq1avhYPgJCDVERURExPfffw//5ufnk5zDPDPED2QGkivg37a2NouXShLdtdR1+fJlZiggP5AIh0zCCimUCBLzJPagHLFShBXhERERkF3b2trImdva2lavXs2MZ+Yf3DmECbMy6Vdd4eHhFk/i8BgoKSnRaDT19fWQA0k2Y+Y9+2Pgt7/9LR91cdQ2JpOJWdZWr14tl8tZ9c/3jKIEh0G0QyyR/RBGnmWtpKSEhJdV6MxrfhbQCyqyuo4dO8YnhRwFEU99fb3JZPrggw9INRobG2symUhUWoMjWgekrt/85jfOCPAzSM3b1tZGannYYzKZYmNj8/PzuQPOXZYCAgL4q+ujjz7ivlrzeJbL5W1tbV9//TVJL6hHIFxEXVAOSQkh6e17Rh0K/0JxKikpATGTc5KKBk4Ix0MdZC1i3UBdJCaB2tpaqIvhThF25ufnm1fccJNBanlScX//r9IiFVxsbCzzjopELJyQxP+A1FVSUsJfXUFBQRZP4vAYgLDAvyUlJfn5+RDqiIiIDz74gPyWnTEAa4L0qy6O2gbcydxDSh9Rztdffy2Xy2EnURccSTxH1PU9v7L2PaNwMYNMYoADsvyQmOrKysriyG2uxQcffMBfXT//+c+ddmFOAPrceaqLewz99evX5XL59evXmTuhkf35558zh75oNBryaUNDA/n7wIED5G9yDNgXSuCBAwfy8/OhsEF9BD/X0NAAxwcHB8MJIyIinjx5otFoyPlZkER3LXXV19eTnQcOHAgODmaFSy6XQyyR2Ia2LPmUeSRJLLlcTiIK2vQk4SBdIEXIz5GIhROS+Ido5wkJFB91jRo1yvwjIWKgoaEBvgJuePLkCWQ26BiIjY11SAz8x3/8Bx91cdQ2wcHBpLwAcBcLH5GwMy+YlKn8/HzmfnLNfMraE0bhYgaZxAAHcrlcfHX5+fn94C6EhobyV9fQoUOPHTsm9iU7hubm5l/84hf81fWHP/zBnp/r7u5ub28f6LdiY2PJHxEREVlZWcHBwVlZWQ0NDTt27FizZg30NEJ1A/+y/kvOwIQkumupKy4ujn/Utbe3d3d32xbhvb29ILA1a9ZERETs2LGjoaEhNjb2k08+gdoN4pmiKPMI37FjB58fIqtY8VHXT3/605s3bw40LDbEQHt7O1z/J598ApkHIuHAgQMNDQ3BwcE//PCDnTFw7NixX/7yl3zUZU9t09DQMNCv9FvWduzYwQypeaGLiIiwdvLm5mYYYSiyusaPH3/s2LE/uz4XLlwYPXo0f3X97ne/mzBhgthX7RgiIyNnzJjBX10jR4789NNPxb7qP3/77bfk74qKikuXLp3j5NKlS6wz6PX6l156yRXV9eKLL7a3tzs3vv/JjRs3+o3tc+fOMRPIGgcOHHj11Vf5q2v8+PGxsbFOCCM3J0+e/POf/2xPDDx48GD8+PGTJk3ioy7RaxtWWfv222/7Dbu1U0VGRkriWdc777zjHjV4ZGTk7t27+asrICBg6tSpbqDtCxcujB8/PiYmhr+63CbRJ0yYQNYecy11vf3225GRkWLHn708ePBgxIgRZMIIPuqaM2fOyJEjL1y4IPa120t+fr5arYbKpF91BQQELFq0KD8/X+yrtheobTIyMsRX186dO+fPn79nz57/dmWOHTsWERFx5cqVAanryJEjNE1/8803Yl++7Tx8+HD69OnwMjx/dUGi7969W+zLt4vdu3e/+eabJNFdS12VlZVBQUHV1dVix6JdvPPOOxs3bjx58uSA1LVr167Zs2c/fPhQ7Mu3nWvXrr300ks3b97kr64TJ074+/tfu3ZN7Gu3nYcPH86ePfvkyZNSUde5c+fmzp1bWlr6F9cEZgy6f//+QNV17ty5gwcPTp8+vbe3V+xA2MKjR48iIyN1Ot0PP/wQHR09IHWdO3du6tSplZWVYgfCRmpqakJDQ3/44QfXVVddXV1AQEBDQ4PYcWkju3fvVqlUP/zwwyeffDIgdZ07dy4nJycyMlLsENhIb2/v5MmT29rafvjhB/7qOnfuXGVl5YQJE1y0tvnLX/4SFRV18ODBH374gWRj8dXV2Ng4a9asI0eO/OhqXLx4cfLkyd9+++33AxwcD5mpsbHx/fffDwoKevz4sdhBGTBRUVFlZWUwXNUGdRkMhmnTptXU1IgdjgEDk4qxEt3l1HXu3LlPP/00ICDg4sWLYsfogDlw4EB0dDTkvQG91wXqamxszMzMfOONN8QOx4Dp7e2dMmVKY2MjhB3mb+SpLqht4F5Z7HAMmDfeeGPv3r0Q6nXr1klIXWfOnJk2bVppaanYUTQAGhoapkyZcufOHXjHe0CzaZDM1NTUVFBQMHv27Dt37ogdIL48fvwYchJ5v53MQstfXZDoNE1XVlaKHaABUFNTYzHRXVFdjY2Ner3e39+/oaFB7HgdAKWlpeHh5b29vZAEA5pNg6irqanp7bffjo2NdaG7xjt37syePfv48eOk3A1UXU1NTYcOHaJp2rVqm9WrV69bt46EWlrqampqOnv2bHh5eFRUVG9v7/+TPO+8886kSZNu375NZtb64osvbFPX+fPn9+zZM2LEiJqaGrGD1T8XL14cN25cUVERc1Yx29TV1NR06tQpmqbfeOMN6Sf6d999t3bt2ldeecVioruoupqamj788MOxY8euXbv2u+++EzuO+6G3t/eNN95YunRpb28vSQIyjeRA1XX+/PmkpKQJEyY0NDSIHbL+qampGTduHGsuUxvURWqb0tJSscPUPx0dHdOnT2dN2L127Vppqev8+fPNzc2bN28eMWLExx9//P9JlcuXL9M0bb5sxKVLl2xW1/nz5z/77DOoxL/99luxg2iVLVu2TJo0yXwBBZvVBYkOE6CdO3dO7PBZ5fLly+PGjeNIdNdVFyRBfHz89OnTL1++LHZMW+XcuXMjR47cs2cPKwnI2h82qKu5uflPf/rTxIkTt2zZInb4rPL999+vXLnylVde6erqYoXdNnVBbRMeHi7x2qaoqGjcuHGnTp1ihVqi6rpw4QLMjrVmzZq7d++KHXv/wvfff79jx45Jkybp9XrzNdDa29vtUReEHSrx48ePix1WNkajcfbs2UlJSV9//bV52JcsWWKPui5cuFBRUTF27FgJJvq3336r0WjGjRtncYlCkuiurq4LFy689957o0aN0mg0UqvO7t69u2bNmkmTJl27do1j7UHb1NXc3NzQ0PDGG2/QNP3ZZ5+JHVY2x48fHzduXH5+vsV1F2F5WxvURWqbF1988b333hM7lGygtlm+fLnF2uadd96RqLouXLjQ0tKSnJz861//+o033rhx48ZTsenr69uxY4ePj8/KlStv3Lhx3xKff/65/epqaWk5duzYjBkzJkyYcPToUbHD/fTp06eNjY2RkZFjx46tqKiwGPD79+8vXrzYTnW1tLSQRAeBiR3up319fRqNxsfH5+2337537x53oruBulpaWs6dO7dixYpf//rXGo2mr69P7BR4CtLy8fH54x//aC3vVVVV2akuCHtZWVlgYOD06dNPnz4tdrifPn369MMPP5wwYcLcuXPPnz9vLex2qqulpeXkyZMKhQIEJnaInz59+rS1tbXf2ubtt9+WtLouXrzY1NSUlZX1wgsvgMD+Kgb379+H+mvlypWdnZ191iEzsdqprosXLxqNxqNHj7766quQpUQJ+F//+te6uroZM2YEBgYeOnSII+B9fX2OUhckekpKikQS/e233+7u7uaT6O6hLkgCg8Hw1ltvvfDCC2vWrOnp6RElCXp6ekBamzdv7unp4UiCjz76yCHqgnK3f//+wMDAGTNm1NXViRLwv/71rzqdbsKECXPmzDEYDNzlzn51Qairq6sjIiJefPHFsrIysULd1tY2f/78sWPH9lvbuIC6jEZja2trW1tbdnb2Cy+8MGHChIKCgs7Ozr8Jz4MHD8rKyubPn+/l5ZWWlnb9+vVv+4Ms/ewQdUHYa2pq5s2b98tf/jIuLk6n0/35z392QtibmpqSkpJGjx4dEhLy0Ucf9Rvwb7/91oHqgoA3NzdDotM0XVBQcOPGDScE/N69e3v37p0/f/7QoUMHmujupC5IgrNnz6alpf3yl78MCwvbu3fvvXv3nJAEN27cKCgomDFjhpeX1+bNm+/evdtvEjhWXa2tra2trSUlJZMmTXrxxReTkpIMBoMTAv63v/1Np9OtWrXKy8trzpw5dXV1fMpdSEiIQ9TFrG2ee+65uLi48vJy59Q2bW1t69atGz169NixY99//30+oU5LS3MZdX3++eft7e1/+tOfoqOjf/vb344ePTopKamtrc3h8UhKztChQ+ENuDt37vTyw2g0OlxdEPbTp09v2rRp5syZzz333Pz588vKyh58eODYgP/5z3/W6XRxcXFeXl6BgYGbNm1qbGzkGfDe3t6oqCjHqosk+uHDh7Ojo1944YXRo0evW7dOiETv7OwsKCigadrLy+uNN944ePAg/4CTRHc/dZEkKCoqev31159//vkJEyZs3br1ypUrDk8CWJFuwoQJPj4+b731lk6n458EZC4uB6rr888///zzz2tra99+++1JkyYJV5vDLfLixYtlMtmcOXO2bdvW0dHBP+yOVRekeENDw6ZNm8LCwmQy2fz58wW6ayGeHjt2bGZm5oBqG9dTV3t7+6VLl7744osTJ0688847MN3thAkTFi9enJWVZTAYbt68+feB8N///d8Gg2Hv3r1JSUkzZsyQyWQ+Pj4rVqw4fvz41wOnpaVFIHWRgF+8ePHdd9+NjIx87rnnnnvuuRkzZqxbt66srKypqWlAAf/73/9+5coVnU6XlZUVFhbm4+Mjk8nCwsIKCwsvXbpkQ9iFUxcz0aEtSFEUTdMk0b/66isbEr2goGDVqlUwa7Cfn9+KFStqamrsSXQ3VtelS5cgCY4dO6ZSqWB5wxkzZsTFxW3dutVgMDx8+HBASfDw4UODwbB169a4uDiapimK8vf3T01N/eyzz2xIguPHjwukLpL3mpqaNm/ePGfOHJlM9uKLL4aFhWVlZel0ura2tgEF/O9//3tTU1N5eXlWVha0LD08PKKiooqLi2/dumVD2IVQFwn1F1988e677y5atOj5559n1jYGg2Ggob5y5conn3ySlZU1f/58KMJhYWG5ubm21Tapqamuqq6Ojo7Lly9fvny5s7Pzww8/zM/PT0hIeOmll2DVqBdffHHGM6CCA8BPABQYmUwWHBy8bNmy7Ozs48ePf/nll1/ZwYULF4RWFwl7Z2fnhQsX3n///ZSUlNdee+0///M/4adnMFi3bh0Je1hYGNnv4eEB9XVYWFhKSsqRI0cuXLhgT8C/+uqrRYsWCa0uEvDOzs7y8nKS6M8//zxHooOfgAkTJpBEX7FiRW5u7vHjx+0MOEn0waAuZhK8//77W7ZsWbFixUsvvQQ5avTo0SSq4+LiSBLExcWR/VBteXh5BAcHq9XqwsLCmpoaO5PACerq6OggYT916lRJSUlCQsKsWbN+//vfQ3BIAMFqBGZ5lMlkFEVNnDgxMjIyJSXl+PHj7e3tdoYdVksRTl0WaxuyWoK12mb+/PlkPyyG6efn9/LLL6ekpLz33nv19fV2hjolJcUd1HXlypWrV69eu3atq6vLZDJdv379zJkzR44cOXr0aHl5+c6dO9esWZOUlJSUlKTRaCoqKo4dO1ZZWVldXX3P0TQ3NztTXcyAk7BDwCHs77zzDgn74cOHjx07BmG/evWqw8PuZHXxT/QtW7aQRNfr9Q4POEn0waYu8yTQ6/UkCbZv306SID8/nyTB2bNnHZ4ElZWVzlQXK+Amk6m1tZUE/ODBg2vWrCFhJwGvrKy8efOmw8PuNHWRUDNT3Fptc+DAAVLbtLe3OzzUbquu69evd3d337hx4+bNm19++eWtW7du3759+/btO3fu3L17t0cwpKAuCDgr7EIHvKen5/XXXxdXXRYT/c6dO05LdFRXd3e3KElw7NgxcdXFzHtOLnfiqkus2iY5OXkwqks4zp8/L2V1CYrE1SUcJNFRXdzqEo6Kigopq0tQJKsuQRmM6hKUpqYmyapLaKSsLkEhiY7q4lCXoEhZXUIDz+ylpi6hSUpKGlzqEprGxkZpqssJsJbcloi6nABJdFSXRXU5gT/96U/SVJcTkKC6nMBgUZfTaGhokJq6nIbU1OU0SKKjuljqchrl5eVSU5fTkJS6nMaaNWvcX13OpL6+XlLqciYLFy6UjrqcCUl0VBdTXc5EaupyJkFBQRJRlzNZvXq1m6vLyZw9e1Y66nIy0lGXkyGJjuoi6nIyR48elYi6nI9E1OVk3Fxdzkci6hKFBQsWSEFdzgfVJXreO3LkiBTUJQqiq0sUVq5cKZq66urq4LdTU1OFUJcolJaWQqAKCws5itCsWbMoivrFL34hhLrEAiaq8PLy4gg46djZsmWLEOoShb1790KgysvLpa+u3NxcuNqysjKHq0ssMjIyIFCNjY0c2e+5556DWl4IdYnFz3/+c4qiFAqF02obKaQ41Daenp4iqKunpwdy2+uvv+5AdYkLuaXlLkLx8fFw2MmTJx2oLnH52c9+xl2Enjx5QiZZj46OdqC6xIW82N/a2ip9dZGZai3eMtqsLnEhqxb09fVxZL/JkydTFPV//s//caC6xIWMbk1JSXFabSOFgLNqG6eq68mTJ56enuYtWXvUJTo8i1BhYSEctmvXLkdlJnE5d+5cv0UIsHbna7O6RGfu3LkURclkMgigxNVFbhkXLVrkKHWJzvjx4ymKGjVqFHfes1iJ26Mu0SkpKSFt6MFc2zhbXQqFgqKon/3sZw5RlxSAOXBHjhzJXYTIvVJiYqL9mUkK8ClCANz5/upXv3KIuqTAqFGjKIoaP368S6jrCectow3qkgJ8WvzWKnGb1SUF1q1b1283z2CobZytLtK9tnXrVjvVJQVOnTr1k5/8hE8R6uvr+/d//3eQnJ2ZSSKQFU+4e0qfPHmiUqngyH379tmpLinw4Ycfki5QV1EXPPz4yU9+UllZaae6pMCuXbsgCbjHRj1hPF+fP3++neqSCL/73e+gxc/RzeN+tU1sbCyrtnG2urq7u83j1AZ1SYRXXnkFIhQe13ND+i5ycnJszkwSgSw5QVoeHJB7QPNEH5C6JAJJdFKKpK8uMlhm6tSp9qhLIpDqu7u7u9/sB12LFEUdPHjQZnVJhJ07d0JY4uPjedY2q1evdvXaRq/XQwuBWds4W13MOM3Ozh7ouiQFmbuaT/X95MmT7u5uWLzHz8/vzJkzA81MkmLmzJn8nf3kWUcxU9v81SUp/v/2zii0reqP4+elq9DRbhW3CTMVLs2DrYUMxxrlVsEMZWlklbANwjLX+DCjZF1xg9juGspgWc0sWGbUKxG3GTN1mejO1rUG1zRTO0Oe8pQ+5iGQx/PwZyDI/+FHfxzvTdMkTZOb9nwext3Nzc0995zf7/v7/c65t7gmm8+zjS9dbA0PXqF0GYrp6ekK3TfAy3YN0mUc/v77b6hUV6LZ6G26u7u3pLdpgnTx9/TBgweVS5ehePz48UsvvVRhxQxB2T5z5kxVg8lQ4NLwdcukfKdDtt3T08N3+rrSZSgeP34M8b6m01tCujD3tVgs4MsqlC5DkUqlnn766cpTLgAjp6tXr1YuXUYD34RUoWbj7MzJkydb19vcuHGjZIbQBOlinAfv7e2dn5+vRLqMxptvvlmt+2acbBNCJiYmKhlMRuPWrVsgQlVpNt/pfX19Dx8+rES6DMXy8vIrr7wCTXA6nXzTWkK6GOfBh5aGKpQuQ7G0tIShw7rrWnlQtnfs2KGqaiXSZTSmpqagCZ2dnRVqdrFYhOU5hJCzZ8+2qLeBh9gIIfF4nG9dc6SrWCxi+aK3t3dxcbG8dBmNt956Cy7eZDJls9nKTYgxFolEyCpTU1PlB5PRiMViOJLWnSHXkM/nsdMHBweh08tIl9F44403sNM1vqNVpCubzZpMJmiF3W5fN3owFMvLy1jnGBgYKP8sih6MQXbu3Hn9+vXy0mU0rl27hk5j3QW9PPF4nI+VW8vbUEohwyaEeDweTdOaI11M58iSyWRJ6TIg+D6Srq6uqtIOBN+NtGPHjpmZmbUGk9G4e/fus88+C1eOi+uqYmVlBV0ndHpJv2lA8B35JYOVVpEuxlg6ne7q6kL1Wku6DMjLL7+MupXP52sYfrjSFdRrLekyGl999RXWOeDFY1XBx8qTk5Ot4m0WFhbKe5umSRdjLJ/PoyPr6en5+uuvNSPJaPz++++vvfYaXHB7e3ttugXgu3kIIW63e2lpiR9MBiQUCmG+pSmXVQUf+Pf399+6dcvgnf7gwQN0mmsFKy0kXYyxVCqF6jU4OHjv3j2Dd8FPP/304osvlgkdKsflcsF5Ojo6Ll68aPCGp9PpDz74ABbXkerrHAjGyq3ibT777LPu7m64YJvNVjLDbqZ0Mcay2SysmSGEtLW1eb1evKdG44svvsC72dXvpsm81kAgEMDx1N/f/8MPPzS7iaV59OgRzpEQQoaHh7ut1eg7vbe3F/POc+fOGbbTeRMqk2S3lnQxxlKpFM6C7Ny589KlS4btgo8//hhjpg3qFoC5FyHEarUmEolmN7E0c3NzVqsVL7Vm3QLC4TCmbs8///zNmzeb3b7SPHr06J133sFWr6VbrOnSxRgrFov4Rjh04o+NRCKROHXqFF7hwYMb95V9AAAMt0lEQVQHN24/QCKR4J34+++/3+y2agmHwz09PXCF7e3twWCwLg0vFosY/4IHuX//frPb+h8SiQS+F58QIstymbnxlpMuxlg+n4fnlDEiSSQSzb7r/+H+/fuvvvoqXqHT6aytTqgnEol0dnbCabu7uz/55JNmt1XLpUuX4HUh9QqUGWOpVErjbVKpVLMb+h9u3ryJ3oYQEggEyjSn+dIFxONxDAPBkH7++eflZvPbb7+9++67OIY2HvvoyefzvBPft28f1DGaTjgcPnDgAF6Y2WxOp9P1bTvf6W1tbW+//bYBO729vb28CbHWlC4gHA6jE+/o6Dh26hTUD5vLvXv3Tpw4gYWyzs7OGuZ4yrOyssIrt9lsnp6ebna7l5eXl6enp1FgIO2o/BmAddHkCd3d3efOnVtaWmp2o5dv3LjBhylmszmRSJRvi1GkizGWz+dxMhyw2+0wm9p4FhYWNKJVyd2smXg8jh5EhtTY2BgsXWk8n3/+OS9ahJDx8fENFgnXQuNBoNPv3LnTlIZTSnmPCZ1eyYxm60oXYyydTsNLJjGGOHHiBKW0KV1w584du93Oj4c6Fjn0BAIBXIAH3X3lypWmNPyvv/66ePHivn378GLqWOTQoMkTjOZtXC5XJd7GQNIFUErh76QhBw4cuHDhQjwe/3PzWVxcvHLlit1u50Vrz549wWBwk3w3ks/n/X6/RsCOHz9+7dq1BjT8zz//jMViY2NjfMRHCBkeHt7IapQKiUajvPckhAwNDV24cOHu3bsNaPji4uLU1JTdbudFy2QyVR7pt7R0AeFwGGedQcAOHz48OTm5sLDQgC5YWFiYnJw8fPgwPwYGBgYqfFfLRshms3zZgxDS09Pj8XhgAX0DuH79utvt3rt3Ly9aXq+3jsmWnpLeZmRkZGZmpjGtjsfjY2Nj/f39NXsbw0kXQCnVBOOEkN7e3vfee+/777//o97Mz89PTEzYbDbeeaH/2mzR4tEPKUJIR0eH3W6fmpp6+PBh4duuqurx48efe+45zd12uVx1rxCWRx+1EEL6+vrOnj27GZ3+66+/TkxMDA0NaX6xKtECtoB0AdFoFB9ZQQYHB8+fP3/79u26d8Ht27fPnz+vCbpJo0SLJ5vNer1ePgMjhOzdu3dkZOTTTz+te8P/+OOPYDA4MjKye/du/hcbIFo8+Xw+GAzyGRh5G5vNNjU1NT8/X/dWf/vttydPnsQ1xkgNIbJBpQtIpVJOp1Pjxwkhu3btslgso6OjH3300ezsbKp6fvzxx6tXr46OjsqyrPfahBBZluteXq+cfD4fCAT4KJh45UeOHBkdHZ2dnf3ll19qaPvs7OyHH3547Ngxi8WikWpCyDPPPOPxeDavRLMulFKn06lxInBh0OmBQODLL780VKdvGekCotEov6YU2b9//6FDh0ZHRy9fvvzNN9/U0AXffffd5cuXR0dHDx06tGfPHv1PDA8PN1i0eFZWVrxer35stLW1WSyWo0eP+ny+2dnZubm5ahs+Nzc3Ozt75syZI0eO9PX16RtuMpnGx8cbJlo8xWIxGAzqQxZCyAsvvGCz2cDbwN8cqJby3qazs9PlcqVqqusYWrqQeDzu8Xg00YGm4y0Wi8VikWX5dCng3gH6O8hbTjgcbsoAKkk2mw0Gg/pcRGNUwLFjx0q2XZZlOGD//v1rncdsNnu93s2bzKuBaDTagE5vb293Op3hcHgjq9e2mHQBxWIxEom4XC597Ij09vbC7X399ddLdsHRo0exC9Y6CfivSCTSyPJGeVKplN/vL+nNgd27d2O7Sjb89OnTeMCuXbvWOs/AwEAgEGhweWMtstnszMyMvtyFVOVtSkaHgMlk8nq9lNKNXG1rSBcCQ8pms5W5L9Uiy7LH4zGU5ejJ5/PhcNjj8ZSRsWoxm802my0YDBrEctYikUj4/X5ZlkvG6TXQ3t4OnR6NRuvS6VtSunji8fj4+Lgsy2VkrCo6OztlWfZ6vXVZ9r15gDd3Op1lZKxaBgYGnE7nzMyMcUJkDfl8PhKJ1NfbmEwmm81WR51uMeniKRaLlNJgMAi3WJZlfqpTz1NPPQWHDQ8P+/3+eDzexLLYBkmn09FoFFRclmXNGgc9ZrMZ2j4+Pj4zM7PBeKeJ5PN5SmkgEHC5XFV1utPp3LxO3/LSxbOyskIp9fv9TqcT7i2+m6MkXV1dcJjL5fL7/ZRSw7rsdUkkEuFwGFRcluWSJX2egwcPwpF+vz8SidRWGWs6NXsbr9e7ed6mhaWrPGBgBs8nNglKKaXUyEnkJpHNZpvS6dtKusqTTqcppa0bFNYMRNKGKrk3hkQi0RRvs2WlSyBoGEK6BIIGI6RLINgoQroEggYjpGuLUCgUcDuXy5U8JpPJNOpythdCurYn6xodf4CgvgjpajTJZFK/k1KqKIqiKKguyWSypDGU/DpjzGq1wnRooVCQJElvM7lczmq1lvwupdThcMC28l/WmmLN5XKxWKzkR9sQIV1GBv7+k2ZnLpcLhUKKoqiqCnsKhUJJ4yr5dbZqUGBovAXxuN1uPL8GRVFCoRD8rsboSgoeuAj4ioAJ6WowoVBIkiTNaLZarVarVVEUt9uNBiBJkl5p3G43ISSZTGYyGYfDAV90OBzJZFJVVdhwu90+n483QscqkiQ5OPgDKKW5XK5QKFit1uQqqqoqiqK5hlgsJklSycvbtgjpMjIwXPk9qqpKkuR2uxVFgQHPGFMUhRCisc1cLodDHUwMjSiZTPp8PrA1q9WqqioaHeyBg2EDrJW3SjhnJpOB86DRaYwXAM8ALkKSpLXKKtsKIV0NxWq1+nw+3umHQqGSGgD2pkl6wBJwZDscjlwul8lkrFYrfMRvYKgIKgWyhFKE0kUpdbvdcG3JZJKXtGQyqZcuSinYm5AuREiXYVFVFYyCNyVJkvQ1A5AxzahWFAVUB/fANpitxujQdtBw4JyQRSmKgpYL2R7kbZBO8b+oly6N5onciwnpaiSZTAZKeXzcBHmY/mBJknw+Hy8koVDI7Xbz0oUWlcvl8EjezKD+IEkS1iIgdsOdlFKr1QqJms/nY6sCVibrAoR08QjpMiwOh0NVVZ/PB/EZIEmS3vsriuLz+fQixweXGOcxxnjr4A+A86ChgXGB6cEGZHKwJxaLVZJ18QjpAoR0NQ4YxPwGAIGbplKhFzkQFUmSYGRD+QLkB/6Fuh+U1yGoTCaTlFL4iqqqlFK0EDhboVDIZDJwDP4K6hxYWsm2COniEdJlTEAk+A0AC4Z85Q2HPS9OYGI41N1uN5QZC4UC1DzgAFVV4WwwYYZF+1AoxGsSFhXhIwg3odTBB5dlpAsaIgqGTEhXI5EkCYp4vFQAkAbxVT44AEyFrVoR7IeRDbVHsBlQPofD4Xa7Y7EYGBWcBywNfhSqE8lkEo7BX4dvwfa6BUP8SEgXIqTLmIASwLYmWYHZYsh+8GBMicB8sJoHQx0+ghwO8irYgMPQHCC+hG2w31wuB3qmqfvBr2isrGTBkP/WWus+thtCuhqEqqqEEOsqhBD94j0QIdjWRItQ92Cr0hWLxSA9ApMA5aOUQmGEXy6IpXbGWKFQyOVykE7xZXcsXzBRMKwJIV3GBNcT4XSU5gAIIsGyQLrYarSHaoTSBSoFSoNV90wmAzKGywU11UgIFjUFDJg/A2utvGAodItHSFeDgBgNBygvMAgfr+EG5FL8fhjZEA9iyIZn8/l8vCiCveHKKFyUiCeklPKLo0TBsAaEdBkQLJUDsDJWv8wd1y6hdMGcNAaLfMEQLQ5K8fyiJwwQ8eu8rcF/8fhQKASSxiouGArd0iCkqxHoK9QwvhljqqqCcoCeabIutmqBOOhRutCEYMTHYjGYPwOTQ/XC+gOcUC91AOyHKopmp6YtUM2HhVvJZFI85syEdBkSLLYjED7CR7yeQbUcpQuORANcS7pgkQXYGj9DxlaNC0+Ic1q8NeVyOSiTVFIwhBQNZVg86cyEdDWGWCymsSLGGAx9qEtAZYOfN9Y8d8Vvg1pAigbWiCs4oHbBr9NdV7qwdgGRoKZg6PP5NHYCC64Qfbu2IUK6DAisWuL34BQvxIhQQsRUJhQKYaEvFovxGRIOcmV1AT3U+qBuD3UR/ZMnZaQLLFdRlFAoBFamWc3BXzY8/cIjVhgyIV2tS6FQAMuE6SswgFAoBOIHKzWk9eDDPY0mCTupHCFd2wRKKb4+A5f1QtKGz02ua3T8CUHz9IhixroI6dqaiJJCIxHSJWBrvztUsBkI6RIINoqQLoGgwQjpEgg2ipAugaDBCOkSCDaKkC6BoME0SLqePHnyP4Fgi/LkyZMGGFFV/Pvvv82+KwLBJvLPP//8H3BV4xRgXNdJAAAAAElFTkSuQmCC">
 
         從圖2可以看出,ASM實例與數(shù)據(jù)庫實例進(jìn)行通信的橋梁是ASMB進(jìn)程,此進(jìn)程運行在每個數(shù)據(jù)庫實例上,是兩個實例間信息交換的通道。ASMB進(jìn)程先利用磁盤組名稱通過CSS獲得管理該磁盤組的ASM實例連接串,然后建立一個到ASM的持久連接,這樣兩個實例之間就可以通過這條連接定期交換信息,同時這也是一種心跳監(jiān)控機(jī)制。
         另外,在ASM實例中還存在另外一個新的進(jìn)程,即RBAL,此進(jìn)程負(fù)責(zé)規(guī)劃和協(xié)調(diào)磁盤組的重新平衡活動。除此之外,ASM實例還有一些與數(shù)據(jù)庫實例中的進(jìn)程相同的后臺進(jìn)程,例如LGWR、SMON、PMON、DBWR 、CKPT等。
如果一個數(shù)據(jù)庫實例使用ASM作為存儲,那么它將多出兩個后臺進(jìn)程,即RBAL和ASMB。RBAL 負(fù)責(zé)打開磁盤組中所有磁盤和數(shù)據(jù),而ASMB負(fù)責(zé)和ASM實例進(jìn)程通信。

三、管理ASM實例
 在使用ASM作為數(shù)據(jù)存儲時,ASM實例管理顯得非常重要,Oracle提供了豐富的管理功能,對ASM實例進(jìn)行管理需要具備SYSDBA權(quán)限,在Oracle 11g中可以使用一個新角色 ,即SYSASM,此角色只用于管理ASM實例。

1.創(chuàng)建ASM實例
創(chuàng)建ASM實例有兩種方法,第一種是利用dbca創(chuàng)建,這種方法只需運行Database Configuration Assistant(DBCA),然后根據(jù)提示即可創(chuàng)建一個ASM實例,此種方式在前面已有講述,這里不再多說。第二種方法是用命令行方式創(chuàng)建ASM實例,下面進(jìn)行簡單介紹。

(1)創(chuàng)建ASM磁盤
可以使用RAID劃分的LUN、分區(qū)和裸設(shè)備等來創(chuàng)建ASM磁盤,但是在使用LUN、分區(qū)或裸設(shè)備時,要注意將屬主和屬組改為Oracle用戶及其對應(yīng)的組,這個在前面節(jié)已經(jīng)講述過,另外一種簡單的方法就是使用Oracle提供的ASMLib來完成ASM磁盤的創(chuàng)建,下面將講述這種方法。

在創(chuàng)建ASM實例之前,首先應(yīng)該確保節(jié)點上已經(jīng)安裝了ASMlib包,同時確認(rèn)ASMLib是否已經(jīng)自動加載:
[root@node1 ~]# lsmod | grep oracleasm
oracleasm              46356  1

然后,通過ASMlib提供的oracleasm將已經(jīng)劃分好的磁盤分區(qū)轉(zhuǎn)化為ASM磁盤,例如:
[root@node1 ~]#/etc/init.d/oracleasm createdisk ASMDISK1 /dev/sdc5
Marking disk "/dev/sdc5" as an ASM disk [  OK  ]
[root@node1 ~]#/etc/init.d/oracleasm createdisk ASMDISK2 /dev/sdc6
Marking disk "/dev/sdc6" as an ASM disk [  OK  ]
[root@node1 ~]#/etc/init.d/oracleasm createdisk ASMDISK3 /dev/sdc7
Marking disk "/dev/sdc7" as an ASM disk [  OK  ]
[root@node1 ~]#/etc/init.d/oracleasm createdisk ASMDISK4 /dev/sdc8
Marking disk "/dev/sdc8" as an ASM disk [  OK  ]
[root@node1 ~]#/etc/init.d/oracleasm createdisk ASMdisk5 /dev/sdc9
Marking disk "/dev/sdc9" as an ASM disk [  OK  ]

創(chuàng)建完ASM磁盤后,可以查看系統(tǒng)的/dev/oracleasm/disks/目錄下是否已經(jīng)生成磁盤設(shè)備,可以采用的命令如如下:
[root@node1 ~]# ll /dev/oracleasm/disks/ASMDISK*
brw-rw---- 1 oracle oinstall 8, 21 Sep 10 23:40 /dev/oracleasm/disks/ASMDISK1
brw-rw---- 1 oracle oinstall 8, 22 Sep 10 23:40 /dev/oracleasm/disks/ASMDISK2
brw-rw---- 1 oracle oinstall 8, 23 Sep 10 23:36 /dev/oracleasm/disks/ASMDISK3
brw-rw---- 1 oracle oinstall 8, 24 Sep 10 23:40 /dev/oracleasm/disks/ASMDISK4
brw-rw---- 1 oracle oinstall 8, 25 Sep 10 23:40 /dev/oracleasm/disks/ASMDISK5

也可以通過如下方式查看:
[root@node1 ~]#service oracleasm listdisks
ASMDISK1
ASMDISK2
ASMDISK3
ASMDISK4
ASMDISK5

如果要刪除 ASM磁盤可通過以下命令:
[root@node1 ~]#./etc/init.d/oracleasm deletedisk ASMDISK5
Removing ASM disk "ASMdisk5" [  OK  ]

在RAC環(huán)境中,要注意另外一個節(jié)點是否能夠發(fā)現(xiàn)對應(yīng)的ASM磁盤,執(zhí)行如下命令,讓另外一個節(jié)點來獲取這種變化。
[root@node2 ~]#/etc/init.d/oracleasm scandisks
到此位置,ASM磁盤已經(jīng)創(chuàng)建完畢了。

(2)初始化參數(shù)
啟動ASM實例只需要如下幾個參數(shù)即可,利用這些參數(shù)可以實現(xiàn)ASM實例的內(nèi)存的自動分配和自動管理。
下面介紹ASM實例初始化參數(shù):
instance_type=asm
cluster_database=true
DB_UNIQUE_NAME=+ASM
ASM_POWER_LIMIT=1
large_pool_size=60M
asm_diskgroups='FLASH_DISK','ARCH_DISK','DATA_DISK'
asm_diskstring='/dev/oracleasm/disks/*'
每個參數(shù)的含義如下:
? instance_type,指定實例的類型,對于ASM實例,應(yīng)設(shè)置為ASM
? cluster_database,指定是否是數(shù)據(jù)庫集群,true表示是ASM集群
? DB_UNIQUE_NAME,指定ASM實例的名稱,默認(rèn)是+ASM
? ASM_POWER_LIMIT,該參數(shù)用來控制ASM中數(shù)據(jù)的負(fù)載均衡速度
? large_pool_size,設(shè)置大池的大小,由于ASM文件的分配單元映射是從large_pool分配的,因此large_pool_size至少要8MB,                                   建議越大越好
? asm_diskgroups,指定實例啟動時可用的ASM磁盤組,ASM實例將在啟動時自動掛載這些磁盤組
? asm_diskstring,用于限制ASM實例可用于創(chuàng)建磁盤組的磁盤設(shè)備。如果該值為NULL,則ASM實例可見的所有磁盤都可以成為創(chuàng)建磁盤組的可選磁盤

(3)創(chuàng)建密碼文件
[oracle@node1 ~]$su - oracle
[oracle@node1 ~]$ cd $ORACLE_HOME/dbs
[oracle@node1 ~]$ orapwd file=orapw+ASM password=oracle

(4)創(chuàng)建目錄結(jié)構(gòu)
[oracle@node 1~]$su – oracle
[oracle@node1 ~]$cd $ORACLE_HOME/dbs
[oracle@node1 ~]$mkdir –p $ORALCE_BASE/admin/+ASM/udump
[oracle@node1 ~]$ mkdir –p $ORALCE_BASE/admin/+ASM/bdump
[oracle@node1 ~]$mkdir –p $ORALCE_BASE/admin/+ASM/adump
[oracle@node1~]$ mkdir –p $ORALCE_BASE/admin/+ASM/cdump

2.啟動ASM實例
 無論在RAC環(huán)境中還是單實例環(huán)境,ASM實例都需要用到CSS進(jìn)程,在RAC環(huán)境中,啟動CRS后CSS已經(jīng)運行,而在單實例環(huán)境下,需要以root用戶運行腳本,初始化CSS服務(wù),否則,在啟動ASM實例時會報如下錯誤:
ORA-29701: unable to connect to Cluster Manager
執(zhí)行初始化腳本的過程如下:
[root@node1 ~]#$ORACLE_HOME/bin/localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Cleaning up Network socket directories
Setting up Network socket directories
 Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
 Cluster Synchronization Services is active on these nodes.
        node1
Cluster Synchronization Services is active on all the nodes.
Oracle CSS service is installed and running under init(1M)

然后啟動ASM實例:
[oracle@node1 ~]$export ORACLE_SID=+ASM
[oracle@node1 ~]$sqlplus / as sysdba
SQL> startup
ASM instance started
Total System Global Area    134217728 bytes
Fixed Size                   1218124 bytes
Variable Size               107833780 bytes
ASM Cache                   25165824 bytes
ORA-15110: no diskgroups mounted
因為首次啟動ASM實例并沒有創(chuàng)建ASM磁盤組,所以顯示 15110錯誤是正常的。
 
3.管理ASM磁盤組
 ASM磁盤組是作為邏輯單元進(jìn)行統(tǒng)一管理的一組磁盤,在ASM實例中,可以創(chuàng)建和添加新的磁盤組,可以修改現(xiàn)有的磁盤組,在其中添加一個磁盤或者刪除一個磁盤,也可以刪除現(xiàn)有的磁盤組。

(1)添加磁盤組
SQL> create diskgroup FLASH_DISK external redundancy disk '/dev/oracleasm/disks/ASMDISK1' name flashdisk;
Diskgroup created.
SQL> create diskgroup ARCH_DISK external redundancy disk '/dev/oracleasm/disks/ASMDISK2' name archdisk1;
Diskgroup created.
SQL> create diskgroup DATA_DISK normal redundancy disk '/dev/oracleasm/disks/ASMDISK4' name datadisk1, '/dev/oracleasm/disks/ASMDISK5' name datadisk2;
Diskgroup created.

(2)查看磁盤組狀態(tài)
SQL> select name,state from v$asm_diskgroup;
NAME                           STATE
-------------------       --------------
FLASH_DISK                   MOUNTED
ARCH_DISK                   MOUNTED
DATA_DISK               MOUNTED

名稱欄目:OracleRAC之:ASM概念及基本操作維護(hù)
標(biāo)題URL:http://www.chinadenli.net/article44/jdjshe.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供企業(yè)網(wǎng)站制作手機(jī)網(wǎng)站建設(shè)網(wǎng)站維護(hù)品牌網(wǎng)站建設(shè)云服務(wù)器域名注冊

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)

手機(jī)網(wǎng)站建設(shè)