ITPub博客

1.备库归档日志设置不正确如果standby_archive_dest初始化参数在备库设置路径不正确，那数据库就不能存储归档日志可以从视图v$archive_dest中destination,error字段查找原因，语句如下：SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;SQL> SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;2.使用alter database命令r...

刚刚安装完数据库，启动报错ORA-01102: cannot mount database in EXCLUSIVE modeSQL> startupORACLE instance started.Total System Global Area  534462464 bytesFixed Size                  2230072 bytesVariable Size           &n...

上周给客户做巡检时在alert日志发现这个错误ORA-07445: exception encountered: core dump [PC:0x90000000D017E10] [SIGSEGV]ORA-07445: exception encountered: core dump [PC:0x90000000D017E10] [SIGSEGV] [ADDR:0xFFFFFFFFDFFFB00] [PC:0x90000000D017E10] [Address not mapped to object] 2014/11/18 04:39:20 ...

1.检查警告日志数据库警告日志是按照时间顺序记录数据库的信息和错误，除了提供oracle数据库信息之外，还包括对Data Guard一些操作的信息，如下：1.1执行相关sql语句：alter database recover managed standby,startup,shutdown,archive log还有recover；1.2一些后台进程会报相关错误，如：ARCO,MRP0,RFS,LGWR；1.3操作...

问题 1：ORA-29770 LMHB 终止实例症状：LMON (ospid: 31216) waits for event 'control file sequential read' for 88 secs.Errors in file /oracle/base/diag/rdbms/prod/prod3/trace/prod3_lmhb_31304.trc (incident=2329):ORA-29770: global enqueue process LMON (OSID 31216) is hung for more than 70 secondsL...

1.创建测试表JZH@TEST>create table t (x int,y int);Table created.JZH@TEST>create index t_indx on t(x,y);Index created.JZH@TEST>insert into t values(1,1);1 row created.JZH@TEST>insert into t values(1,null);1 row created.JZH@TEST>insert into t values(null,1);1 row created.JZH@TEST>insert int...

1、  当前数据库环境：两节点RAC OS Redhat 6.4 64bitGrid software 11.2.0.4Oracle software 11.2.0.4准备补丁安装包如下：p6880880_112000_Linux-x86-64.zipp18139609_112040_Linux-x86-64.zip2、  检查当前数据库的版本[oracle@nopplbds03 OPatch]$ ./opatchversion...

升级Grid Infrastructure时遭遇[INS-06006] Passwordless SSH connectivitynot set up between the following node(s)错误，如下图：一、环境说明：DB版本：Oracle 11.2.0.4 OS版本：Redhat 6.4二、处理方法1、使用ssh验证等效性[grid@NOPPLBDS03 ~]$ date;ssh NOPPLBDS03dateWed Dec 10 17:06:23 CS...

客户数据库备份日志报错：RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process，DB版本为11.2.0.1，根据备策略，每天备份归档，并且自动删除档，保留两个星期的归档，手功执如下命令：delete noprompt archivelog until time 'sysdate-14'；依...

1.启用数据库附加日志SYS@TEST>alter database add supplemental log data;Database altered.2.以sysdba登陆，执行logminer脚本SYS@TEST>@$ORACLE_HOME/rdbms/admin/dbmslm.sqlPackage created.Grant succeeded.Synonym created.3.检查logminer是否可用SYS@TEST>desc dbms_logmnrPROCEDURE ADD_LOGFILE ...

客户在检查数据库alert日志时发现错误，信息如下：ORA-00270: error creating archive log FAL[server, ARC1]: FAL archive failed, see trace file.Errors in file c:\app\administrator\diag\rdbms\bpmes\bpmes\trace\bpmes_arc1_5680.trc:ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver ...

朋友的数据库alert警告日志文件里报ORA-00600: internal error code, arguments: [kollasg:client-sid tmp lob]数据库版本是10.2.0.5，在mos上找到了一篇文章ORA-00600 [kollasg:client-side tmp lob] Fetching Row With LOB Column in OCI Application (文档 ID 1418135.1)APPLIES TO:Oracle Database - Enterprise E...

昨天给某客户做巡检，检查alert警告日志文件发现ORA-07445: exception encountered: core dump [qkaqkn()+5390] [SIGSEGV] [Address not mapped to object]错误，客户环境是两节点RAC，数据库版本是10.2.0.5.0，两节点的alert警告日志文件中都报这个错误，打开对应的trace文件，错误如下：ksedmp: internal or fatal error...

今天给虚拟机添加了一块磁盘，然打算设置为自动挂载的时候将/etc/fstab文件改错了导致系统启不来用root用户进入修改/etc/fstab文件，报错说是只读文件，使用w!强制保存也不行然后进入grub以sigle方式也不行，再用光盘启动也不行，最后的解决办法是1.然后输入fsck －a命令，检查硬盘；2.然后再输入df命令查看li...

插入数据时遭遇ORA-01552: cannot use system rollback segment for non-system tablespace 'xxx'错误如下：JZH@test>insert into test values('sequence 25');insert into test values('sequence 25')            *ERROR at line 1:ORA-01552: cannot use system rollback segment fo...

首先创建一张测试表JZH@test>create table t2 as select * from dba_objects where 0=1;Table created.JZH@test>select * from t2;no rows selected设置nologgingJZH@test>alter table t2 nologging;Table altered.插入数据JZH@test>insert /*+ append */ into t2 select * from dba_objects;75301 rows created....

1、创建directoryJZH@test>create directory test_dir as '/home/oracle/';Directory created.2、创建测试表JZH@test>create table emp1 as select * from scott.emp;Table created.3、查看表所在表空间JZH@test>select owner,table_name,tablespace_name from dba_tables where table_name='EMP1';OWNER   &n...

expdp jzh/jzh dumpfile=emp1.dmp directory=test_dir tables=emp1 logfile=emp1.logExport: Release 11.2.0.3.0 - Production on Sat Sep 27 14:40:07 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3...

library hitbuffer hit--这两项应该特别关注报告的第一部分：它包含了一些数据库和实例的信息sessions--采集实例连接的会话数，了解并发用户的大概情况，判断数据库的类型很有用db time--这个数据比较重要，它表...

MySQL体系结构