上一页 1 ··· 18 19 20 21 22 23 24 25 26 ··· 80 下一页
摘要: ###sample 1 原因是新库起了FRA 区,FRA 区的旧文件属于之前的归档日志文件产生,这样会导致无法识别的问题。 解决办法,清空FRA或者恢复时候不启用FRA. RMAN RESTORE FAILS WITH RMAN-06023 ALTHOUGH BACKUPS ARE AVAILABL 阅读全文
posted @ 2019-04-23 14:57 feiyun8616 阅读(1278) 评论(0) 推荐(0) 编辑
摘要: ########SAMPLE 0 Invalid X_$ Views & Synonyms After Upgrading to 11g (文档 ID 878623.1) Those views and synonyms should be dropped in 11g as they do not 阅读全文
posted @ 2019-04-21 16:26 feiyun8616 阅读(181) 评论(0) 推荐(0) 编辑
摘要: PURPOSE The purpose of this document is to give a quick guide for using RMAN on RAC databases. We will follow this points: 1. Verify the database mode 阅读全文
posted @ 2019-04-20 12:23 feiyun8616 阅读(554) 评论(0) 推荐(0) 编辑
摘要: ###sample 1 "node 1 (10.198.127.5): ps -ef|grep ora.crsd root 45613166 47185944 0 10:24:35 pts/2 0:00 grep ora.crsd node 2 (10.198.127.6): [admin@pdbd 阅读全文
posted @ 2019-04-18 10:36 feiyun8616 阅读(1115) 评论(0) 推荐(0) 编辑
摘要: 序号 问题 解决方案1 "2019-04-13 20:23:55 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, e_db1.prm: The number of Oracle redo threads (2) is not the sam 阅读全文
posted @ 2019-04-16 11:52 feiyun8616 阅读(2501) 评论(0) 推荐(0) 编辑
摘要: ##sample 0 不完全恢复之后,open resetlogs之前,怎么快速的检查数据库是否处于一致性的状态?https://blog.csdn.net/msdnchina/article/details/55515313 How to quickly check that Database i 阅读全文
posted @ 2019-04-13 10:08 feiyun8616 阅读(1482) 评论(0) 推荐(0) 编辑
摘要: ##发现nomon 一个好用的功能 数据透视图 PIVOTCHART:这些参数被用来构建数据透视图。所需的参数:Sheetname,PageField,rowfield,columnfield,DataField和xlfunction(总和,最小,平均,最大值)。数据来源TOP(可以查看指定进程一天 阅读全文
posted @ 2019-04-04 14:33 feiyun8616 阅读(1266) 评论(0) 推荐(0) 编辑
摘要: hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (文档 ID 136697.1) Script to Collect DB Upgr 阅读全文
posted @ 2019-04-02 23:08 feiyun8616 阅读(469) 评论(0) 推荐(0) 编辑
摘要: There is no procedure within the dbms_job package to stop a running job.You will need to determine which Oracle session and process is associated with 阅读全文
posted @ 2019-04-01 17:16 feiyun8616 阅读(658) 评论(0) 推荐(0) 编辑
摘要: APPLIES TO: PL/SQL - Version 9.2.0.8 and laterInformation in this document applies to any platform.*** Checked for relevance on 26th Dec 2018 *** SYMP 阅读全文
posted @ 2019-03-30 15:25 feiyun8616 阅读(706) 评论(0) 推荐(0) 编辑
上一页 1 ··· 18 19 20 21 22 23 24 25 26 ··· 80 下一页