$ cd /home/oracle/delete $ mkdir -p audit_file_dest background_dump_dest user_dump_dest core_dump_dest listenr_log_dest
$ sqlplus / as sysdba SQL> show parameter dest
$ cd audit_file_dest $ pwd
$ find audit_file_dest -mtime +30 -name \*.aud
$ find audit_file_dest -mtime +30 -name \*.aud -exec mv {} /home/oracle/delete/audit_file_dest \;
$ find audit_file_dest -mtime +30 -name \*.aud $ ls /home/oracle/delete/audit_file_dest
$ cd /home/oracle/delete $ rm -rf audit_file_dest
$ cd background_dump_dest $ pwd
$ find background_dump_dest -mtime +30 -name \*.tr*
$ find background_dump_dest -mtime +30 -name \*.tr* -exec mv {} /home/oracle/delete/background_dump_dest \;
$ find background_dump_dest -mtime +30 -name \*.aud $ ls /home/oracle/delete/background_dump_dest
$ cd /home/oracle/delete $ rm -rf background_dump_dest
$ cd background_dump_dest
cp alert_$ORACLE_SID.log alert_$ORACLE_SID.log.bak (确保空间足够)
SQL> alter system switch logfile;
SQL> show parameter dump SQL> exit $ cd /u01/app/oracle/diag/rdbms/db11g/db11g/trace $ ls -lrt
$ su oracle $ lsnrctl set log_status off $ mv listener.log listener.log.bak (备份一下监听文件 ) $ lsnrctl set log_status on (这时候会自动创建一个listener.log文件)
find . -mtime +10 -exec mv {} /home/oracle/delete/listenr_log_dest \;
$adrci
show alert
adrci> show alert
Choose the alert log from the following homes to view: 1: diag/rdbms/db1/db1 2: diag/tnslsnr/oracle/listener Q: to quit Please select option: 1
SHOW TRACEFILE
$ adrci ADRCI: Release 11.2.0.4.0 - Production on Fri Jun 2 18:31:34 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show home ADR Homes: diag/tnslsnr/db/listener diag/rdbms/cams/cams adrci> set homepath diag/rdbms/cams/cams adrci> help purge Usage: PURGE [[-i <id1> | <id1> <id2>] | [-age <mins> [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]]]: Purpose: Purge the diagnostic data in the current ADR home. If no option is specified, the default purging policy will be used. Options: [-i id1 | id1 id2]: Users can input a single incident ID, or a range of incidents to purge. [-age <mins>]: Users can specify the purging policy either to all the diagnostic data or the specified type. The data older than <mins> ago will be purged [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]: Users can specify what type of data to be purged. Examples: purge purge -i 123 456 purge -age 60 -type incident
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有