Oracle RAC 資料收集

http://www.D

數據庫吧

oracle rac日常基本維護命令2

Oracle RAC性能調整12

詳解Oracle RAC入門和提高27

ORACLE RAC數據庫配置Dataguard環境49

老白對于RAC應用調優的建議51

oracle rac日常基本維護命令

所有實例和服務的狀態

$ srvctl status database -d orcl

Instance orcl1 is running on node linux1

Instance orcl2 is running on node linux2

單個實例的狀態

$ srvctl status instance -d orcl -i orcl2

Instance orcl2 is running on node linux2

在數據庫全局命名服務的狀態

$ srvctl status service -d orcl -s orcltest

Service orcltest is running on instance(s) orcl2, orcl1

特定節點上節點應用程序的狀態

$ srvctl status nodeapps -n linux1

VIP is running on node: linux1

GSD is running on node: linux1

Listener is running on node: linux1

ONS daemon is running on node: linux1

ASM 實例的狀態

$ srvctl status asm -n linux1

ASM instance +ASM1 is running on node linux1.

列出配置的所有數據庫

$ srvctl config database

orcl

顯示 RAC 數據庫的配置

$ srvctl config database -d orcl

linux1 orcl1 /u01/app/oracle/product/10.2.0/db_1

linux2 orcl2 /u01/app/oracle/product/10.2.0/db_1

顯示指定集群數據庫的所有服務

$ srvctl config service -d orcl

orcltest PREF: orcl2 orcl1 AVAIL:

顯示節點應用程序的配置 —(VIP、GSD、ONS、監聽器)

$ srvctl config nodeapps -n linux1 -a -g -s -l

VIP exists.: /linux1-vip/00//eth0:eth1

GSD exists.

ONS daemon exists.

Listener exists.

顯示 ASM 實例的配置

$ srvctl config asm -n linux1

+ASM1 /u01/app/oracle/product/10.2.0/db_1

集群中所有正在運行的實例

SELECT

inst_id

, instance_number inst_no

, instance_name inst_name

, parallel

, status

, database_status db_status

, active_state state

, host_name host

FROM gv$instance

ORDER BY inst_id;

INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST

-------- -------- ---------- --- ------- ------------ --------- -------

1 1 orcl1 YES OPEN ACTIVE NORMAL rac1

2 2 orcl2 YES OPEN ACTIVE NORMAL rac2

位于磁盤組中的所有數據文件

select name from v$datafile

union

select member from v$logfile

union

select name from v$controlfile

union

select name from v$tempfile;

NAME

-------------------------------------------

+FLASH_RECOVERY_AREA/orcl/controlfile/current.258.570913191

+FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.257.57091

總結

以上是生活随笔為你收集整理的oracle rac维护命令,2015年oracle rac日常基本维护命令.doc的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。