oracle10g在hp-ux系統(tǒng)主備數(shù)據(jù)庫署詳細方案(參考版)
2024-11-18 04:07本頁面
【正文】 常見問題處理方案1. 卷組操作A 單機情況下 激活、去激活vgchange a y /dev/vg6_hbetl_fs03 激活vgchange a n /dev/vg6_hbetl_fs03 去激活vgchange c y /dev/vg6_hbetl_fs03 讓集群管理vgchange a e /dev/vg6_hbetl_fs03 集群情況下（單節(jié)點獨占 exclusive）激活vgchange a n /dev/vg6_hbetl_fs03 集群情況下去激活 vgchange c n /dev/vg6_hbetl_fs03 集群管理（單節(jié)點獨占 exclusive ）去激活如報錯 vxfs mount: V321264: /dev/vg6_hbetl_fs01/lv_hbetl_fs01 is already mounted, /boncint is busy, allowable number of mount points exceeded ERROR: Function check_and_mount ERROR: Failed to mount /dev/vg6_hbetl_fs01/lv_hbetl_fs01請執(zhí)行如下命令fsck F vxfs o full /dev/vg6_hbetl_fs01/lv_hbetl_fs01 2. 主備機卷組同步A 從134主機導出卷組信息 ，停業(yè)務，停數(shù)據(jù)庫，包括停實例（shutdown immetiate），停監(jiān)聽(lsnrctl stop)；vgexport s p m /tmp/ /dev/vg6_hbetl_fs03 134 136備機上rcp /tmp/ EDAETLB:/tmp/ 拷貝到另一臺機器 136備機 （會報一下錯誤）vgimport s m /tmp/ /dev/vg6_hbetl_fs03 136vgimport: Volume group /dev/vg6_hbetl_fs03 already exists in the /etc/lvmtab file.D. 先將 136備機上的卷組 /dev/vg6_hbetl_fs03 卷組信息導出vgexport m /tmp/ /dev/vg6_hbetl_fs03 vgimport s m /tmp/ /dev/vg6_hbetl_fs03 執(zhí)行成功后 提示vgimport: Volume group /dev/vg6_hbetl_fs03 has been successfully created.Warning: A backup of this volume group may not exist on this machine.Please remember to take a backup using the vgcfgbackup mand after activating the volume group.G、在第1臺機器上去激活卷組(vgchange a n /dev/vg6_hbetl_fs03)H、在第1臺機器上改變卷組屬性(vgchange c y S y /dev/vg6_hbetl_fs03)I、分別在兩臺機器上以共享模式激活卷組(vgchange a s /dev/vg6_hbetl_fs03)3. 刪除邏輯卷A. 刪除邏輯卷 lv lvremove /dev/lovl01 注意：刪除lv需要用到它的用戶的程序、進程停掉，B. 卸載文件系統(tǒng)umount /bca 完成。第二種 使用cmhaltpkg 來啟停應用程序包 cmhaltkpkg 命令來停止需要遷移的程序包 cmhaltpkg pkgname b. 用 cmrunpkg 來重新在別的節(jié)點上運行程序包 cmrunpkg n nodename pkgname c. 用cmmodpkg 修改切換屬性 cmmodpkg e pkgname 一般來數(shù)據(jù)建議采用第二種方法216。 Oracle Workspace Manager VALID JServer JAVA Virtual Machine VALID Oracle Database Packages and Types VALID Oracle Database Catalog Views VALID Oracle XDK VALID Oracle OLAP API VALID Oracle Real Application Clusters VALID Oracle Database Java Packages VALID OLAP Analytic Workspace VALID Oracle interMedia VALID Oracle XML Database VALID OLAP Catalog VALID Spatial VALID Oracle Expression Filter VALID Oracle Rules Manager VALID Oracle Text VALID Oracle Data Mining VALID Oracle Enterprise Manager LOADING 216。 C. 關閉數(shù)據(jù)庫 Shutdown immediate D. 重啟數(shù)據(jù)庫 Startup E 查看版本完成升級 SELECT * FROM V$VERSION。/as sysdba39。 M. 開始創(chuàng)建 可以選擇創(chuàng)建數(shù)據(jù)庫腳步保存路徑及是否創(chuàng)建模板 選擇Create Database Finish216。216。chown oracle:dba /dev/vg6_hbetl_fs03/rtemp*。chown oracle:dba /dev/vg6_hbetl_fs03/rredo32。chown oracle:dba /dev/vg6_hbetl_fs03/rredo12。chown oracle:dba /dev/vg6_hbetl_fs03/rredo21。chown oracle:dba /dev/vg6_hbetl_fs03/rcontrol03。chown oracle:dba /dev/vg6
畢業(yè)設計相關推薦
鄂ICP備17016276號-1