ADRCI基礎知識

leon830216發表於2014-03-18
支援資料庫版本：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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章