Oracle数据库日常管理手册_项目现场篇VIP免费

第1页共14页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页共14页Oracle数据库日常管理_项目现场篇修改：2010/2/8A.查看所有的实例及其后台进程是否正常确认所有的instance工作正常，登陆到所有的数据库或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:50ora_ckpt_UWNMS3B．检查文件系统的使用情况如果文件系统的剩余空间小于10％，则需要删除不必要的文件以释放空间。GDDB4-/export/home/oracle>df-hFilesystemsizeusedavailcapacityMountedon/dev/md/dsk/d020G17G3.1G85%/第2页共14页第1页共14页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第2页共14页/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:02alert_UWNMS1.log-rwxrwxrwx1oracledba1000Jul1422:00uwnms1_j000_18128.trc-rw-r-----1oracledba1000Jul2222:00uwnms1_j001_5369.trc-rwxrwxrwx1oracledba695Jul1419:12uwnms1_lgwr_18100.trc-rwxrwxrwx1oracledba2668Jul3022:02uwnms1_lgwr_19661.trc-rwxrwxrwx1oracledba983Jul1417:36uwnms1_lgwr_7816.trc-rwxrwxrwx1oracledba955Jul1419:11uwnms1_lgwr_7883.trc-rwxrwxrwx1oracledba803Jul1417:31uwnms1_p000_7714.trc-rwxrwxrwx1oracledba801Jul1417:31uwnms1_p001_7716.trc$cp/dev/nullalert_UWNMS1.log$rm*.trc$cd../cdump$ls-ltotal4drwxr-x---2oracledba512Jul2514:12core_18095drwxr-x---2oracledba512Jul2519:17core_25934$cd../udump$ls-ltotal20042-rw-r-----1oracledba505Jul1616:33uwnms1_ora_14771.trc第3页共14页第2页共14页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第3页共14页-rw-r-----1oracledba4516169Jul2514:12uwnms1_ora_18095.trc-rwxrwxrwx1oracledba644Jul1419:12uwnms1_ora_18119.trc-rw-r-----1oracledba505Jul3015:11uwnms1_ora_18820.trc-rwxrwxrwx1oracledba774Jul1510:23uwnms1_ora_19573.trc-rwxrwxrwx1oracledba587Jul1510:23uwnms1_ora_19645.trc-rwxrwxrwx1oracledba644Jul1510:23uwnms1_ora_19680.trc-rw-r-----1oracledba720942Jul1516:28uwnms1_ora_24759.trc-rw-r-----1oracledba4951562Jul2519:17uwnms1_ora_25934.trc-rw-r-----1oracledba505Jul1517:21uwnms1_ora_27326.trc-rw-r-----1oracledba503Jul3016:54uwnms1_ora_6612.trc-rwxrwxrwx1oracledba585Jul1417:12uwnms1_ora_7523.trc-rwxrwxrwx1oracledba767Jul1417:30uwnms1_ora_7566.trc2).可清除oracle的监听日志$cd$ORACLE_HOME/network/log$ls-ltotal533072-rwxrwxrwx1oracledba2725...