oracle10g RAC集群與數據庫操作

最新推荐文章于 2024-09-14 19:55:29 发布

cj1112020

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量79

点赞数

文章标签：数据库运维

經過將近半個月的奮斗﹐終于又在同一台主機上通過vmware軟件安裝上了oracle10g RAC。通過這次安裝﹐基本上熟悉了OCFS2和ASMLib的安裝﹐雖然因為硬件限制的原故﹐最后還是沒有在安裝好的RAC中使用OCFS2和ASMLib。

接下來﹐在安裝好的RAC中學習SRVCTL和TAF(透明的应用程序故障切换)

一﹑验证 RAC 集群和数据库配置

有五個為SRVCTL定義的節點級任務﹕

1.刪除和添加節點級應用程序

2.設置或取消設置節點級應用程序的環境

3.管理節點應用程序

4.管理ASM實例

5.啟用和停止一組包含虛擬IP地址﹑監聽器﹑oracle通知服務和oracle企業管理器代理的程序(出于維護目的)

1) 先看看srvctl所有指令﹕

2) 顯示所有实例和服务的状态

[oracle@vmrac1 ~]$ srvctl status database -d vmrac
Instance vmrac1 is running on node vmrac1
Instance vmrac2 is running on node vmrac2

顯示單個實例的狀態:

[oracle@vmrac1 ~]$ srvctl status instance -d vmrac -i vmrac1
Instance vmrac1 is running on node vmrac1
[oracle@vmrac1 ~]$ srvctl status instance -d vmrac -i vmrac2
Instance vmrac2 is running on node vmrac2

3) 顯示數據庫全局命名服務的狀態

[oracle@vmrac1 ~]$ srvctl status service -d vmrac -s vmractest
Service vmractest is running on instance(s) vmrac2, vmrac1

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

[oracle@vmrac1 ~]$ srvctl status nodeapps -n vmrac1
VIP is running on node: vmrac1
GSD is running on node: vmrac1
Listener is running on node: vmrac1
ONS daemon is running on node: vmrac1
[oracle@vmrac1 ~]$ srvctl status nodeapps -n vmrac2
VIP is running on node: vmrac2
GSD is running on node: vmrac2
Listener is running on node: vmrac2
ONS daemon is running on node: vmrac2

5) ASM實例的狀態

[oracle@vmrac1 ~]$ srvctl status asm -n vmrac1
ASM instance +ASM1 is running on node vmrac1.
[oracle@vmrac1 ~]$ srvctl status asm -n vmrac2
ASM instance +ASM2 is running on node vmrac2.

6) 列出配置的所有數據庫

[oracle@vmrac1 ~]$ srvctl config database
vmrac

7) 顯示數據庫的配置

[oracle@vmrac1 ~]$ srvctl config database -d vmrac
vmrac1 vmrac1 /oracle/product/10.2.0/db_home
vmrac2 vmrac2 /oracle/product/10.2.0/db_home

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

[oracle@vmrac1 ~]$ srvctl config service -d vmrac
vmractest PREF: vmrac2 vmrac1 AVAIL:

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

[oracle@vmrac1 ~]$ srvctl config nodeapps -n vmrac1 -a -g -s -l
VIP exists.: /vmrac1-vip.localdomain/172.24.2.53/255.255.255.0/eth0
GSD exists.
ONS daemon exists.
Listener exists.
[oracle@vmrac1 ~]$ srvctl config nodeapps -n vmrac2 -a -g -s -l
VIP exists.: /vmrac2-vip.localdomain/172.24.2.54/255.255.255.0/eth0
GSD exists.
ONS daemon exists.
Listener exists.

10) 顯示ASM實例

[oracle@vmrac1 ~]$ srvctl config asm -n vmrac1
+ASM1 /oracle/product/10.2.0/db_home
[oracle@vmrac1 ~]$ srvctl config asm -n vmrac2
+ASM2 /oracle/product/10.2.0/db_home

二﹑啟動/停止集群

1) 停止oracle 10g RAC 環境

首先停止oracle實例﹐當該實例(和相關的服務)關閉后﹐接著停止ASM實例。最后關閉節點應用程序(VIP﹑ GSD﹑ONS和TNS監聽器)

[oracle@vmrac1 ~]$ emctl stop dbconsole
TZ set to ROC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://vmrac1.localdomain:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@vmrac1 ~]$ srvctl stop instance -d vmrac -i vmrac1
[oracle@vmrac1 ~]$ srvctl stop asm -n vmrac1
[oracle@vmrac1 ~]$ srvctl stop nodeapps -n vmrac1

2) 啟動oracle 10g RAC 環境

第一步是启动节点应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）。当成功启动节点应用程序后，启动 ASM 实例。最后，启动 Oracle 实例（和相关服务）以及企业管理器数据库控制台。
[oracle@vmrac1 ~]$ srvctl start nodeapps -n vmrac1
[oracle@vmrac1 ~]$ srvctl start asm -n vmrac1
[oracle@vmrac1 ~]$ srvctl start instance -d vmrac -i vmrac1
[oracle@vmrac1 ~]$ emctl start dbconsole
TZ set to ROC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://vmrac1.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............. started.
------------------------------------------------------------------
Logs are generated in directory /oracle/product/10.2.0/db_home/vmrac1_vmrac1/sysman/log
[oracle@vmrac1 ~]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/33600/viewspace-266411/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/33600/viewspace-266411/