oracle rac _oifcfg iflist -p -n,RAC维护命令 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86...

一、节点层(olsnodes)

rac1-> olsnodes -help

Usage: olsnodes [-n] [-p] [-i] [ | -l] [-g] [-v]

where

-n print node number with the node name

-p print private interconnect name with the node name

-i print virtual IP name with the node name

print information for the specified node

-l print information for the local node

-g turn on logging

-v run in verbose mode

rac1-> olsnodes -p -n -i

rac1    1       rac1-priv       rac1-vip

rac2    2       rac2-priv       rac2-vip

二、网络层(oifcfg)

rac1-> oifcfg -help

Name:

oifcfg – Oracle Interface Configuration Tool.

Usage:  oifcfg iflist [-p [-n]]

oifcfg setif {-node | -global} {/:}…

oifcfg getif [-node | -global] [ -if [/] [-type ] ]

oifcfg delif [-node | -global] [[/]]

oifcfg [-help]

– name of the host, as known to a communications network

 - name by which the interface is configured in the system

  – subnet address of the interface

 - type of the interface { cluster_interconnect | public | storage }

rac1-> oifcfg iflist -n -p

eth0  10.10.10.0  PRIVATE  255.255.255.0

eth1  192.168.1.0  PRIVATE  255.255.255.0

rac1-> oifcfg getif

eth0  10.10.10.0  global  cluster_interconnect

eth1  192.168.1.0  global  public

rac1-> oifcfg getif -node rac1

rac1-> oifcfg getif -global rac1

eth0  10.10.10.0  global  cluster_interconnect

eth1  192.168.1.0  global  public

rac1-> oifcfg getif -type public

eth1  192.168.1.0  global  public

rac1-> oifcfg setif -global tnnel_1@none/10.0.0.0:public

rac1-> oifcfg getif -type public

eth1  192.168.1.0  global  public

tnnel_1@none  10.0.0.0  global  public

rac1-> oifcfg delif -global tnnel_1@none/10.0.0.0

rac1-> oifcfg getif -type public

eth1  192.168.1.0  global  public

三、集群层

1、crsctl

rac1-> crsctl

Usage: crsctl check  crs          - checks the viability of the CRS stack

crsctl check  cssd         – checks the viability of CSS

crsctl check  crsd         – checks the viability of CRS

crsctl check  evmd         – checks the viability of EVM

crsctl set    css – sets a parameter override

crsctl get    css – gets the value of a CSS parameter

crsctl unset  css – sets CSS parameter to its default

crsctl query  css votedisk    - lists the voting disks used by CSS

crsctl add    css votedisk – adds a new voting disk

crsctl delete css votedisk – removes a voting disk

crsctl enable  crs    - enables startup for all CRS daemons

crsctl disable crs    - disables startup for all CRS daemons

crsctl start crs  - starts all CRS daemons.

crsctl stop  crs  - stops all CRS daemons. Stops CRS resources in case of cluster.

crsctl start resources  - starts CRS resources.

crsctl stop resources  - stops  CRS resources.

crsctl debug statedump evm  - dumps state info for evm objects

crsctl debug statedump crs  - dumps state info for crs objects

crsctl debug statedump css  - dumps state info for css objects

crsctl debug log css [module:level]{,module:level} …

- Turns on debugging for CSS

crsctl debug trace css – dumps CSS in-memory tracing cache

crsctl debug log crs [module:level]{,module:level} …

- Turns on debugging for CRS

crsctl debug trace crs – dumps CRS in-memory tracing cache

crsctl debug log evm [module:level]{,module:level} …

- Turns on debugging for EVM

crsctl debug trace evm – dumps EVM in-memory tracing cache

crsctl debug log res turns on debugging for resources

crsctl query crs softwareversion [] – lists the version of CRS software installed

crsctl query crs activeversion – lists the CRS software operating version

crsctl lsmodules css – lists the CSS modules that can be used for debugging

crsctl lsmodules crs – lists the CRS modules that can be used for debugging

crsctl lsmodules evm – lists the EVM modules that can be used for debugging

If necesary any of these commands can be run with additional tracing by

adding a “trace” argument at the very front.

Example: crsctl trace check css

root@rac1 bin]# ./crsctl stop  crs

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

[root@rac1 bin]# ./crsctl query css votedisk

0.     0    /ocfs/clusterware/votingdisk

located 1 votedisk(s).

[root@rac1 bin]# ./crsctl add    css votedisk /ocfs/clusterware/votingdisk02 -force

Now formatting voting disk: /ocfs/clusterware/votingdisk01

successful addition of votedisk /ocfs/clusterware/votingdisk02.

[root@rac2 bin]# ./crsctl add    css votedisk /ocfs/clusterware/votingdisk02 -force

Now formatting voting disk: /ocfs/clusterware/votingdisk02

successful addition of votedisk /ocfs/clusterware/votingdisk02.

[root@rac1 bin]# ./crsctl query css votedisk

0.     0    /ocfs/clusterware/votingdisk

1.     0    /ocfs/clusterware/votingdisk01

2.     0    /ocfs/clusterware/votingdisk02

2、ocrdump

rac2-> ocrdump -help

Name:

ocrdump – Dump contents of Oracle Cluster Registry to a file.

Synopsis:

ocrdump [|-stdout] [-backupfile ] [-keyname ] [-xml] [-noheader]

Description:

Default filename is OCRDUMPFILE. Examples are:

prompt> ocrdump

writes cluster registry contents to OCRDUMPFILE in the current directory

prompt> ocrdump MYFILE

writes cluster registry contents to MYFILE in the current directory

prompt> ocrdump -stdout -keyname SYSTEM

writes the subtree of SYSTEM in the cluster registry to stdout

prompt> ocrdump -stdout -xml

writes cluster registry contents to stdout in xml format

Notes:

The header information will be retrieved based on best effort basis.

A log file will be created in

$ORACLE_HOME/log//client/ocrdump_.log. Make sure

you have file creation privileges in the above directory before

running this tool.

rac2-> ocrdump /tmp/ocr.out -keyname SYSTEM.css -xml

rac2-> ocrdump /tmp/ocr_a.out  -xml

rac2-> ocrdump -stdout -keyname SYSTEM.css -xml|more

3、ocrcheck

rac2-> ocrcheck

Status of Oracle Cluster Registry is as follows :

Version                  :          2

Total space (kbytes)     :     262144

Used space (kbytes)      :       4344

Available space (kbytes) :     257800

ID                       :  582586001

Device/File Name         : /ocfs/clusterware/ocr

Device/File integrity check succeeded

Device/File not configured

Cluster registry integrity check succeeded

4、ocrconfig

rac2-> ocrconfig

Name:

ocrconfig – Configuration tool for Oracle Cluster Registry.

Synopsis:

ocrconfig [option]

option:

-export [-s online]

- Export cluster register contents to a file

-import                  - Import cluster registry contents from a file

-upgrade [ []]

- Upgrade cluster registry from previous version

-downgrade [-version ]

- Downgrade cluster registry to the specified version

-backuploc                - Configure periodic backup location

-showbackup                         – Show backup information

-restore                 – Restore from physical backup

-replace ocr|ocrmirror [] – Add/replace/remove a OCR device/file

-overwrite                          - Overwrite OCR configuration on disk

-repair ocr|ocrmirror    - Repair local OCR configuration

-help                               – Print out this help information

Note:

A log file will be created in

$ORACLE_HOME/log//client/ocrconfig_.log. Please ensure

you have file creation privileges in the above directory before

running this tool.

rac2-> ocrconfig -showbackup

rac1     2011/07/29 20:18:22     /u01/app/oracle/product/10.2.0/crs_1/cdata/crs

rac1     2011/07/29 16:18:33     /u01/app/oracle/product/10.2.0/crs_1/cdata/crs

rac1     2011/07/29 16:18:33     /u01/app/oracle/product/10.2.0/crs_1/cdata/crs

rac1     2011/07/29 16:18:33     /u01/app/oracle/product/10.2.0/crs_1/cdata/crs

[root@rac1 bin]# cd /u01/app/oracle/product/10.2.0/crs_1/cdata/crs

[root@rac1 crs]# ll

总用量 16368

-rw-r–r–  1 root root 4554752  7月 29 20:18 backup00.ocr

-rw-r–r–  1 root root 4055040  7月 29 16:18 backup01.ocr

-rw-r–r–  1 root root 4055040  7月 29 16:18 day.ocr

-rw-r–r–  1 root root 4055040  7月 29 16:18 week.ocr

rac2-> ocrconfig -export /tmp/bak_ocr -s online

PROT-20: Insufficient permission to proceed. Require privileged user

[root@rac1 bin]# ./ocrconfig -export /tmp/bak_ocr -s online

[root@rac1 bin]# ll /tmp/bak_ocr

-rw-r–r–  1 root root 98692  7月 30 00:07 /tmp/bak_ocr

四、应用层

1、crs_stat

rac2-> crs_stat -help

Usage:  crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]

crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]

crs_stat -p [resource_name [...]] [-q]

crs_stat [-a] application -g

crs_stat [-a] application -r [-c cluster_member]

crs_stat -f [resource_name [...]] [-q] [-c cluster_member]

crs_stat -ls [resource_name [...]] [-q]

rac2-> crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host

———————————————————————-

ora…..XFF.cs application    0/0    0/1    ONLINE    ONLINE    rac1

ora….db1.srv application    0/0    0/0    ONLINE    ONLINE    rac1

ora.devdb.db   application    0/1    0/1    ONLINE    ONLINE    rac1

ora….b1.inst application    0/5    0/0    ONLINE    ONLINE    rac1

ora….b2.inst application    0/5    0/0    ONLINE    ONLINE    rac2

ora….SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1

ora….C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1

ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1

ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1

ora….SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2

ora….C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2

ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2

ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

rac2-> crs_stat -p ora.devdb.db

NAME=ora.devdb.db

TYPE=application

ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/crs_1/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for the Database

FAILOVER_DELAY=0

FAILURE_INTERVAL=60

FAILURE_THRESHOLD=1

HOSTING_MEMBERS=

OPTIONAL_RESOURCES=

PLACEMENT=balanced

REQUIRED_RESOURCES=

RESTART_ATTEMPTS=1

SCRIPT_TIMEOUT=600

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=

2、srvctl

rac2-> srvctl

用法: srvctl []

命令: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config

对象: database|instance|service|nodeapps|asm|listener

有关各个命令和对象的详细帮助, 请使用:

srvctl -h

rac2-> srvctl config database

devdb

rac2-> srvctl config database -d devdb

rac1 devdb1 /u01/app/oracle/product/10.2.0/db_1

rac2 devdb2 /u01/app/oracle/product/10.2.0/db_1

rac2-> srvctl config database -d devdb -a

rac1 devdb1 /u01/app/oracle/product/10.2.0/db_1

rac2 devdb2 /u01/app/oracle/product/10.2.0/db_1

DB_NAME: devdb

ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1

SPFILE: +DG1/devdb/spfiledevdb.ora

DOMAIN: null

DB_ROLE: null

START_OPTIONS: null

POLICY:  AUTOMATIC

ENABLE FLAG: DB ENABLED

rac2-> srvctl config nodeapps -n rac1

rac1 devdb1 /u01/app/oracle/product/10.2.0/db_1

rac2-> srvctl config nodeapps -h

用法: srvctl config nodeapps -n [-a] [-g] [-o] [-s] [-l]

-n           节点名

-a                  显示 TNS 条目

-g                  显示 GSD 配置

-s                  显示 ONS 守护程序配置

-l                  显示监听程序配置

-h                  打印用法

rac2-> srvctl config nodeapps -n rac2 -l

监听程序已存在。

rac2-> srvctl config nodeapps -n rac1 -a

VIP 已存在。: /rac1-vip/192.168.1.21/255.255.255.0/eth0:eth1

rac2-> srvctl config listener -n rac2

rac2 LISTENER_RAC2

rac2-> srvctl config asm -n rac1

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

rac2-> srvctl config service -h

用法: srvctl config service -d [-s ] [-a] [-S ]

-d           数据库的唯一名称

-s        服务名

-a                  附加属性

-S          EM 控制台的附加信息

-h                  打印用法

rac2-> srvctl config service -d devdb -a

XFF PREF: devdb1 AVAIL: devdb2 TAF: basic

–设置XFF service 不开机启动

ac2-> srvctl disable service -h

用法: srvctl disable service -d -s “” [-i ]

-d           数据库的唯一名称

-s “”     逗号分隔的服务名

-i           实例名

-h                  打印用法

rac2-> srvctl disable service -d devdb -s XFF -i devdb1

rac2-> srvctl config service -d devdb -a

XFF PREF: devdb1 AVAIL: devdb2 TAF: basic

在实例 devdb1 上禁用服务 XFF。

rac2-> srvctl enable service -h

用法: srvctl enable service -d -s “” [-i ]

-d           数据库的唯一名称

-s “”     逗号分隔的服务名

-i           实例名

-h                  打印用法

rac2-> srvctl enable service -d devdb -s XFF -i devdb1

rac2-> srvctl config service -d devdb -a

XFF PREF: devdb1 AVAIL: devdb2 TAF: basic

–添加xff2 service

rac2-> srvctl add service -h

用法: srvctl add service -d -s -r “” [-a ""] [-P ]

-d           数据库的唯一名称

-s        服务名

-r “”    首选实例列表

-a “”   可用实例列表

-P     TAF 策略 (NONE, BASIC, 或 PRECONNECT)

用法: srvctl add service -d -s -u {-r “” | -a “”}

-d           数据库的唯一名称

-s        服务名

-u                  为服务配置添加一个新实例

-r  新首选实例的名称

-a 新可用实例的名称

-h                  打印用法

rac2-> srvctl add service -d devdb -s xff2 -r devdb2 -a devdb1  -P BASIC

rac2-> srvctl config service -d devdb -a

XFF PREF: devdb1 AVAIL: devdb2 TAF: basic

xff2 PREF: devdb2 AVAIL: devdb1 TAF: BASIC

rac2-> crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host

———————————————————————-

ora…..XFF.cs application    0/0    0/1    ONLINE    ONLINE    rac1

ora….db1.srv application    0/0    0/0    ONLINE    ONLINE    rac2

ora.devdb.db   application    0/1    0/1    ONLINE    ONLINE    rac1

ora….b1.inst application    0/5    0/0    ONLINE    ONLINE    rac1

ora….b2.inst application    0/5    0/0    ONLINE    ONLINE    rac2

ora….xff2.cs application    0/0    0/1    OFFLINE   OFFLINE

ora….db2.srv application    0/0    0/0    OFFLINE   OFFLINE

ora….SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1

ora….C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1

ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1

ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1

ora….SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2

ora….C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2

ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2

ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

–设置xff2 service 开机自启动

rac2->  srvctl enable service -d devdb -s xff2 -i devdb1

rac2->  srvctl enable service -d devdb -s xff2 -i devdb2

–启动xff2 service

rac2-> srvctl start service -d devdb -s xff2 -i devdb1

rac2-> crs_stat -t

Name           Type           Target    State     Host

————————————————————

ora…..XFF.cs application    ONLINE    ONLINE    rac1

ora….db1.srv application    ONLINE    ONLINE    rac2

ora.devdb.db   application    ONLINE    ONLINE    rac1

ora….b1.inst application    ONLINE    ONLINE    rac1

ora….b2.inst application    ONLINE    ONLINE    rac2

ora….xff2.cs application    ONLINE    ONLINE    rac2

ora….db2.srv application    ONLINE    ONLINE    rac1

ora….SM1.asm application    ONLINE    ONLINE    rac1

ora….C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora….SM2.asm application    ONLINE    ONLINE    rac2

ora….C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

rac2-> srvctl status  service -d devdb -v

服务 XFF 正在实例 devdb2 上运行

服务 xff2 正在实例 devdb1 上运行

–停用xff2 service

rac2-> srvctl stop service -d devdb -s xff2 -i devdb1

rac2-> crs_stat -t

Name           Type           Target    State     Host

————————————————————

ora…..XFF.cs application    ONLINE    ONLINE    rac1

ora….db1.srv application    ONLINE    ONLINE    rac2

ora.devdb.db   application    ONLINE    ONLINE    rac1

ora….b1.inst application    ONLINE    ONLINE    rac1

ora….b2.inst application    ONLINE    ONLINE    rac2

ora….xff2.cs application    ONLINE    ONLINE    rac2

ora….db2.srv application    OFFLINE   OFFLINE

ora….SM1.asm application    ONLINE    ONLINE    rac1

ora….C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora….SM2.asm application    ONLINE    ONLINE    rac2

ora….C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

rac2-> srvctl status  service -d devdb -v

服务 XFF 正在实例 devdb2 上运行

服务 xff2 未运行。

–删除xff2 service

rac2-> srvctl remove service -h

用法: srvctl remove service -d -s [-i ] [-f]

-d           数据库的唯一名称

-s        服务名

-i           实例名

-f                  强制删除

-h                  打印用法

rac2-> srvctl remove service -d devdb -s xff2

xff2 PREF: devdb2 AVAIL: devdb1

是否从数据库 devdb 中删除服务 xff2? (y/[n]) y

rac2-> crs_stat -t

Name           Type           Target    State     Host

————————————————————

ora…..XFF.cs application    ONLINE    ONLINE    rac1

ora….db1.srv application    ONLINE    ONLINE    rac2

ora.devdb.db   application    ONLINE    ONLINE    rac1

ora….b1.inst application    ONLINE    ONLINE    rac1

ora….b2.inst application    ONLINE    ONLINE    rac2

ora….SM1.asm application    ONLINE    ONLINE    rac1

ora….C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora….SM2.asm application    ONLINE    ONLINE    rac2

ora….C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

注意使用-h或者help帮助功能