2013年12月_zhou1862324

12月 11月

原创 GG做extract时报错OGG-00053

现象：客户GG做extract时报错OGG-00053OGG-00053: No extraction maps specifiedCause: There are no TABLE parameters in the Extract parameter file to specifysource tables for which to capture data.Action: A

2013-12-11 19:13:46 1697

原创 OGG执行DDL复制报ORA-01435 user does not exist

2013-11-07 08:29:43 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep_app.prm: No unique key is defined for table 'C'. All viable columns will be used to represent the key, but may not guar

2013-12-11 19:13:07 2550

原创现象：GG做init data load时报错OGG-00869 OGG-00199

现象：GG做init data load时报错OGG-00869 OGG-001992013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, initrep.prm: WARNING: NLS_LANG environment variable is invalid or not set. Using o

2013-12-11 19:11:30 2787

原创 GG做init data load时，报错OGG-01192，OGG-01668

现象：GG做init data load时，报错OGG-01192，OGG-016682013-11-12 10:43:44 ERROR OGG-01192 Oracle GoldenGate Capture for Oracle, ext2.prm: Trying to use RMTTASK on data types which may be written as LOB chunk

2013-12-11 19:10:09 2315

原创 VIP不能正常启动，报错CRS-1006

VIP不能正常启动描述：我们的环境是2节点RAC，节点1发生物理故障造成宕机。此时我想将节点1的VIP从节点2上启动，以便单节点对用户程序透明。[oracle@UNID02 ~]$ crs_start ora.unid01.vipAttempting to start `ora.unid01.vip` on member `UNID02`Start of `ora.unid

2013-12-11 19:05:08 2167

原创如何处理HANG住的DB

如何处理HANG住的DB1. 生成 systemstate dump:SQL>sqlplus -prelim / as sysdbaSQL> alter session set max_dump_file_size = unlimited;SQL> alter session set events 'immediate trace name systemstate level

2013-12-11 00:40:05 630

原创 GoldenGate疑似BUG：info all查看不到extract

现象：info all查看不到extract ext2,但是info ext2却可以显示状态。GGSCI (JOADBTEST01) 20> ADD EXTRACT ext2, SOURCEISTABLEERROR: EXTRACT EXT2 already exists.GGSCI (JOADBTEST01) 21> info allProgram Status Group

2013-12-11 00:22:28 1123

原创 RMAN Restore异常终止，报错：Cannot allocate memory

RMAN restore过程中报Cannot allocate memory现象：channel ORA_DISK_1: restoring datafile 00030 to +TESTDG/rac/datafile/users.292.817416403channel ORA_DISK_1: reading from backup piece /BACKUP_DB/JOARAC

2013-12-10 21:00:56 1511

原创 DG不能自动mount导致数据库不能正常启动：ORA-01157、ORA-01110、ORA-17503、ORA-15001、ORA-15001

DG不能自动mount导致数据库不能正常启动：ORA-01157、ORA-01110、ORA-17503、ORA-15001、ORA-15001现象：每次重启整个CRS之后，DB都不能自动开启到OPEN状态，查看alert日志报错：SUCCESS: diskgroup UNID was mountedThu Nov 14 21:46:01 2013Create Relation

2013-12-10 20:39:49 1957

原创 messages报logger: Waiting minutes for filesystem containing crsctl

messages报logger: Waiting minutes for filesystem containing现象：发现每次REBOOT主机之后CRS启动都非常慢，发现messages有如下信息：Dec 5 18:20:40 saprac4 logger: Oracle Cluster Ready Services starting up automatically.Dec

2013-12-10 20:10:04 3511

转载 Oracle hang 之sqlplus -prelim使用方法

Oracle hang 之sqlplus -prelim使用方法 --转载自eygle博客很多情况下，Oracle hang导致sqlplus无法连接，从而无法获得Oracle系统和进程状态，使得定位问题缺少强有力的依据。所幸的是Oracle 10g推出了sqlplus -prelim选项，在Oracle挂起时依然能使用sqlplus，从而能获得数据库状态。使用方法如下

2013-12-10 18:38:49 2901

原创无法读表：ERROR 1018 (HY000): Can't read dir of './jiradb/' (errno: 13)

ERROR 1018 (HY000): Can't read dir of './jiradb/' (errno: 13)现象：数据库无法正常读表.[root@jiradb ~]# mysql -ujirakpi -pWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection

2013-12-10 18:36:38 4410 2

原创 CRS无法启动，运行crsctl start crs无响应

CRS无法启动，运行crsctl start crs无响应查看messages：[root@UNID02 ~]# tail -f /var/log/messagesDec 9 08:11:13 UNID02 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.7259

2013-12-10 18:33:58 4015

原创 RMAN故障诊断脚本集

RMAN故障诊断脚本集说明事项：该脚本用于提供RMAN的信息收集该脚本在RMAN中执行，如果使用了RMAN CataLog，则需要使用RMAN连接到资料库CataLog.该脚本将生成一个脚本文件 rman_diagnostics.out (default location is /tmp) 对于Unix环境，建议设置NLS_DATE_FORMAT环境变量，例如： $

2013-12-10 00:05:06 671

翻译备份&恢复诊断脚本集

User Managed Backup & Recovery Diagnostic Collection 注意事项：需要以SYSDBA权限登录SQL*PLUS执行实例需要 MOUNT or OPEN mode.生成结果文件：recovery_diagnostics.out (default location is /tmp)----------------- s

2013-12-09 23:54:42 658

原创 Oracle segment_name为数字的怪象

现象描述：RAC环境下表空间内所有段名都显示为数字：环境为：RAC Oracle 11.1.0.6,使用ASM作为存储空间异常前所做的操作：drop user unid cascade；select segment_name from dba_segments where tablespace_name='UNID'SEGMENT_NAME---------------

2013-12-09 23:45:02 2826

原创 Oracle数据字典一致性鉴别

数据字典（dd）一致性鉴别dd损坏通常包括：1. Data Dictionary Inconsistency, missing rows in tables: - Tab$/Ind$ with no entries in OBJ$ - Undo$/Tab$/Ind$ with no entries in SEG$ -

2013-12-09 23:28:40 1658

原创 TAF与负载均衡

(1) Client Side Connect-Time Load Balance (客户端连接时负责均衡配置)The client load balancing feature enables clients to randomize connection requests among the listeners.Tnsnames Parameter: LOAD_BALA

2013-12-05 23:46:19 953

原创关于logminer挖掘不出业务数据操作的解决

Problem Description：There is a requirement that found who update my business data,So I use Logminer to dig the archivelog file,But I cannot got the useful information(See the attachment).there a

2013-12-05 19:56:08 1068 2

原创关于shared pool过大

See the following:Snap Id Snap Time Sessions Cursors/SessionBegin Snap: 2120 05-Dec-12 09:00:43 160 5.3End Snap: 2122 05-Dec-12 11:00:04 153 5.5Elapsed: 119.34 (mins) DB Time: 504.70 (mins

2013-12-05 19:45:35 1018

原创让人吐血的TNS-01150

让人吐血的TNS-01150，将(ADDRESS_LIST=修改成：(ADDRESS_LIST=即解决。另将 (SID_DESC=修改为 (SID_DESC=[oracle@even admin]$lsnrctl start LSNRCTL for Linux:Version 10.2.0.1.0 - Production on 19-MAY-2

2013-12-05 19:37:00 10275 1

原创重新建库时遇到ORA-01102cannot mount database in EXCLUSIVE mode

重新建库时遇到ORA-01102: cannot mount database in EXCLUSIVE mode症状：建库时出现ORA-01102: cannot mount database in EXCLUSIVE mode分析：新建库的实例名与之前刚刚删掉的实例名一致，查看是否有原来实例的残留进程ps -ef查看，果然：[root@saprac4 ~]# ps

2013-12-05 19:28:53 645

原创执行RMAN拷贝时报错ORA-01276

症状：执行RMAN拷贝的时候报错ORA-01276: Cannot add file +TESTDG/rac/datafile/system.416.833384105. File has an Oracle Managed Files file name.如下：RMAN> copy datafile 1 to '+TESTDG/rac/datafile/system.416.83

2013-12-05 19:27:31 1249

原创使用rman迁移数据文件操作步骤(RAC-ASM环境)

使用rman迁移数据文件操作步骤：1.rman窗口执行copycopy datafile 1 to '+TESTDG/rac/datafile/system.dbf';copy datafile 2 to '+TESTDG/rac/datafile/sysaux.dbf';copy datafile 3 to '+TESTDG/rac/datafile/undotbs1.dbf';

2013-12-05 19:26:49 889

原创 rename datafile时报错ORA-01511,ORA-01121,ORA-01110

现象：实例启动到mount之后，rename datafile时报错ORA-01511,ORA-01121,ORA-01110SQL> SQL> ALTER DATABASE RENAME FILE '+DATA/rac/datafile/system.416.833384105' TO '+TESTDG/rac/datafile/system.dbf';ALTER DATABAS

2013-12-05 19:25:30 5762

原创 Oracle的数据表压缩

Oracle的数据表压缩压缩原理：将同一个Block里所有行的重复列值存储在表头的一块区域。该块区域被称为符号表（symbol table）。行里如果有某列的值等于符号表里存储的值，则不存储实际的值，只存储该值在符号表里的地址。表压缩技术适合的对象：Block里含有重复列值的数据表；读取较多，更改较少的表。数据表压缩的优点：对于Block里含有重复列值的数据表，

2013-12-05 19:23:34 643