slave have equal MySQL Server UUIDs原因及解決最近在部署MySQL主從複製架構的時候,碰到了"Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work."
Oracle 11.2.0.4 單一實例的 db instance 啟動的alertOracle 11.2.0.4 單一實例的 db instance 啟動的alertFri Jan 09 03:11:17 2015DIAG started with pid=19, OS id=6031 Dumping diagnostic data in directory=[cdmp_20150109031118], requested by (instance=1, osid=2456 (CJQ0)),
AIX上斷開的NFS 掛載點 導致 Oracle instance hang 住AIX上斷開的NFS 掛載點 導致 Oracle instance hang 住翻譯自mos文章:Disconnected NFS Mount Point Causes Instance to Hang on AIX (文檔 ID 1445600.1)適用於:Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later
解釋 datafile name中的MISSING關鍵字來源於:Explanation of MISSING keyword in datafile name (文檔 ID 1050268.1)適用於:Oracle Server - Enterprise Edition - Version 7.3.4.0 to 11.2.0.1.0 [Release 7.3.4 to 11.2]Information in this document applies to any
Oracle升級到11.2.0.4之後在alert日誌中出現 NUMA 警告資訊註:與本文有關的文章為:升級到11.2.0.4之後在alert日誌中出現 NUMA 警告資訊翻譯自mos文章:NUMA warning message appear after upgrade to 11.2.0.4 (文檔 ID 1600824.1)1適用於:Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation
在Oracle資料庫中一個datafile 可以被drop的條件參考mos文章:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (文檔 ID 1050261.1)違反下列任何一個條件,該datafile均不能被drop1)必須為空白,否則會報:ORA-03262: the file is
從tablespace中 刪除空的datafile時報ORA-03262參考自:Cannot Drop Empty Datafile From Tablespace ORA-03262 (文檔 ID 1353029.1)適用於:Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later [Release: 11.2 and later ]Information in this document applies
怎麼purge 已經被drop 的對象怎麼purge 已經被drop 的對象以被drop對象所在的user去登陸sqlplus然後show recyclebin;F:\Oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 19 09:04:17 2015Copyright (c) 1982, 2007, Oracle. All
SQL Server 遠程備份資料庫經常會有定時備份SQL Server資料庫的需要。定時備份到原生話,還是挺容易的,計劃任務就可以完成,但如果是整機掛了,那備份到本機是沒意義的,那麼就需要來考慮備份到區域網路中,其它電腦裡。下面就分享一份在網上找了之後,自己再簡單整理過的代碼,配合 SQL Server Agent中的作業功能,已經穩定運行一個星期了,每小時就備份一次。--