ITPub博客

ORA-01187: 無法自檔案 201 讀取資料, 因為檔案未通過驗證測試ORA-01110: 資料檔 201:'/data/dmsdb/temp01.dbf'  select  * fromdba_temp_filesORA-01187: 無法自檔案 201 讀取資料, 因為檔案未通過驗證測試ORA-01110: 資料檔 201:'/data/dmsdb/temp01.dbf'  ...

Database : force logging所有操作都有redolog Tablespace force loggingTablesapce所屬table操作都有redo log Tablespace loggingtablespace下對象的建立默認為：loggingTable設置nologging/logging覆蓋tablespace級別的設置Table設置nologging 則為nologgingTable...

CREATE OR REPLACE function SMES_C.long_2_varchar (p_table_owner    in DBA_TAB_PARTITIONS.table_owner%type,p_table_name     in DBA_TAB_PARTITIONS.table_name%type,p_partition_name in DBA_TAB_PARTITIONS.partition_name%type) return varchar2asl_high_value LONG;begin&...

DBCA fails in the middle of database creation withORA-13516 / ORA-06512 (文档 ID 1929718.1)        In this Document    Symptoms    Cause    SolutionApplies to:Oracle Database - StandardEdition - Version 11.2.0.2 t...

OS開啟后其他集群件自動開啟但DB依然是關閉的：ora.gc.db      1       OFFLINE OFFLINE                        &nb...

Oracle 反向索引 where index_column like '%xxx' create table objectsas select * from dba_objects;createindexobj_idx on objects(OBJECT_NAME)reverse;createindexobj_idx_reverse on objects(reverse(OBJECT_NAME));reverse index使用：select* from objectswherereverse(object_name)LIKEreverse('%OL$')或select* fro...

點檢DB看到web程式引發 ORA-00600[rwoirw:check ret val]Mon Mar 02 09:32:062015     ORA-00600: 内部错误代码, 参数: [rwoirw: check ret val]問題SQL：SELECTSUM(MD01)MD01,SUM(MD02)MD02,SUM(MD03)MD03,SUM(MD04)MD04,SUM(MD05)MD05,SUM(MD06)MD06,SUM(MD07)MD07,SUM(MD08A)MD08A...

ID 399395.1)转到底部In this DocumentSymptomsSolutionApp...

Compressed TablespacesYou can specifythat all tables created in a tablespace are compressed by default. You specifythe type of table compression using the DEFAULT keyword, followed by one of thecompression type clauses used when creating a table.The following statementindicates that al...

Index KeyCompressionOracle Database can use key compression to compressportions of the primary key column values in a B-treeindex or an index-organized table. Key compression can greatly reduce the spaceconsumed by the index.In general, index keys have two pieces, a groupingpiece and ...

CTSS(ClusterTime Synchronization Server Daemon)GRID 自己提供的時間同步服務如果所有節點上已經部署NTP服務，CTSS以Observer mode 運行，這種模式下CTSS只會在集群alert.log中記錄時間不一致信息，但不會去調整如不是所有幾點上部署NTP，CTSS以Active mode運行，并和主節點同步。分為兩種方式：1> 當節點加...

CRSD(Cluster ready service daemon)管理上層高級別(應用層)資源OCROHASD(Oracle high availability daemon)管理低級別資源啟動需要OLR(oracle local registry) 和GPnP profile由/etc/init.d/ohasd腳本啟動 ，/etc/inittab 調用 GPnP(grid plug and play)XML文件保存在每個節...

在互联网高速发展的今天，不同种类的网站大量涌现，每个人都在享受着网络服务所带来的便利。而创建自己个性化的网站的门槛不断降低，从事网站架设，这种当年的绝对“高科技”技术活，也从IT人的专利“沦落”到人人皆可的境地：随便安装一个windows的server版，使用自带的IIS就可以迅速创建一个说的过去的网站。 然而要架...

optimize、Analyze、check、repair维护操作optimize 数据在插入，更新，删除的时候难免一些数据迁移，分页，之后就出现一些碎片，久而久之碎片积累起来影响性能，这就需要DBA定期的优化数据库减少碎片，这就通过optimize命令。optimize table 表名。碎片可根据show table status 查看，实际数据data_length 与空洞碎片数据da

课程

http://www.eygle.com/archives/2009/11/awk_ass109.htmlhttp://space.itpub.net/38267/viewspace-731832http://space.itpub.net/38267/viewspace-731874

环境：Red Hat Enterprise Linux AS release 4 (Nahant)      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod备库中：SELECT current_scn+1 FROM V$DATAFILE主库中...

10) Now restore the datafiles to new locations and recover. Since we are recovering the database here till the archivelog sequence 50 the sequence number in the SET UNTIL SEQUENCE clause should be &nb...

1.   LGWRLGWR參數在log buffer寫入redo log file的同時利用LNS進程(LGWR network server)將redo data傳輸到遠程standby中的standby redo log file，再在主庫日志切換時同時standby redo log file歸檔...

保護模式Maximum protection mode因某些故障在事務提交前，如主庫online redo log不能傳輸到至少一組備庫的standby redo log file中，主庫將自動關閉。必須用LGWR SYNC AFFIRM Maximum availability mo...