oracle数据库日常管理手册 项目现场篇资料.doc

oracle数据库日常管理手册_项目现场篇资料Oracle数据库日常管理_项目现场篇修改:2010/2/,登陆到所有的数据库或instance上,检测oracle后台进程GDDB4-/export/home/oracle>env|grepSIDORACLE_SID=UWNMS3GDDB4-/export/home/oracle>ps-ef|grepUWNMS3|grep-vgrep|greporaoracle2511910Jun24?0:04ora_dbw4_UWNMS3oracle2511010Jun24?3:20ora_dbw1_UWNMS3oracle2514610Jun24?0:00ora_reco_UWNMS3oracle2512510Jun24?0:09ora_dbw5_UWNMS3oracle2514210Jun24?5:41ora_smon_UWNMS3oracle2515510Jun24?1:17ora_mmon_UWNMS3oracle2515210Jun24?101:32ora_cjq0_UWNMS3oracle2510210Jun24?0:02ora_mman_UWNMS3oracle2510810Jun24?7:37ora_dbw0_UWNMS3oracle2547810Jun24?0:45ora_arc1_UWNMS3oracle2547010Jun24?0:47ora_arc0_UWNMS3oracle2515910Jun24?84:02ora_mmnl_UWNMS3oracle2509410Jun24?17:30ora_pmon_UWNMS3oracle2511710Jun24?0:41ora_dbw3_UWNMS3oracle2513110Jun24?13:12ora_lgwr_UWNMS3oracle201751018:27:25?0:00ora_j000_UWNMS3oracle2510010Jun24?1:10ora_psp0_UWNMS3oracle2511310Jun24?0:14ora_dbw2_UWNMS3oracle2513510Jun24?23:%,则需要删除不必要的文件以释放空间。GDDB4-/export/home/oracle>df-hFilesystemsizeusedavailcapacityMountedon/dev/md/dsk/%//proc0K0K0K0%/procmnttab0K0K0K0%/etc/mnttabfd0K0K0K0%/dev/fdswap85G192K85G1%/var/rundmpfs85G0K85G0%/dev/vx/dmpdmpfs85G0K85G0%/dev/vx/rdmpswap85G213M85G1%/tmp/dev/vx/dsk/data10dg/Ora_File_Vol01394G292G98G75%/data05/dev/vx/dsk/data1dg/vola0131443G156G283G36%/archivelog注意:需要特别关注根目录,数据库软件和数据库备份所在目录的剩余空间情况!备注:数据库运行日志的及时清除1).可清除bdump,cdump,udump下的相关日志$cdbdump$ls-ltotal174-rwxrwxrwx1oracledba59047Jul3022:-rwxrwxrwx1oracledba1000Jul1422:-rw-r-----1oracledba1000Jul2222:-rwxrwxrwx1oracledba695Jul1419:-rwxrwxrwx1oracledba2668Jul3022:-rwxrwxrwx1oracledba983Jul1417:-rwxrwxrwx1oracledba955Jul1419:-rwxrwxrwx1oracledba803Jul1417:-rwxrwxrwx1oracledba801Jul1417:$cp/dev/$rm*.trc$cd../cdump$ls-ltotal4drw