ITPub博客

12.2新特性，ADG是RAC环境，在多个实例可以启动MRP进程recover，命令如ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION INSTANCES ALL该特性只适用RAC和RAC one node环境数据库,不支持块跟踪,不支持In-Memeory列存储注：MRP进程只在执行命令的节点运行，其他

数据库版本12.2，使用standby备库备份恢复出一套可读写的数据库，在rename standby redolog时遇到ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being archived or modified，该错误是因为备库还处于reco ver模式，standby redo lo

配置完dg broker报如下错误：DGMGRL> show database jzhdgDatabase - jzhdg  Role:            PHYSICAL STANDBY  Intended State:  APPLY-ON  Transport Lag:   0 seconds (computed 1 second ago)  Apply Lag:       0 seco...

近日某客户在做异机恢复数据库时，restore完成，一直Hang住在recover归档，检查等待事件parallel recovery read buffer free出现该等待事件是因为源端数据库设置了不同block size大小的表空间，而目标端并没有设置db_nK_cache_size参数，检查源端select block_size, count(*) from dba_tablespaces group by block_size;确...

近日某客户系统遭遇如下错误导致数据库down机on Jan  9 10:48:36 2017Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:ORA-00600: 内部错误代码，参数: [6002], [6], [28], [1], [52], [], [], []Mon Jan  9 10:48:37 2017Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:ORA-0060...

该错误是由于SQL Tune Job执行超时导致，默认“Time Limit"是3600秒，即一个小时。DECLARE   l_sql_tune_task_id CLOB; BEGIN   l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (                          ...

使用expdp导出表空间时遇到ORA-31655: no data or metadata objects selected for job错误[oracle@jzh5 ~]$ expdp jzh/jzh tablespaces=test directory=dir dumpfile=test.dmpExport: Release 11.2.0.3.0 - Production on Wed Dec 21 03:10:46 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All r...

使用PL/SQL Developer连接数据库报ORA-12154错误该错误是由于64位操作系统安装32位的pl/sql developer在Program Files (x86)目录下，把目录改一下名或是把pl/sql移到Program Files目录下就可以了。

1、设置keep池大小SYS@jzh>alter system set db_keep_cache_size=60m;System altered.2、创建测试表JZH@jzh>create table t as select * from dba_objects;Table created.3、查看执行计划JZH@jzh>select * from t;74756 rows selected.Statistics----------------------------------------------------------&nb...

CAUSEEvent 'KSV master wait' indicates the process on the RDBMS side is waiting for a reply from a process on the ASM side.   In 11g, the parameter cell_offload_processing is set to TRUE.  Although that is a parameter is not applicable for non-Exadata databases, it caused ASM to...

1、初始化数据JZH@jzh>create table t as select * from dba_objects;Table created.JZH@jzh>select count(*) from t;  COUNT(*)----------     74756JZH@jzh>select bytes/1024/1024 from dba_segments where segment_name='T';BYTES/1024/1024---------------        ...

regmsr：become active该等待事件说明：会话正在等待一个resource manager的活动会话slot,当启用resource manager时，并且当前会话consumer group的活动session数量超过当前resource plan的会话限制就会发生该等待事件。禁用与启用resource plan与window 步骤如下：一、禁用resource plan与window:1、查询WINDOW状态和禁...

1.创建CTXSYS用户以SYS用户执行以下脚本：SQL> connect SYS/password as SYSDBASQL> spool text_install.txtSQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK各参数含义：change_on_install – 设置ctxsys用户密码SYSAUX – 调置ctxsys用户默认表空间TEMP – 设置ctxsys用户默认临时表空间LOCK...

某客户核心系统报ORA-00600,ORA07445错误,alert日志如下：Fri Nov 04 02:01:01 2016Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177618):ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], ...

近日某客户数据库凌晨5点左右crash，报如下错误：Fri Nov 11 03:17:51 2016Thread 1 advanced to log sequence 583682 (LGWR switch)  Current log# 16 seq# 583682 mem# 0: /jzh/jzh_u38/jzh/redo16a.logFri Nov 11 05:23:03 2016ALTER SYSTEM ARCHIVE LOGFri Nov 11 05:23:03 2016Thread 1 cannot allocate n...

ORACLE 回滚段 回滚段概述  　　回滚段用于存放数据修改之前的值（包括数据修改之前的位置和值）。回滚段的头部包含正在使用的该回滚段事务的信息。一个事务只能使用一个回滚段来存放它的回滚信息，而一个回滚段可以存放多个事务的回滚信息。 回滚段的作用  　　事务回滚：当事务修改...

近日某客户核心系统数据库出现hang住情况，AWR报告top 5中”enq: TX - row lock contention“占DB Time 97%以上，如下：trace文件中显示两个session互相阻塞，并且阻塞了大量sessionsclient details:      O/S info: user: sunflow, term: unknown, ospid: 1234      machine: pdccsfwm...

原文：Oracle Wait Interface—A Practical Guide to Performance Diagnostics & Tuning Richmond Shee Kirtikumar Deshpande K Gopalakrishnan McGraw-Hill/Osborne 2100 Powell Street, 10th Floor Emeryville, Ca...

Why are people so intensely interested in Oracle internals? Partly because internals information can be useful for tuning and troubleshooting. But also because Oracle Corporation has kept most of the ...

重建Data Guard遭遇错误PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.主库端archivelog无法传至备库端，主库端报如下错误：FAL[server, ARC0]: FAL archive failed, see trace file.ARCH: FAL archive failed. Archiver continuingORACLE Instance jzhd1 - Archival Error. Archiver ...