RAC日常检查.doc
- 文档编号:231778
- 上传时间:2022-10-07
- 格式:DOC
- 页数:11
- 大小:52KB
RAC日常检查.doc
《RAC日常检查.doc》由会员分享,可在线阅读,更多相关《RAC日常检查.doc(11页珍藏版)》请在冰豆网上搜索。
出入境RAC日常检查
数据库名db_name:
orcl
Db_unique_name:
orcl
service_names:
orcl
实例名主机
(1)IP:
orcl1
实例名主机
(2)IP:
orcl2
主机名主机
(1)IP:
hporcl1
主机名主机
(2)IP:
hporcl2
查看实例数据库状态:
$./srvctlstatusdatabase-dorcl
Instanceorcl1isrunningonnodehporcl1
Instanceorcl2isrunningonnodehporcl2
查看数据库实例状态:
$./srvctlstatusinstance-dorcl-iorcl1,orcl2
Instanceorcl1isrunningonnodehporcl1
Instanceorcl2isrunningonnodehporcl2
查看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:
hporcl1
Listenerisrunningonnode:
hporcl1
ONSdaemonisrunningonnode:
hporcl1
查看节点hporcl2(主机
(2)IP)应用程序(VIP、GSD、Listener、ONS)的状态:
$./srvctlstatusnodeapps-nhporcl2
VIPisrunningonnode:
hporcl2
GSDisrunningonnode:
hporcl2
Listenerisrunningonnode:
hporcl2
ONSdaemonisrunningonnode:
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
显示节点(IP:
主机
(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.log
/oracle/app/product/10.2/db_1/network/log/listener_hporcl2.log
检查SGA和PGA:
showsga
selectname,valuefromgv$sysstatwherenamelike'%pga%';
selectname,valuefromv$sysstatwherenamelike'%pga%';
检查参数:
showparameter
集群中所有正在运行的实例:
SELECTinst_id,
instance_numberinst_no,
instance_nameinst_name,
parallel,
status,
database_statusdb_status,
active_statestate,
host_namehost
FROMgv$instance
ORDERBYinst_id;
SELECTinst_id,
instance_name,
host_name,
VERSION,
TO_CHAR(startup_time,'yyyy-mm-ddhh24:
mi:
ss')startup_time,
status,
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
union
selectnamefromv$controlfile
union
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,
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- RAC 日常 检查