1.增加ADR工具,目录结构show parameter diagnostic_dest;
查看视图,select name,value from v$diag_info;
工具adrci
adrci>help
支持命令行:adrci exec="show homes;show incident"
查看某个错误:
show alert -P "MESSAGE TEXT LIKE '%ORA-600‘*
可以使用spool命令保存
意外事件打包
1. ips create package
2. ips add incident 113769 package 1;
3. ips generate package 1 in /u01/app/oracle/adrci/support
2.新增vaildate 检测数据库功能
rman> validate database;每个文件划分成几部分,允许进行并行检查
rman> list failure;
rman> list failure open; 保持故障打开
rman> failure closed;
rman> change failure 3 priority low; 改变低优先级
查看建议修复视图:
select * from v$ir_manual_checklist;
rman> repair failure; 修复故障
rman> repair failure preview; 只查看不修复
11g 新特性Data Recovery Advisor
案例数据文件丢失:
sql>startup
ora-01157: cannot identifiy/lock data file 4 - see dbw trace file
步骤:
rman> list failure;
4 high open 29-mar-07
rman> list failure 4 detail
rman> advise failure;
rman> repair failure previes;
rman> repair failure;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25223017/viewspace-702661/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25223017/viewspace-702661/