ITPub博客

首页 > 数据库 > Oracle > ADRCI基础知识

ADRCI基础知识

原创 Oracle 作者:leon830216 时间:2014-03-18 17:21:46 0 删除 编辑
支持数据库版本:11gR2

1. 帮助
$ adrci -help
adrci> help
adrci> help ips
adrci> help ips add

2. 基本命令
adrci> show base
adrci> show home

adrci> set home diag/rdbms/orcl/ORCL
adrci> show alert -tail 5
adrci> show incident
adrci>show incident -mode detail -p "incident_id=166011"
adrci> show problem
adrci> show problem -p "problem_key like '%600%'"

3. 打包
adrci> ips pack problem 1

adrci> ips create package
adrci> ips create package problemkey "ORA 7445 [koioapm()+254]"
adrci> ips add incident 172231 package 3
adrci> ips add file /trace/ora11g_ora_4582.trc package 3
adrci> ips generate package 3
adrci> ips add new incidents package 3
adrci> ips add problem 12 package 3
adrci> ips generate package 3


4. 解包
adrci> ips get metadata from file /home/oracle/IPSPKG_20090215012523_COM_1.zip
adrci> ips unpack file /home/oracle/IPSPKG_20090215012523_COM_1.zip into /home/oracle
adrci> host
$ ls -l


5. 直接在命令行执行
$ adrci exec="show base;show home;set home diag/rdbms/orcl/ORCL;show home;"

6. 修改ADR的perge policy

oracle与grid的ADR设定需要分别使用各自用户(oracle、grid

$ adrci

adrci> show homes
adrci> set homepath diag/oracle/orcl
adrci> show control
adrci> set control (shortp_policy=180)
adrci> show control
adrci> exit

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22558114/viewspace-1124337/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-09-18

  • 博文量
    164
  • 访问量
    320298