-
编辑 删除
OGG-03504
OGG 出錯，日志如下：2013-09-13 17:05:12 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repl_001.prm: REPLICAT REPL_001 started.2013-09-13 17:05:15&nbs...
-
编辑 删除
The Gains and Pains of Nologging Operations in DG (290161.1)
THE GAINS AND PAINS OF NOLOGGING OPERATIONSOverviewWhereas a logged INSERT operation has to generate redo for every change data or undo block, nologging operations indicate that the database operatio...
-
编辑 删除
How to Avoid Generation of Redolog Entries (Doc ID 188691.1)
***Checked for relevance on 25-Jul-2010***goal: How to Avoid Generation of Redolog Entriesfact: Oracle Server - Enterprise Edition 8.1fact: Oracle Server - Enterprise Edition 9.0.1fact: Oracle Se...
-
编辑 删除
Force Logging Feature in Oracle Database (Doc ID 174951.1)
PURPOSE-------The purpose of this document is to introduce to a feature of 9.2 which will log even the unrecoverable or nologging operations such as direct path sqlldr etc. SCOPE & APPLICATION--------...
-
编辑 删除
失去很好的機會
因為猶郁不決，失去一個機會，后面的一周，心情也一直受影響。 加油！機會時時有，必要的時候請牢牢抓住！ 得到時，總有失去！失去時，一定也有得到！ 淡定！ ...
-
编辑 删除
delete archive log on standby db using ASM
當使用ASM管理數據庫的文件時，如果想要刪除archive log 文件有兩種方法： （一）通過RMAN。 rman target/ &n...
-
编辑 删除
Change Default Archive Log Destination While Doing Recovery From SQLPLUS
（1）當你在做恢愎或是應用archivelog 日志時，出現archivelog目錄不是提示的目錄時，狀況如下：SQL> recover standby database;ORA-00279: ???? 12509357275011 ??? 06/21/2013 08:10:42 ? (???? 1 ??)ORA-00289: ...
-
编辑 删除
成长的寓言：做一棵永远成长的苹果树
一棵苹果树，终于结果了。 第一年，它结了10个苹果，9个被拿走，自己得到1个。对此，苹果树愤愤不平，于是自断经脉，拒绝成长。第二年，它结了5个苹果，4个被拿走，自己得到1个。"哈哈，去...
-
编辑 删除
DBMS_STATS: GATHER_STATS_JOB encountered errors
一、在alert.log文件中發現如下錯誤 ：*** 2013-06-01 10:00:13.500DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"ALERT_HUMAN2"','""', ...)DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-2...
-
编辑 删除
oracle用戶分類及作用匯總
一、oracle 用戶分三類： （1） predefined administrative accounts  ...
-
编辑 删除
alert文件中出現：Auto-tuning: Shutting down background process GTXd
（一）早上查看一套4節點的RAC服務器時發現 alert 日志中有如下顯示內容。 Thu Jun 13 06:20:31 2013Auto-tuning: Shutting down background process GTXd...
-
编辑 删除
Auto-tuning: Shutting Down Background Process GTX [ID 1481153.1]
In this DocumentSymptomsChangesCauseSolutionApplies to: Oracle Server - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Information in this document applies t...
-
编辑 删除
How to Modify Private Network Information in RAC [ID 283684.1]
In this DocumentGoalSolution Case I. Changing private hostname Case II. Changing private IP only without changing network interface, subnet and netmask Case II...
-
编辑 删除
RAC上變更VIP地址
--################################################以下正解：------------------------------------------------第一部分：測試條件A、IP地址192.168.1.52 node1192.168.1.53 &n...
-
编辑 删除
How to Rename or Move Datafiles and Logfiles [ID 115424.1]
Applies to: Oracle Server - Enterprise Edition - Version 8.0.3.0 and laterInformation in this document applies to any platform."Checked for relevance on "15-Jan-2010" PurposeIn many situations, a ...
-
编辑 删除
oracle goldengate 學習（相關的網址記錄）
最近應客戶的要求，需要做oracle golden gate 進行DB的同步及抄寫。以下記錄一下oracle goldengate 學習相關的網址： 官方： oracle golden gate 軟件下載地址： http://www.orac...
-
编辑 删除
使用RMAN restore archive log
一、 在主庫上使用RMAN備份archivelog . vi /backup/rman_dest/scripts/backup_db_arch.sh ## 文件內容source /u/oracle/.bash_profile##script. start #####!/bin/...
-
编辑 删除
ASM Concepts Quick Overview [ID 1086199.1]
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document applies to any platform.PurposeThis note provides a quick overview...
-
编辑 删除
Master Note for Automatic Storage Management (ASM) [ID 1187723.1]
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document applies to any platform.DetailsThis Master Note is intended to pro...
-
编辑 删除
How to Prepare Storage for ASM [ID 452924.1]
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]Information in this document applies to any platform.Oracle Server Enterprise Edition - Version: ...
