RAC_DG_CHECK.SH.pdf
5墨值下载
#!/bin/bash
source /home/oracle/.bash_profile
datetime=`date +%Y%m%d_%H%M%S_%N |cut -b1-20`
date=$(date +%Y%m%d%H)
echo "***********Demodb 系统检查*************"$date > /home/oracle/Demodb_check.log
sqlplus -s username/123456 >> /home/oracle/nc65rman/Demodb_check.log<<EOF
host echo "================表空间检查============================="
set linesize 300 pagesize 1000
col "Status" for a20
col "Name" for a10
col "Type" for a20
col "Extent" for a20
col "Size (M)" for a20
col "Used (M)" for a20
col "Used %" for a20
SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management
"Extent",
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,990') "Size (M)",
TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024,'999,999,999') "Used (M)",
TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), '990.00') "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes from dba_data_files
group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes from dba_free_space
group by tablespace_name) f WHERE
d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND
NOT
(d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')
UNION ALL
SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management
"Extent",
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,999') "Size (M)",
TO_CHAR(NVL(t.bytes,0)/1024/1024,'999,999,999') "Used (M)",
TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), '990.00') "Used %" FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) a, (select
tablespace_name, sum(bytes_cached) bytes from v\$temp_extent_pool group by tablespace_name) t
WHERE
d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND
d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY'
ORDER BY 7;
host echo "================实例状态检查============================"
host srvctl status database -d Demodb -v
host srvctl status asm
host srvctl status nodeapps
host echo "================RAC 集群状态检查=========================="
host /oracle/app/product/11.2.0/bin/crsctl check crs
host echo "================监听检查=================================="
host lsnrctl status
host echo "================数据文件================================="
select file#,status from v\$datafile where status not in ('SYSTEM','ONLINE');
host echo "===============控制文件状态=============================="
select status ,name from v\$controlfile where status='INVALID';
host echo "================日志文件状态============================="
select member ,status from v\$logfile where status is not null;
host echo "================AsmDiskGroup(asm 磁盘组使用情况)============="
select GROUP_NUMBER,name,type,state,TOTAL_MB "TOTAL_MB",FREE_MB
"FREE_Mb",TO_CHAR(NVL((total_MB - NVL(FREE_MB, 0)) / TOTAL_MB * 100, 0),'990.00')
"Used %"
from v\$asm_diskgroup order by 7;
host echo "================DG 主备库缺失日志检查========================"
select ARCHIVED_THREAD#,status,gap_status,ERROR from gv\$archive_dest_status where
dest_id=2;
host echo "===============最近 4 次备份情况============================="
col status for a10
col input_type for a20
col INPUT_BYTES_DISPLAY for a10
col OUTPUT_BYTES_DISPLAY for a10
col TIME_TAKEN_DISPLAY for a10
select * from(
select input_type,
status,
of 3
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论