Oracle RAC

RAC异常重启分析
-----信息收集命令：
/u01/app/grid/grid_home/tfa/bin/tfactl diagcollect -from "Aug/5/2020 22:00:00" -to "Aug/5/2020 23:00:00" 
-----如果命令执行报错，使用下面命令启动tfa后再执行收集：
/u01/app/grid/grid_home/tfa/bin/tfactl start

---

修改KDUMP和重启
-----修改KDUMP配置
root执行，crsctl 用绝对路径:
[grid@xxxxx ~]$ which crsctl
/u01/app/grid/grid_home/bin/crsctl

【root】
/u01/app/grid/grid_home/bin/crsctl modify type ora.cssd.type -attr "ATTRIBUTE=REBOOT_OPTS, TYPE=string,DEFAULT_VALUE=,FLAGS=CONFIG" -init
/u01/app/grid/grid_home/bin/crsctl modify res ora.cssd -attr "REBOOT_OPTS=CRASHDUMP" -init
/u01/app/grid/grid_home/bin/crsctl modify type ora.cssdmonitor.type -attr "ATTRIBUTE=REBOOT_OPTS,TYPE=string,DEFAULT_VALUE=,FLAGS=CONFIG" -init
/u01/app/grid/grid_home/bin/crsctl modify res ora.cssdmonitor -attr "REBOOT_OPTS=CRASHDUMP" -init

RAC停库
srvctl stop database -d 
或者：进入每个库，shutdown immediate

停监听
srvctl stop LISTENER

取消自启动
/u01/app/grid/grid_home/bin/crsctl disable crs
/u01/app/grid/grid_home/bin/crsctl stop crs

机器重启后，开启自启动
/u01/app/grid/grid_home/bin/crsctl enable crs
/u01/app/grid/grid_home/bin/crsctl start crs

export ORACLE_SID=
startup;
export ORACLE_SID=
startup;

看集群状态
/u01/app/grid/grid_home/bin/crsctl stat res -t

启动监听
srvctl start listener -n cxdxdb1

SQL> select instance_name,startup_time,status from gv$instance;
INSTANCE_NAME    STARTUP_TIME        STATUS
---------------- ------------------- ------------
xxxxx2          2020-08-09 23:59:45 OPEN
xxxxx1          2020-01-23 07:17:03 OPEN

最后 crsctl stat res -t   中除了 gsd和oc4j，其他进程起来就ok了

查看进程：
SELECT sid, serial#, username, osuser FROM v$session;

---

RAC 重启
su - grid

检查状态
crsctl stat res -t

[root@hostname bin]# ./crsctl stop crs
[root@hostname bin]# ./crsctl start crs
或者强制    /u01/app/grid/grid_home/bin/crsctl stop crs -f

加载监听
[grid@hostname ~]$ srvctl relocate scan_listener -i 1 -n hostname
[grid@hostname ~]$ ps -ef | grep tns
root        736      2  0 21:43 ?        00:00:00 [netns]
grid      69389      1  0 21:45 ?        00:00:00 /u01/app/grid/grid_home/bin/tnslsnr LISTENER -inherit
grid      78988      1  0 21:53 ?        00:00:00 /u01/app/grid/grid_home/bin/tnslsnr LISTENER_SCAN1 -inherit

启动节点
srvctl start instance -d dbname -i dbname1
或者下面方式
[oracle@cxdjgldb9419 ~]$ export ORACLE_SID=
[oracle@cxdjgldb9419 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 19 21:59:04 2021
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.0155E+11 bytes
Fixed Size                  2265056 bytes
Variable Size            2.0670E+10 bytes
Database Buffers         8.0531E+10 bytes
Redo Buffers              347648000 bytes
Database mounted.
Database opened.

SQL> show parameter standby
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select open_mode,protection_mode,database_role from v$database; 
OPEN_MODE            PROTECTION_MODE      DATABASE_ROLE
-------------------- -------------------- ----------------
READ WRITE           MAXIMUM PERFORMANCE  PRIMARY

---

RAC drop database 步骤
mos中有一篇note提到如果是RAC数据库使用DROP DATABASE 要设置CLUSTER_DATABASE=FALSE(alter system set cluster_database=FALSE scope=spfile;)然后mount数据库，再删除。
参考What Is The Best Way To Remove A Database If Using Oracle 10.x And Higher (Doc ID 362047.1)

show parameter cluster
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2
cluster_interconnects                string

alter system set cluster_database=false scope=spfile;
System altered.

shutdown abort
ORACLE instance shut down

startup mount exclusive restrict;
ORACLE instance started.
Total System Global Area 4.1557E+10 bytes
Fixed Size                  2237328 bytes
Variable Size            1.3959E+10 bytes
Database Buffers         2.7515E+10 bytes
Redo Buffers               81035264 bytes
Database mounted

alter system enable restricted session;
System altered

drop database;
Database dropped.

ps:DBCA删除操作可以更干净。

---

发现节点1 spfile在本地目录，整改入asm中

关闭实例1
export ORACLE_SID=
sqlplus / as sysdba
shutdown immediate

删除dbs下的spfile
cd /u01/oracle/product/db11gr2/dbs
rm spfilexxxx.ora

启动实例1
export ORACLE_SID=
sqlplus / as sysdba
startup

修改参数
alter system set log_archive_dest_2='service=xxxxx_sec LGWR ASYNC NOAFFIRM NET_TIMEOUT=30 COMPRESSION=ENABLE';
alter system set log_archive_dest_state_2='ENABLE';
alter system set log_archive_max_processes=8;
alter system set standby_file_management='AUTO';

检查2个节点的参数
show parameter log_archive
show parameter log_archive_max_processes
show parameter standby_file_management

二级DG同步状态
select PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby;
col value for a20 
col name for a30 
select name,value,unit from v$dataguard_stats;