Oracle数据库日常管理手册_项目现场篇.docx

《Oracle数据库日常管理手册_项目现场篇.docx》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle数据库日常管理_项目现场篇修改：2010/2/8A.查看所有的实例及其后台进程是否正常确认所有的instance工作正常，登陆到所有的数据库或instance上，检测oracle后台进程GDDB4-/export/home/oracle>env

2、grepSIDORACLE_SID=UWNMS3GDDB4-/export/home/oracle>ps-ef

3、grepUWNMS3

4、grep-vgrep

5、greporaoracle2511910Jun240:04ora_dbw4_UWNMS3oracle2511010Jun243:2

6、0ora_dbw1_UWNMS3oracle2514610Jun240:00ora_reco_UWNMS3oracle2512510Jun240:09ora_dbw5_UWNMS3oracle2514210Jun245:41ora_smon_UWNMS3oracle2515510Jun241:17ora_mmon_UWNMS3oracle2515210Jun24101:32ora_cjq0_UWNMS3oracle2510210Jun240:02ora_mman_UWNMS3oracle2510810Jun247:37ora_dbw0_U

7、WNMS3oracle2547810Jun240:45ora_arc1_UWNMS3oracle2547010Jun240:47ora_arc0_UWNMS3oracle2515910Jun2484:02ora_mmnl_UWNMS3oracle2509410Jun2417:30ora_pmon_UWNMS3oracle2511710Jun240:41ora_dbw3_UWNMS3oracle2513110Jun2413:12ora_lgwr_UWNMS3oracle201751018:27:250:00ora_j000_UWNMS3or

8、acle2510010Jun241:10ora_psp0_UWNMS3oracle2511310Jun240:14ora_dbw2_UWNMS3oracle2513510Jun2423:50ora_ckpt_UWNMS3B．检查文件系统的使用情况如果文件系统的剩余空间小于10％，则需要删除不必要的文件以释放空间GDDB4-/export/home/oracle>df-hFilesystemsizeusedavailcapacityMountedon/dev/md/dsk/d020G17G3.1G85%//proc0K0K0K0%/proc

9、mnttab0K0K0K0%/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注意：需要特别关注根目录，数据库软件和数据库备

10、份所在目录的剩余空间情况!备注：数据库运行日志的及时清除1).可清除bdump,cdump,udump下的相关日志$cdbdump$ls-ltotal174-rwxrwxrwx1oracledba59047Jul3022:02alert_UWNMS1」og-rwxrwxrwx1oracledba1000Jul1422:00uwnms1」000_18128.trc-rw-r——1oracledba1000Jul2222:00uwnms1」001_5369.trc-rwxrwxrwx1oracledba695Jul1419:12uwnms1」

11、gwr_18100.trc-rwxrwxrwx1oracledba2668Jul3022:02uwnms1」gwr_19661.trc-rwxrwxrwx1oracledba983Jul1417:36uwnms1」gwr_7816.trc-rwxrwxrwx1oracledba955Jul1419:11uwnms1」gwr_7883.trc-rwxrwxrwx1oracledba803Jul1417:31uwnms1_p000_7714.trc-rwxrwxrwx1oracledba801Jul1417:31uwnms1_p001_771

12、6.trc$cp/dev/nullalert_UWNMS1.log$rm*.trc$cd../cdump$ls-ltotal4drwxr-x---2oracledba512Jul2514:12