1 Cluster Healthy Check
ocrcheck
ocrconfig -showbackup
crsctl query css votedisk
crs_stat
2 DB Healthy Check
alert.log
select * from v$recover_file;
3 Tablespace Check
set serverout on
exec sp_freespace(80);
4 ASM Related Check
asmcmd>lsdg
5 Backup Related Check
Previous day backup log
7 OS session related check
df -k
8 Security Related Check
illegal acceess
9 Invalid Object Related Check
10 Performance Related Check
主要是AWR
11 Hang session and Block Session Check
12 Time Sync Check
14 Object count check
15 ASSM Table shrink Related
find the most fraged table, shrink in suitable time
不过现在主要靠shell,每天看看shell结果,上grid control看看有没有异常就完事了
ocrcheck
ocrconfig -showbackup
crsctl query css votedisk
crs_stat
2 DB Healthy Check
alert.log
select * from v$recover_file;
3 Tablespace Check
set serverout on
exec sp_freespace(80);
4 ASM Related Check
asmcmd>lsdg
5 Backup Related Check
Previous day backup log
7 OS session related check
df -k
8 Security Related Check
illegal acceess
9 Invalid Object Related Check
10 Performance Related Check
主要是AWR
11 Hang session and Block Session Check
12 Time Sync Check
14 Object count check
15 ASSM Table shrink Related
find the most fraged table, shrink in suitable time
不过现在主要靠shell,每天看看shell结果,上grid control看看有没有异常就完事了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/317003/viewspace-544590/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/317003/viewspace-544590/