oradbm的博客

登录数据库主机.创建函数isbeginend;

1对监听日志的外部表信息。---告警日志外部表。---告警日志外部表。

1. 按oracleSID来查询连接数据库的客户端IPnetstat -anpT | grep oracleSID | awk '{print $5}' | grep -o -E '1.*:' | awk -F ':' '{print $1}' | sort2. 按监听端口1521来查询连接数据库的客户端IPnetstat -anpT | grep 1521 | awk '{prin...

1 活动会话历史趋向select to_char(sample_time,'yyyy-mm-dd hh24:mi:ss'),count(1)from dba_hist_active_sess_historywhere sample_time>sysdate-2/24and sample_time<sysdate-1/24group by to_char(samp...

[grid@gac01 ~]$ more errloging.sqlCREATE OR REPLACE TRIGGER logon_denied_to_alert AFTER servererror ON DATABASEDECLARE message VARCHAR2(168); ip VARCHAR2(15); v_os_user VARCHAR2(80)...

编写shell脚本脚本1-bash-3.00$ more ogg.shPATH=/prod/oracle/product/10.2.0/db_1/bin:/usr/bin:/etc:/opt/EMCpower/bin/64:/etc/emc/bin:/prod/oracle/product/10.2.0/db_1/bin:/ogg/ggs;export PATH;cd /ogg/gg...

1rman转化脚本RMAN> CONVERT DATAFILE2>'C:\Temp\sales_101.dbf',3>'C:\Temp\sales_201.dbf'4>TO PLATFORM="Microsoft Windows IA (32-bit)"5>FROM PLATFORM="Solaris[tm] OE (32-bit)"6&gt...

DBA常用 Oracle数据库巡检脚本本文链接：https://blog.youkuaiyun.com/zfr629/article/details/87938013目录1. 检查数据库基本状况1.1. 检查Oracle实例状态1.2. 检查Oracle在线日志状态1.3. 检查Oracle表空间的状态1.4. 检查Oracle所有数据文件状态1.5. 检查无效对象1.6....

0 1 * * * /u01/rman/rman.sh#!/bin/bash. /etc/profile. /home/oracle/.bash_profilewk=`date +%w`level=1case $wk in[1-6]) level=1;;0) level=0;;esac;level=0echo the current week is $wk ,y...

###################################crontab.cr######################################crontab -e0 5,16 * * * ksh /orcl/oracle/oraclecheck/checkdb.sh###################################checkdb.sh########...