oracle adrci日志打包

[oracle@rhel63single ~]$ adrci

adrci> show problem

ADR Home = /u01/app/oracle/diag/tnslsnr/rhel63single/listener:


0 rows fetched

ADR Home = /u01/app/oracle/diag/rdbms/test/test:


PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME


1 ORA 1578 16961 2014-06-07 20:35:35.310000 +08:00
2 ORA 4031 32428 2014-09-25 01:00:37.647000 +08:00
3 ORA 600 [qmrcGetRepRC] 32441 2014-09-25 02:20:00.781000 +08:00
4 ORA 445 45655 2015-01-09 01:51:31.549000 +08:00

adrci> show incident

ADR Home = /u01/app/oracle/diag/tnslsnr/rhel63single/listener:


0 rows fetched

ADR Home = /u01/app/oracle/diag/rdbms/test/test:


INCIDENT_ID PROBLEM_KEY CREATE_TIME


16961 ORA 1578 2014-06-07 20:35:35.310000 +08:00
31354 ORA 4031 2014-09-25 00:31:36.018000 +08:00

adrci> show homes
ADR Homes:
diag/tnslsnr/rhel63single/listener
diag/rdbms/test/test
adrci> set homepath diag/rdbms/test/test
adrci> ips create package incident 16961

Created package 1 based on incident id 16961, correlation level typical

adrci> help ips
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME ORA4031_20150502223521----->这是os时间
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 2
DRIVING_PROBLEM_KEY ORA 4031
DRIVING_INCIDENT 31358
DRIVING_INCIDENT_TIME 2014-09-25 00:40:07.251000 +08:00
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 2 correlated problems
INCIDENTS 1 main incidents, 5 correlated incidents
INCLUDED_FILES 14

至此,只能算是打包了一个incident,还没有生成文件在OS上,生成的步骤:
[oracle@rhel63single test]$ adrci

adrci> show homes
ADR Homes:
diag/rdbms/test/test
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME ORA4031_20150502223521
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 2
DRIVING_PROBLEM_KEY ORA 4031
DRIVING_INCIDENT 31358
DRIVING_INCIDENT_TIME 2014-09-25 00:40:07.251000 +08:00
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 2 correlated problems
INCIDENTS 1 main incidents, 5 correlated incidents
INCLUDED_FILES 14

adrci> ips create package incident 31358 correlate all
Created package 2 based on incident id 31358, correlation level all
adrci>
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME ORA4031_20150502223521
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 2
DRIVING_PROBLEM_KEY ORA 4031
DRIVING_INCIDENT 31358

PACKAGE_ID 2
PACKAGE_NAME ORA4031_20150502225909
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 2
DRIVING_PROBLEM_KEY ORA 4031
DRIVING_INCIDENT 31358

adrci> ips GENERATE PACKAGE 2 in /home/oracle/ ---指定位置
Generated package 2 in file /home/oracle/ORA4031_20150502225909_COM_1.zip, mode complete--->生成到指定的位置

转载于:https://blog.51cto.com/2012ivan/2097284

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值