发表于:2008.01.05 15:33
分类: oracle管理
出处：http://zhouwf0726.itpub.net/post/9689/449694
---------------------------------------------------------------
由于oracle10R1的stream复制的bug---leak of memory，在升级到10R2以前临时写个job，重新启动由于memory leak停止的stream。
http://www.itpub.net/853849.html
保留足够的归档日志
15,45 * * * * . /.../admin/bin/.oraenvamzn; oraenvamzn fc1cn; /.../manage-oracle-archive-logs --oracle-sid=xxxxxx --alarm-threshold=80 --delete-threshold=60 --hours-behind=5>/.../output/manage-oracle-archive-logs-`/bin/date +%Y%m%d-%H%M%S`.log 2>&1
创建存储过程
create or replace procedure p_restart_stream is
p_count number(8,0);
begin
select count(1) into p_count from v$streams_capture;
if p_count = 0 then
dbms_capture_adm.start_capture('STRM_CAPTURE');
insert into restart_stream_log values(sysdate);
commit;
end if;
end p_restart_stream;
/
创建job
variable jobno number;
begin
dbms_job.submit(:jobno, 'p_restart_stream;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE);
commit;
end;
/
print jobno;