摘要:
###sample 1 原因是新库起了FRA 区,FRA 区的旧文件属于之前的归档日志文件产生,这样会导致无法识别的问题。 解决办法,清空FRA或者恢复时候不启用FRA. RMAN RESTORE FAILS WITH RMAN-06023 ALTHOUGH BACKUPS ARE AVAILABL 阅读全文
摘要:
########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 阅读全文
摘要:
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 阅读全文
摘要:
###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 阅读全文
摘要:
序号 问题 解决方案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 阅读全文
摘要:
##sample 0 不完全恢复之后,open resetlogs之前,怎么快速的检查数据库是否处于一致性的状态?https://blog.csdn.net/msdnchina/article/details/55515313 How to quickly check that Database i 阅读全文
摘要:
##发现nomon 一个好用的功能 数据透视图 PIVOTCHART:这些参数被用来构建数据透视图。所需的参数:Sheetname,PageField,rowfield,columnfield,DataField和xlfunction(总和,最小,平均,最大值)。数据来源TOP(可以查看指定进程一天 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文