Month: May 2013

script:purge ADR file

by

[oracle@db231 ~]$ ./adr_purge
INFO: Purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purging diagnostic destination diag/tnslsnr/db231/listener
INFO: purging ALERT older than 90 days …
INFO: purging INCIDENT older than 30 days …

Tuning “Backup:sbtbackup” Event

by

A few days ago a friend ask me to see a awr issue. In the TOP 5 Times Events, as you see, Obviously,database has relatively high sbtbackup wait event, Backup:sbtbackup falls under the administrative category also realted to the RMAN. These wait events will occur when there is RMAN backup running on the server. Backup: … Read more

一次expdp/impdp迁移案例

by

因一次硬件原因导致了服务器异常停机，防止蝴蝶效应及时进行了数据迁移，一周发现了这个决定正确的。 申请了2小时的停机时间。因数据不大且表空间开始使用不规范决定用expdp数据泵方式迁移。 在新设备 1, raid10+安装OS 2，安装oracle 10.2.0.1(single instance)+ 3，升级oracle 10.2.0.5 4，建库, 5, 调整INSTANCE参数,调整temp tbs、redo file size、undo tbs大小 6，创建app schema、创建data\index tablespace 用时1小时左右 stop web app+挂通知 stop listener sys@TOPBOX>select object_type,count(*) cnt from dba_objects where owner=’TOPBOX’ GROUP BY OBJECT_TYPE; OBJECT_TYPE CNT ——————- ——————– SEQUENCE 802 PROCEDURE 25 DATABASE LINK 2 LOB 3 TRIGGER 3 MATERIALIZED VIEW 2 TABLE … Read more