RAC日常检查Word格式文档下载.doc
《RAC日常检查Word格式文档下载.doc》由会员分享,可在线阅读,更多相关《RAC日常检查Word格式文档下载.doc(11页珍藏版)》请在冰豆网上搜索。
![RAC日常检查Word格式文档下载.doc](https://file1.bdocx.com/fileroot1/2022-10/7/1df7cc46-33d0-4b26-9f82-422a87c54ee3/1df7cc46-33d0-4b26-9f82-422a87c54ee31.gif)
Instanceorcl2isrunningonnodehporcl2
查看数据库实例状态:
$./srvctlstatusinstance-dorcl-iorcl1,orcl2
查看hporcl1(主机
(1)IP)ASM实例状态
$./srvctlstatusasm-nhporcl1
ASMinstance+ASM1isrunningonnodehporcl1.
查看hporcl2(主机
(2)IP)ASM实例状态
$./srvctlstatusasm-nhporcl2
ASMinstance+ASM2isrunningonnodehporcl2.
查看节点hporcl1(主机
(1)IP)应用程序(VIP、GSD、Listener、ONS)的状态:
$./srvctlstatusnodeapps-nhporcl1
VIPisrunningonnode:
hporcl1
GSDisrunningonnode:
Listenerisrunningonnode:
ONSdaemonisrunningonnode:
查看节点hporcl2(主机
(2)IP)应用程序(VIP、GSD、Listener、ONS)的状态:
$./srvctlstatusnodeapps-nhporcl2
hporcl2
用crsctl命令,检查crs相关服务的状态:
crsctlcheckcrs
查看crs及所有的service的状态:
crs_stat–t
crs_stat-ls
列出配置的所有数据库:
srvctlconfigdatabase
列出RAC数据库的配置:
srvctlconfigdatabase-dorcl
显示节点(IP:
主机
(1)IP,主机名:
hporcl1)应用程序的配置—(VIP、GSD、ONS、监听器):
srvctlconfignodeapps-nhporcl1-a-g-s–l
主机
(2)IP,主机名:
hporcl2)应用程序的配置—(VIP、GSD、ONS、监听器):
srvctlconfignodeapps-nhporcl2-a-g-s–l
ORACLE进程检查:
ps-ef|grepora_
CRS进程检查:
ps-ef|greporacm
查看监听程序状态:
lsnrctlstatus
listener日志检查(主机
(1)IP):
/oracle/app/product/10.2/db_1/network/log/listener.log
/oracle/app/product/10.2/db_1/network/log/listener_hporcl1.log
listener日志检查(主机
(2)IP):
/oracle/app/product/10.2/db_1/network/log/listener_hporcl2.log
检查SGA和PGA:
showsga
selectname,valuefromgv$sysstatwherenamelike'
%pga%'
;
selectname,valuefromv$sysstatwherenamelike'
检查参数:
showparameter
集群中所有正在运行的实例:
SELECTinst_id,
instance_numberinst_no,
instance_nameinst_name,
parallel,
status,
database_statusdb_status,
active_statestate,
host_namehost
FROMgv$instance
ORDERBYinst_id;
instance_name,
host_name,
VERSION,
TO_CHAR(startup_time,'
yyyy-mm-ddhh24:
mi:
ss'
)startup_time,
archiver,
database_status
FROMgv$instance;
检查查询服务器的运行模式和数据库安装选项:
select*fromv$option;
检查用户:
selectusername,
account_status,
default_tablespace,
temporary_tablespace,
created
fromdba_users;
selecta.username,
a.temporary_tablespace"
TemporaryTablespace"
b.contents
fromdba_usersa,dba_tablespacesb
wherea.temporary_tablespace=b.tablespace_name
andb.contents<
>
'
TEMPORARY'
控制文件检查:
select*fromv$controlfile;
无效对象检查:
SELECTowner,object_name,object_type,status,LAST_DDL_TIME
FROMdba_objects
WHEREstatuslike'
INVALID'
表空间和数据文件检查:
selectfile_id,file_name,tablespace_name,autoextensible
fromdba_data_files;
selectcount(*)fromv$datafile;
selectnamefromv$datafile
union
selectmemberfromv$logfile
selectnamefromv$controlfile
selectnamefromv$tempfile;
SELECTfile#,ts#,NAME,status,BYTES/1024/1024size_mbFROMv$datafileUNIONALLSELECT
file#,ts#,NAME,status,BYTES/1024/1024size_mbFROMv$tempfile;
检查表空间使用情况:
SELECTupper(f.tablespace_name)"
tablespace_name"
d.Tot_grootte_Mb"
tablespace(M)"
d.Tot_grootte_Mb-f.total_bytes"
used(M)"
round((d.Tot_grootte_Mb-f.total_bytes)/d.Tot_grootte_Mb*100,2)"
use%"
f.total_bytes"
free_space(M)"
round(f.total_bytes/d.Tot_grootte_Mb*100,2)"
free%"
f.max_bytes"
max_block(M)"
FROM(SELECTtablespace_name,
round(SUM(bytes)/(1024*1024),2)total_bytes,
round(MAX(bytes)/(1024*1024),2)max_bytes
FROMsys.dba_free_space
GROUPBYtablespace_name)f,
(SELECTdd.tablespace_name,
round(SUM(dd.bytes)/(1024*1024),2)Tot_grootte_Mb
FROMsys.dba_data_filesdd
GROUPBYdd.tablespace_name)d
WHEREd.tablespace_name=f.tablespace_name
ORDERBY4DESC;
SELECTdf.tablespace_name,
COUNT(*)datafile_count,
ROUND(SUM(df.BYTES)/1048576)size_mb,
ROUND(SUM(free.BYTES)/1048576,2)free_mb,
ROUND(SUM(df.BYTES)/1048576-SUM(free.BYTES)/1048576,2)used_mb,
ROUND(MAX(free.maxbytes)/1048576,2)maxfree,
100-ROUND(100.0*SUM(free.BYTES)/SUM(df.BYTES),2)pct_used,
ROUND(100.0*SUM(free.BYTES)/SUM(df.BYTES),2)pct_free
FROMdba_data_filesdf,
(SELECTtablespace_name,
file_id,