天天看點

Oracle RAC重新運作root.sh腳本

Oracle RAC重新運作root.sh腳本

----------------- 加入常用指令
vi /etc/profile
export GRID_HOME=/u01/app/12.1.0/grid
export ORACLE_HOME=/u01/app/12.1.0/grid
export PATH=$PATH:$GRID_HOME/bin
===================================rac中重新運作root.sh腳本===================================================
需要注意的是,多數以pl結尾的腳本從12.1.0.2開始都變為了sh腳本,例如:rootcrs.pl需要修改為rootcrs.sh
In 12.1.0.2, rootcrs.sh/roothas.sh should be used instead of rootcrs.pl/roothas.pl
# OCR備份,實體和邏輯都進行備份
ocrconfig -export /tmp/export_asm_lhr_logical.bak
ocrconfig -manualbackup
ocrconfig -showbackup
ocrconfig -copy +MGMT:/raclhr-cluster/OCRBACKUP/backup_20190822_085506.ocr.285.1016960109 /tmp/export_asm_lhr_physical.bak #從12.2開始的OCR實體備份預設放在MGMT磁盤組,建議單獨cp到FS中
cp /u01/app/11.2.0/grid/cdata/raclhr-cluster/backup_20190822_111554.ocr /tmp/export_asm_lhr_physical.bak
#手動對叢集相關資源進行備份,包括新增的db、監聽、service等
----------------- 日志位址
---11g、12.1.0.2、
日志位址:$ORACLE_HOME/cfgtoollogs/crsconfig/
重置的日志檔案:hadelete.log
root.sh腳本日志:rootcrs_rac2.log
---18c
18c的日志位址:$ORACLE_HOME/install/
18c的詳細日志位址:/u01/app/grid/crsdata/raclhr-18c-n1/crsconfig/
重置的日志檔案:crsdeconfig_raclhr-18c-n1_2019-08-21_11-21-45AM.log
root.sh腳本日志:rootcrs_raclhr-18c-n1_2019-08-21_11-15-48AM.log
export GRID_HOME=$ORACLE_HOME
# 查詢ASM磁盤
$GRID_HOME/bin/kfod disks=asm  st=true ds=true cluster=true
# /grid/stage/ext/bin/kfod disks=asm  st=true ds=true cluster=true
#root使用者重新執行root.sh,配置檔案:$ORACLE_HOME/crs/install/crsconfig_params
crsctl stop crs -f
#kill -9 `ps -ef|grep d.bin| grep -v grep | awk '{print $2}'`
export GRID_HOME=$ORACLE_HOME
$GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose
$GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg
#find $ORACLE_HOME/gpnp/* -type f -exec rm -rf {} \;
dd if=/dev/zero of=/dev/rhdiskN bs=1024k count=100  --清理磁盤頭
--檢視磁盤是否有内容
--AIX用:lquerypv -h  /dev/rhdisk5
--linux用:hexdump /dev/sdb ,例如:hexdump -n 1024 -C /dev/sdb1
#保證叢集完全關閉,最好重新開機OS,檢查網絡情況,是否有cvuqdisk
#find /u01 -name cvuqdisk*
#rpm -qa cvuqdisk
#rpm -ivh $GRID_HOME/cv/rpm/cvuqdisk-*.rpm
#檢查配置檔案($ORACLE_HOME/crs/install/crsconfig_params)是否需要修改,18c可以去掉MGMTDB
$GRID_HOME/root.sh  #若出現錯誤,則在解決錯誤後可以重複執行,不需要先deconfig
#也可以圖形化界面使用GRID配置 
#export DISPLAY=192.168.59.1:0.0
#$ORACLE_HOME/crs/config/config.sh
-----------------------------------------------------
--- 對于18c,需要注意:
#若MGMTDB不需要重複建立,則可以修改配置檔案
#配置檔案($ORACLE_HOME/crs/install/crsconfig_params)修改以下内容的值為空:
MGMT_DB=
GIMR_CONFIG=
CDATA_BACKUP_DISK_GROUP=
CDATA_BACKUP_FAILURE_GROUPS=
CDATA_BACKUP_QUORUM_GROUPS=
CDATA_BACKUP_DISKS=
CDATA_BACKUP_REDUNDANCY= 
CDATA_BACKUP_AUSIZE=
CDATA_BACKUP_SITES=
CDATA_BACKUP_SIZE=
-----------------------------------------------------
# OCR恢複
crsctl stop crs
crsctl start crs -excl -nocrs
#crsctl stop resource ora.crsd -init
ocrconfig -import /tmp/export_asm_lhr_logical.bak  #邏輯備份恢複
#ocrconfig -restore /tmp/export_asm_lhr_physical.bak  #實體備份恢複
crsctl stop crs
crsctl start crs
===============================================================================================================      

kfod指令:

[root@raclhr-11gR2-N1 app]# kfod -h
KFOD-00101: LRM error [107] while parsing command line arguments
_asm_a/llow_only_raw_disks              KFOD allow only raw devices [_asm_allow_only_raw_disks=TRUE/(FALSE)]
_asm_l/ibraries         ASM Libraries[_asm_libraries=lib1,lib2,...]
_asms/id                ASM Instance[_asmsid=sid]
a/sm_diskstring         ASM Diskstring [asm_diskstring=discoverystring, discoverystring ...]
c/luster                KFOD cluster [cluster=TRUE/(FALSE)]
db/_unique_name         db_unique_name for ASM instance[db_unique_name=dbname]
di/sks          Disks to discover [disks=raw,asm,all]
ds/cvgroup              Include group name [dscvgroup=TRUE/(FALSE)]
g/roup          Disks in diskgroup [group=diskgroup]
h/ostlist               hostlist[hostlist=host1,host2,...]
metadata_a/usize                AU Size for Metadata Size Calculation
metadata_c/lients               Client Count for Metadata Size Calculation
metadata_d/isks         Disk Count for Metadata Size Calculation
metadata_n/odes         Node Count for Metadata Size Calculation
metadata_r/edundancy            Redundancy for Metadata Size Calculation
n/ohdr          KFOD header suppression [nohdr=TRUE/(FALSE)]
o/p             KFOD options type [OP=DISKS/CANDIDATES/MISSING/GROUPS/INSTS/VERSION/CLIENTS/RM/RMVERS/DFLTDSTR/GPNPDSTR/METADATA/ALL]
p/file          ASM parameter file [pfile=parameterfile]
s/tatus         Include disk header status [status=TRUE/(FALSE)]
v/erbose                KFOD verbose errors [verbose=TRUE/(FALSE)]
[grid@raclhr-18c-n1 ~]$ kfod -h
KFOD-00101: LRM error [107] while parsing command line arguments
_asm_a/llow_only_raw_disks              KFOD allow only raw devices [_asm_allow_only_raw_disks=(TRUE)/FALSE]
_asm_l/ibraries         ASM Libraries[_asm_libraries=lib1,lib2,...]
_asms/id                ASM Instance[_asmsid=sid]
_b/oot          Running in pre-install env (boot=TRUE/FALSE)
_f/lexinfo              Provide flexinfo      (_flexinfo=TRUE/FALSE)
_p/atch_lib             Patchlib [_patch_lib=<asmclntsh_path>]
_u/ser          OS Username
asm_/diskstring         ASM Diskstring [asm_diskstring=discoverystring, discoverystring ...]
asmc/ompatibility               Include diskgroup ASM compatibility [asmcompatibility=TRUE/(FALSE)]
ce/ll           KFOD display OSS site/rack info [cell=TRUE/(FALSE)]
cli/ent_cluster         client cluster name
clus_/version           cluster version
clust/er                KFOD cluster [cluster=TRUE/(FALSE)]
db_/unique_name         db_unique_name for ASM instance[db_unique_name=dbname]
dbc/ompatibility                Include diskgroup DB compatibility [dbcompatibility=TRUE/(FALSE)]
disk_/access            Disk access method [disk_access=DIRECT/(INDIRECT)]
disks           Disks to discover [disks=raw,asm,badsize,all]
ds/cvgroup              Include group name [dscvgroup=TRUE/(FALSE)]
f/orce          Force option to delete files (force=TRUE/FALSE)
g/roup          Disks in diskgroup [group=diskgroup]
h/ostlist               hostlist[hostlist=host1,host2,...]
l/abel          KFOD display disk labels [label=TRUE/(FALSE)]
metadata_a/usize                AU Size for Metadata Size Calculation
metadata_c/lients               Client Count for Metadata Size Calculation
metadata_d/isks         Disk Count for Metadata Size Calculation
metadata_n/odes         Node Count for Metadata Size Calculation
metadata_r/edundancy            Redundancy for Metadata Size Calculation
na/me           Include disk name [name=TRUE/(FALSE)]
no/hdr          KFOD header suppression [nohdr=TRUE/(FALSE)]
ol/r            Import credentials to OLR [olr=TRUE/(FALSE)]
op              KFOD options type [OP=DISKS/CANDIDATES/MISSING/GROUPS/INSTS/VERSION/PATCHES/PATCHLVL/CLIENTS/RM/RMVERS/DFLTDSTR/GPNPDSTR/METADATA/CREDCRECLUS/GETCLSTYPE/CREDEXPORT/GETASMGUID/CREDDELCLUS/CREDVERIFY/UPGRADEVERIFY/LSCC/CREDLIST/CELLCONFIG/SETDISKACCESSMODE/SETRIMACCESSMODE/ALL]
p/file          ASM parameter file [pfile=parameterfile]
r/im_disk_access                Rim disk access method [rim_disk_access=DIRECT/(INDIRECT)]
sh/allow                Do shallow discovery and report disk cnt [shallow=TRUE/(FALSE)]
st/atus         Include disk header status [status=TRUE/(FALSE)]
v/erbose                KFOD verbose [verbose=none,errors,warnings,functions,all]
w/rap           wrap file for credentials      

About Me

........................................................................................................................

● 本文作者:小麥苗,部分内容整理自網絡,若有侵權請聯系小麥苗删除

● 本文pdf版、個人簡介及小麥苗雲盤位址: ​​http://blog.itpub.net/26736162/viewspace-1624453/​​

● 資料庫筆試面試題庫及解答: ​​http://blog.itpub.net/26736162/viewspace-2134706/​​

● DBA寶典今日頭條号位址: ​​http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826​​

........................................................................................................................

● QQ群号: 230161599、618766405

● 于 2019-08-01 06:00 ~ 2019-08-31 24:00 在西安完成

● 最新修改時間:2019-08-01 06:00 ~ 2019-08-31 24:00

● 文章内容來源于小麥苗的學習筆記,部分整理自網絡,若有侵權或不當之處還請諒解

● 版權所有,歡迎分享本文,轉載請保留出處

........................................................................................................................

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2654612/,如需轉載,請注明出處,否則将追究法律責任。