Oracle rac集群啟停操作過程

首先查看數(shù)據(jù)庫的集群的db_unique_name

SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
cdb_cluster_name                     string
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      p19c0
db_unique_name                       string      p19c0
global_names                         boolean     FALSE
instance_name                        string      p19c01
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------------
service_names                        string      p19c0

–確認(rèn)集群的instance_name
SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS

p19c01 OPEN
p19c02 OPEN

Step 1.停止以及查看數(shù)據(jù)庫

su - grid
srvctl stop database -d p19c0
srvctl status database -d p19c0 

Step 2.停止集群服務(wù)

su - root
/u01/app/19.3.0/grid/bin/crsctl stop cluster -all

Step 3.啟動 集群服務(wù)（root）：

/u01/app/19.3.0/grid/bin/crsctl start cluster -all --會啟動數(shù)據(jù)庫
/u01/app/19.3.0/grid/bin/crsctl start has --啟動數(shù)據(jù)庫
/u01/app/19.3.0/grid/bin/crsctl start crs

/u01/app/19.3.0/grid/bin/crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'
CRS-2672: Attempting to start 'ora.evmd' on 'node1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node2'
CRS-2672: Attempting to start 'ora.evmd' on 'node2'
CRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node1'
CRS-2672: Attempting to start 'ora.diskmon' on 'node1'
CRS-2676: Start of 'ora.diskmon' on 'node1' succeeded
CRS-2676: Start of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node2'
CRS-2672: Attempting to start 'ora.diskmon' on 'node2'
CRS-2676: Start of 'ora.diskmon' on 'node2' succeeded
CRS-2676: Start of 'ora.evmd' on 'node1' succeeded
CRS-2676: Start of 'ora.evmd' on 'node2' succeeded
CRS-2676: Start of 'ora.cssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node1'
CRS-2672: Attempting to start 'ora.ctssd' on 'node1'
CRS-2676: Start of 'ora.cssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node1'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node2'
CRS-2676: Start of 'ora.asm' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'node2'
CRS-2676: Start of 'ora.asm' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'node1'
CRS-2676: Start of 'ora.storage' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node1'
CRS-2676: Start of 'ora.crsd' on 'node1' succeeded
CRS-2676: Start of 'ora.storage' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node2'
CRS-2676: Start of 'ora.crsd' on 'node2' succeeded

Step 4. 啟動數(shù)據(jù)庫：

crsctl status res -t

srvctl status database -d p19c0
srvctl start database -d p19c0

文章來源地址http://www.zghlxwxcb.cn/news/detail-822526.html

Oracle rac單節(jié)點(diǎn)重啟操作過程

1.root查看系統(tǒng)監(jiān)控進(jìn)程

ps -ef|grep smon

2.切換到oracle用戶

su - oracle

3.sys用戶登錄數(shù)據(jù)庫

sqlplus / as sysdba

4.檢查點(diǎn)切換 停庫前執(zhí)行 alter system checkpoint 很重要!

alter system checkpoint;

5.強(qiáng)制系統(tǒng)進(jìn)行日志切換 6次

ALTER SYSTEM SWITCH LOGFILE;

6.關(guān)閉所有的容器數(shù)據(jù)庫

alter pluggable database all close immediate;

7.關(guān)閉實(shí)例

srvctl stop instance -d p19c0 -i p19c01

退出oracle用戶到root

su - root

8.設(shè)置在服務(wù)器啟動時,自動啟動crs守護(hù)進(jìn)程

crsctl enable crs1.

9.強(qiáng)制關(guān)閉所有crs守護(hù)進(jìn)程

crsctl stop crs -f1.

10.查看集群狀態(tài)

crsctl status res -t1.

11.重啟操作系統(tǒng)

shutdown

12.重啟完成后操作

su - oracle

srvctl start instance -d p19c0 -i p19c01

crsctl status res -t1.2.3.4.5.

到了這里，關(guān)于Oracle 19c rac集群管理 -------- 集群啟停操作過程的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！