kill job
job
oracle角色与权限
DBA_ROLE_PRIVS,DBA_SYS_PRIVS,DBA_TAB_PRIVS,ROLE_SYS_PRIVS
Oracle AWR报告指标全解析
【性能调优】Oracle AWR报告指标全解析2013/08/31 BY MACLEAN LIU 26条评论【性能调优】Oracle AWR报告指标全解析开Oracle调优鹰眼,深入理解AWR性能报告:http://www.askmaclean.com/archives/awr-hawk-eyes-training.html开Oracle调优鹰眼,深入理解AWR性能报...
data guard搭建
data guard
rman 管理备份报告和检查删除
list,report,delete
RAMN复制数据库
rman复制数据库
丢失current日志文件
SYS@rhel6> select group#,status from v$log; GROUP# STATUS---------- ----------------1 INACTIVE2 CURRENT3 INACTIVESYS@rhel6> !ls /u01/app/oracle/oradata/rhel6/redo*/u01/app/oracle/oradata/rhel6/redo01.log/u01/app/oracle/oradata/rhel6/redo02.log/u01/app/oracle/oradata/rhel6...
恢复重做日志incative
删除incatIve日志组进行恢复
集合运算符
union,union all,intersect,minus
重建控制文件
重建控制文件,以及错误解决
手工建库
手工建库,参数文件spfile,pfile