ADRCI基础知识

支持数据库版本：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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22558114/viewspace-1124337/