-
编辑 删除
实战存储过程调度过程
实行功能 1.可以按流程执行存储 2.如果中间某一个过程执行错误会立即退出流程 3.在次执行时候会从错误过程里面继续往下跑 4.会把调度job信息dispatch_tablecreate or replace procedure dispatch_prod...
-
编辑 删除
异常处理过程
有问题过程会比执行三次还是不行就会停止执行create or replace procedure exception_procedure iscursor log_data is select m.pro_name from T_DATA_UPDATE_LOG m where m.status=0 and m.info='异常' and to_char(m.begin_date,'yyyymmdd')=to_char(sysdate,'yyyymmdd') group by m.pro_name;v_sql ...
-
编辑 删除
分区管理过程
一次性添加一年分区保留当前表20天数据，20天后数据事实被交换到历史表保留分区表2个月数据create or replace procedure manage_partition ispartition_name_add varchar2(2000);partition_name_reduce_5 varchar2(200);current_time &...
-
编辑 删除
ORA-19606: Cannot copy or restore to snapshot control file
ORA-19606: Cannot copy or restore to snapshot control file1. Set new name (or location) for RMAN to use for snapshot controlfile:CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.ORA';2. Remove the snapshot controlfile from the RMAN informatio...
-
编辑 删除
Linux发邮件磁盘空间监控
Linux发邮件磁盘空间监控#!/usr/bin/python# -*- coding: UTF-8 -*-import smtplibimport osimport commands,time from email.mime.text import MIMEText#from email import MIMETextdisk_free=os.popen('df -lh')list_disk=disk_free.read()mailto_list=["2880329185@qq.com","2881280685@qq.com","28800...
-
编辑 删除
LINUX 自动备份程序日志(shell)
定期备份脚本案列用tar压缩7天前日志删除7天压缩完日志删除压缩完356天前日志#！/bin/bash#delete expire log#script name drop_log#script default remove 7 day log and remove remove archived a year ago#make date 2015/06/15result_client=`find /orafile/app/smsclient/runlogs/ -mtime +7 -name "*log....
