RAC(下)

来源：互联网发布：sftp传输需要哪些端口编辑：程序博客网时间：2024/05/12 08:57

3 RAC进程数13
  ora.ora11g.db application    ONLINE    ONLINE    rac01
  ora....g1.inst application    ONLINE    ONLINE    rac01
  ora....g2.inst application    ONLINE    ONLINE    rac02
  ora....SM1.asm application    ONLINE    ONLINE    rac01
  ora....01.lsnr application    ONLINE    ONLINE    rac01
  ora.rac01.gsd application    ONLINE    ONLINE    rac01
  ora.rac01.ons application    ONLINE    ONLINE    rac01
  ora.rac01.vip application    ONLINE    ONLINE    rac01
  ora....SM2.asm application    ONLINE    ONLINE    rac02
  ora....02.lsnr application    ONLINE    ONLINE    rac02
  ora.rac02.gsd application    ONLINE    ONLINE    rac02
  ora.rac02.ons application    ONLINE    ONLINE    rac02
  ora.rac02.vip application    ONLINE    ONLINE    rac02
4 RAC资源查询
  $ORA_CRS_HOME/bin/crs_stat -p
5 srvctl方式启动/关闭RAC, 可以在任一节点运行
  以下示例以ora11g为全局数据库名及SID Prefix, 主机名为rac01/rac02
  -选项后面的参数值即为资源名字符串中对应资源类型的后面两个.之间的字符串
  1 启动/关闭asm进程
   srvctl start/stop asm -n rac01
  2 启动/关闭instance
   srvctl start/stop instance -d ora11g -i ora11g1
  3 启动/关闭DB(启动时，会将剩余资源拉起，stop时会关闭将数据库及所有节点的实例)
   srvctl start/stop database -d ora11g
  4 启动/关闭listener
   srvctl start/stop listener -n rac01 -l LISTENER_RAC02
  4 查看DB当前状态
   srvctl status database -d ora11g

6 ASM管理
1 查看存储划分时raw设备磁盘分布情况
cat /etc/init.d/after.local

2 查看ASM状态
select * from v$asm_disk_stat;

0 0