feiyun8616的作坊 (半个程序员and dba) 脚本化 python

摘要： 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 阅读全文

摘要： ora-279 是可以忽略的报错 In general, a restore should take approximately the same time as a backup, if not longer. Therefore, if your backup took 10 hours to 阅读全文

摘要： 简介： 在Oracle 11.2.0.2之前，私网的冗余一般是通过在OS上做网卡绑定（如Bond等）来实现的，从Oracle 11.2.0.2版本开始推出HAIP（Highly Available Virtual IP）技术替代了操作系统层面的网卡绑定技术，功能更强大、更兼容。HAIP通过其提供的独 阅读全文