oracle10g在hp-ux系統(tǒng)主備數(shù)據(jù)庫(kù)署詳細(xì)方案(存儲(chǔ)版)
【正文】 rk/jlib:/opt/:/opt/jexport PATH=$PATH:$ORACLE_HOME/bin:./:$ORACLE_HOME/OPatch:$ORA_CRS_HOME/bin:/opt/:/opt/:/usr/vacpp/binexport NLS_LANG=umask 022set o viexport DISPLAY= 用于XMANAGER 客戶(hù)端顯示export LANG=4. 創(chuàng)建數(shù)據(jù)庫(kù)裸設(shè)備a) system表空間 （4G）lvcreate L 4096 n system01 /dev/vg6_hbetl_fs03b) sysaux表空間 （）lvcreate L 2560 n sysaux01 /dev/vg6_hbetl_fs03 只能建c) sysaux表空間 （）lvcreate L 512 n users01 /dev/vg6_hbetl_fs03d) password 密碼文件lvcreate L 256 n lv_pwdfile /dev/vg6_hbetl_fs03e) spfile 參數(shù)文件lvcreate L 256 n lv_spfile /dev/vg6_hbetl_fs03f) ocr 文件lvcreate L 1024 n lv_ocr /dev/vg6_hbetl_fs03g) vote 文件lvcreate L 1024 n lv_vote /dev/vg6_hbetl_fs03h) control 控制文件（一個(gè)512MB）lvcreate L 512 n control01 /dev/vg6_hbetl_fs03lvcreate L 512 n control02 /dev/vg6_hbetl_fs03 規(guī)劃是/dev/vg6_hbetl_fs04 不能用lvcreate L 512 n control03 /dev/vg6_hbetl_fs03 規(guī)劃是/dev/vg6_hbetl_fs04 不能用i) redo files 文件lvcreate L 2048 n redo11 /dev/vg6_hbetl_fs03lvcreate L 2048 n redo21 /dev/vg6_hbetl_fs03lvcreate L 2048 n redo31 /dev/vg6_hbetl_fs03lvcreate L 2048 n redo12 /dev/vg6_hbetl_fs03 規(guī)劃是/dev/vg6_hbetl_fs04 不能用lvcreate L 2048 n redo22 /dev/vg6_hbetl_fs03 規(guī)劃是/dev/vg6_hbetl_fs04 不能用lvcreate L 2048 n redo32 /dev/vg6_hbetl_fs03 規(guī)劃是/dev/vg6_hbetl_fs04 不能用j) undotbs1 表空間lvcreate L 4096 n undo01 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo02 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo03 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo04 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo05 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo06 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo07 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo08 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo09 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo10 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo11 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo12 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo13 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo14 /dev/vg6_hbetl_fs03lvcreate L 4096 n undo15 /dev/vg6_hbetl_fs03k) temp 表空間lvcreate L 4096 n temp01 /dev/vg6_hbetl_fs03lvcreate L 4096 n temp02 /dev/vg6_hbetl_fs03lvcreate L 4096 n temp03 /dev/vg6_hbetl_fs03。 show_patches|grep PHKL_39624 數(shù)據(jù)庫(kù)存儲(chǔ)規(guī)劃1. 新建oracle用戶(hù)組，用戶(hù)a) 用戶(hù)組/usr/sbin/groupadd oinstall 附屬組/usr/sbin/groupadd dba 主組b) oracle用戶(hù)/usr/sbin/useradd g oinstall G dba –m oraclec) 修改密碼/usr/sbin/passwd oracle 修改密碼2. 新建oracle 目錄a) oracle 用戶(hù)存儲(chǔ)劃分 lvcreate L 20480 n lv_oracle /dev/vg00 劃分20GB給oracle目錄 newfs F vxfs o largefiles /dev/vg00/rlv_oracle 格式化（大文件系統(tǒng)）b) 掛載文件系統(tǒng) cd / 。lvcreate L 4096 n temp08 /dev/vg6_hbetl_fs03。lvcreate L 4096 n temp16 /dev/vg6_hbetl_fs03。lvcreate L 4096 n temp24
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1