Oracle RAC 管理

关闭(特定)数据库实例
srvctl start instance -db  orcl -n rac1
数据库状态
srvctl status database -d orcl -f -v
关闭所有数据库实例
srvctl stop database -d orcl


启动所有数据库实例
srvctl start database -d orcl
数据库状态
srvctl status database -d orcl -f -v

1.启动数据库、实例和监听器
  启动和数据库关联的所有实例
  srvctl start database -db 数据库名
  
  指定启动选项
  srvctl start database -db 数据库名 -startoption nomount
  srvctl start database -db 数据库名 -startoption mount
  srvctl start database -db 数据库名 -startoption 'read only'
  
  启动监听器
  srvctl start listener
  srvctl start listener -listener LISTENER
  
  查看实例状态
  srvctl status  instance -db p19c0 -node p19c01
   
  [grid@p19c02:/home/grid]$ srvctl status  instance -db p19c0 -node p19c01
  Instance p19c01 is running on node p19c01

  
  
  查看监听器状态
  srvctl status  listener
  srvctl status  listener -node 
  
  [grid@p19c01:/home/grid]$ srvctl status  listener
  Listener LISTENER is enabled
  Listener LISTENER is running on node(s): p19c01,p19c02

  
2. 检查数据库服务的状态
   srvctl status database -db orcl
   eg:  
   [grid@p19c01:/home/grid]$ srvctl status database -db p19c0
   Instance p19c01 is running on node p19c01
   Instance p19c02 is running on node p19c02
    
    
3.停止数据库、实例和监听器
  停止数据库
  srvctl stop database -db orcl
  停止实例
  srvctl stop instance -db orcl 
  停止运行的单个实例
  srvctl stop instance -db orcl -node orcl1
  停止一个或一组实例
  srvctl stop instance -db orcl -instances "oracl1,orcl2" -stopoption immediate
  
  停止监听器
  srvctl stop listener  # 所有
  srvctl stop listener -node orcl1  #单个节点 
  

可以使用srvctl 命令 start asm 、 stop asm 、status asm 
显示ASM 实例的配置
srvctl config asm -node node_name

[grid@p19c02:/home/grid]$ srvctl config database -d p19c0
Database unique name: p19c0
Database name: p19c0
Oracle home: /u01/app/oracle/product/19.3.0/db
Oracle user: oracle
Spfile: +DATA/P19C0/PARAMETERFILE/spfile.272.1100974625
Password file: +DATA/P19C0/PASSWORD/pwdp19c0.256.1100972307
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: p19c01,p19c02
Configured nodes: p19c01,p19c02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed

查看数据库的配置
srvctl config database -d orcl
启动、禁用数据库
srvctl enable database -d orcl
srvctl disable database -d orcl

添加实例
srvctl add instance -d orcl -instance orcl1 -node orcl1