管理11g RAC之DB实验

实验内容如下：

查看所有实例状态 ：

[grid@rac121 ~]$ srvctl status database -d racdbInstance racdb1 is running on node rac121Instance racdb2 is running on node rac122

查看单个实例状态：

[grid@rac121 ~]$ srvctl status instance -d racdb -i racdb1Instance racdb1 is running on node rac121

查看节点应用程序状态：

Instance racdb1 is running on node rac121[grid@rac121 ~]$ srvctl status nodeappsVIP rac121-vip is enabledVIP rac121-vip is running on node: rac121VIP rac122-vip is enabledVIP rac122-vip is running on node: rac122Network is enabledNetwork is running on node: rac121Network is running on node: rac122GSD is disabledGSD is not running on node: rac121GSD is not running on node: rac122ONS is enabledONS daemon is running on node: rac121ONS daemon is running on node: rac122

查看所有配置的数据库：【这儿只配置了一个racdb】

[grid@rac121 ~]$ srvctl config databaseracdb

查看指定的数据库配置：

[grid@rac121 ~]$ srvctl config database -d racdb -aDatabase unique name: racdbDatabase name: racdbOracle home: /oradata/oracleapp/oracle/product/11.2.0/db1Oracle user: oracleSpfile: +RACDB_DATA/racdb/spfileracdb.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: racdbDatabase instances: racdb1,racdb2Disk Groups: RACDB_DATA,FRAMount point paths: Services: Type: RACDatabase is enabledDatabase is administrator managed

查看ASM状态及配置：

[grid@rac121 ~]$ srvctl status asm -aASM is running on rac121,rac122ASM is enabled.[grid@rac121 ~]$ srvctl config asmASM home: /oradata/oracleapp/11.2.0/gridASM listener: LISTENER

查看TNS监听器状态及配置：

[grid@rac121 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac121,rac122Listener NEW_RACDB_LISTENER is enabledListener NEW_RACDB_LISTENER is running on node(s): rac121,rac122Listener RACDB_LISTENER is enabledListener RACDB_LISTENER is running on node(s): rac121,rac122[grid@rac121 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: <CRS home>  /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1521Name: NEW_RACDB_LISTENERNetwork: 1, Owner: gridHome: <CRS home>  /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1523Name: RACDB_LISTENERNetwork: 1, Owner: gridHome: <CRS home>  /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1522

查看SCAN状态及配置：

[grid@rac121 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac122[grid@rac121 ~]$ srvctl config scan SCAN name: rac-scan, Network: 1/10.1.252.0/255.255.255.0/eth0SCAN VIP name: scan1, IP: /rac-scan/10.1.252.68

查看VIP各个节点的状态及配置：

[grid@rac121 ~]$ srvctl status vip -i rac121-vip #通过VIP name查看VIP rac121-vip is enabledVIP rac121-vip is running on node: rac121[grid@rac121 ~]$ srvctl status vip -n rac121  #通过节点名查看VIP rac121-vip is enabledVIP rac121-vip is running on node: rac121[grid@rac121 ~]$ srvctl config vip -i rac121-vipVIP exists: /rac121-vip/10.1.252.75/10.1.252.0/255.255.255.0/eth0, hosting node rac121[grid@rac121 ~]$ srvctl config vip -n rac121VIP exists: /rac121-vip/10.1.252.75/10.1.252.0/255.255.255.0/eth0, hosting node rac121

查看节点应用程序配置：

[grid@rac121 ~]$ srvctl config nodeapps -lWarning:-l option has been deprecated and will be ignored.Network exists: 1/10.1.252.0/255.255.255.0/eth0, type staticVIP exists: /rac121-vip/10.1.252.75/10.1.252.0/255.255.255.0/eth0, hosting node rac121VIP exists: /rac122-vip/10.1.252.76/10.1.252.0/255.255.255.0/eth0, hosting node rac122GSD existsONS exists: Local port 6100, remote port 6200, EM port 2016Name: LISTENERNetwork: 1, Owner: gridHome: <CRS home>End points: TCP:1521

验证集群节点间的时钟同步：

[grid@rac121 ~]$ cluvfy comp clocksync -verboseVerifying Clock Synchronization across the cluster nodes Checking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodes  Node Name                             Status                    ------------------------------------  ------------------------  rac121                                passed                  Result: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS state  Node Name                             State                     ------------------------------------  ------------------------  rac121                                Active                  CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...Reference Time Offset Limit: 1000.0 msecsCheck: Reference Time Offset  Node Name     Time Offset               Status                    ------------  ------------------------  ------------------------  rac121        0.0                       passed                  Time offset is within the specified limits on the following set of nodes: "[rac121]" Result: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful. 

查看ASM磁盘卷：

SQL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/mapper/vol-aidev08/dev/mapper/vol-aidev05/dev/mapper/vol-aidev07/dev/mapper/vol-aidev06/dev/mapper/vol-aidev03/dev/mapper/vol-aidev04/dev/mapper/vol-aidev01/dev/mapper/vol-aidev028 rows selected.

srvclt起停所有实例：

[grid@rac121 ~]$ srvctl stop database -d racdb[grid@rac121 ~]$ srvctl start database -d racdb