oracle数据库日常检查

《oracle数据库日常检查》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle数据库日常检查A.查看所有的实例及其后台进程是否正常确认所有的instance工作正常，登陆到所有的数据库或instance上，检测oracle后台进程$env

2、grepSIDORACLE_SID=UWNMS3B．检查文件系统的使用情况如果文件系统的剩余空间小于10％，则需要删除不必要的文件以释放空间。$df-hFilesystemsizeusedavailcapacityMountedon/dev/md/dsk/d020G17G3.1G85%//proc0K0K0K0%/procmnttab0K0K0K0%/etc

3、/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%/archivelogAIX:$df–gordf–kHP-UX$bdfordf–kordf-h

4、注意：需要特别关注根目录，数据库软件和数据库备份所在目录的剩余空间情况！备注：数据库运行日志的及时清除1).可清除bdump,cdump,udump下的相关日志$cd$ORACLE_BASE/admin/db_name/bdump$ls-ltotal174-rwxrwxrwx1oracledba59047Jul3022:02alert_UWNMS1.log-rwxrwxrwx1oracledba1000Jul1422:00uwnms1_j000_18128.trc-rw-r-----1oracledba1000Jul2222:0

5、0uwnms1_j001_5369.trc-rwxrwxrwx1oracledba695Jul1419:12uwnms1_lgwr_18100.trc-rwxrwxrwx1oracledba2668Jul3022:02uwnms1_lgwr_19661.trc-rwxrwxrwx1oracledba983Jul1417:36uwnms1_lgwr_7816.trc-rwxrwxrwx1oracledba955Jul1419:11uwnms1_lgwr_7883.trc-rwxrwxrwx1oracledba803Jul1417:

6、31uwnms1_p000_7714.trc-rwxrwxrwx1oracledba801Jul1417:31uwnms1_p001_7716.trc$cd../cdump$ls-ltotal4drwxr-x---2oracledba512Jul2514:12core_18095drwxr-x---2oracledba512Jul2519:17core_25934$cd../udump$ls-ltotal20042-rw-r-----1oracledba505Jul1616:33uwnms1_ora_14771.trc-rw-r

7、-----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-rw

8、xrwxrwx1oracledba644Jul1510: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.tr

9、c-rwxrwxrwx1oracledba585Jul1417:12uwnms1_ora_7523.trc-rwxrwxrwx1oracledba767Jul1417:30uwnms1_ora_7566.trc2).可清除oracle的监听日志$cd$ORACL