Author: mac

drm 是Oracle rac中独有的动态资源管理操作， 我们听了很多关于DRM的理论， 但是你是否亲眼见证过DRM, 今天我们就来看一下：   SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production PL/SQL Release 11.2.0.3.0 – Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 – Production NLSRTL Version 11.2.0.3.0 – Production SQL> SQL> select count(*) from gv$instance; COUNT(*) ———- 2 SQL> create…

虽然我们也可以通过dbv(db file verify)工具做到对单个数据文件的坏块检测，但是直接使用RMAN的”backup validate check logical database;”结合V$DATABASE_BLOCK_CORRUPTION视图要方便地多。 如果自己搞不定可以找ASKMACLEAN专业ORACLE数据库修复团队成员帮您恢复! Script: 1) $ rman target / nocatalog 2) RMAN> run { allocate channel d1 type disk; allocate channel d2 type disk; allocate channel d3 type disk; allocate channel d4 type disk; backup validate check logical database; } 3) select * from V$DATABASE_BLOCK_CORRUPTION ; REM www.askmac.cn & www.askmac.cn…

今天有同行问我DBMS_STATS与Analyze的区别， 我简单地介绍了一下DBMS_STATS提供了更丰富的功能，从8i开始推荐使用DBMS_STATS来完全替代Analayz Table/Index/Cluster 命令收集数据库中对象的统计信息。   之后他又问起我有那些功能是Analyze 命令可以做到，反而DBMS_STATS做不到的？   这个问题我倒是没有很系统地去考虑过， 闪过脑子的2个念头就是Analyze Table/Index validate structure 和  Analyze Table list chained rows into chained_rows 这2个命令。   Google了一下相关的信息，发现Asktom对这个已经讨论过了，从8i以后analyze被提名为具备”validate”验证功能的命令，主要负责验证表和索引的结构以及链式行(chained and migrated rows)信息； 而DBMS_STATS包负责统计信息的管理。   analyze is slated to do this and this alone at some time in the future.  analyze is destined to be the “validate” thing — analyze validate…

可以通过隐藏参数_datafile_write_errors_crash_instance控制DBWR进程写出到数据文件遇到I/O问题时的表现： 在版本11.2.0.2中： 1. 默认情况下，若是RAC或未启用归档的实例或出现问题的是SYSTEM表空间的数据文件会导致实例终止；其他情况下，会造成相关数据文件被OFFLINE。 2.若该参数设置为TRUE，则在DBWR写文件出现问题时总是终止本实例 3. 若设置为FALSE，仅在未启用归档或SYSTEM表空间的数据文件的情况下会终止实例；   ” The new behavior is defined by _datafile_write_errors_crash_instance parameter. Parameter has no default value and 3 different behaviors depending if it is set and to which value. For default behavior (param not set) the instance is crashed if RAC or archivelog mode is disabled or this is…

Oracle Applications Manager > Concurrent Managers OR Concurrent Requests > Site Map > Diagnostics and Repair > Concurrent Manager Recovery 介绍了 Concurrent Manager Recovery ，路径如上 尝试使用该功能 否则 locate adstpall.sh locate adstrtal.sh adstpall.sh ==》关闭所有EBS adstrtal.sh ==> 启动所有EBS shutdown immediate; startup; ==> 重启数据库 cmclean.sql ==》 使用apps 用户执行 ==》 如果还不行， 建议他开一个SR，就说可能是bug 。 Concurrent Processing – CMCLEAN.SQL – Non…

存在这样的情况create tablespace.. datafile or alter tablespace add datafile时加入数据文件的datafile name中存在乱码，例如以下例子:   SQL> select file#,name from v$datafile where file#=20; FILE# NAME ———- ————————————————– 20 /s01/锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟dbf SQL> alter database rename file ‘/s01/锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟dbf’ to ‘/s01/rename.dbf’; alter database rename file ‘/s01/锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟dbf’ to ‘/s01/rename.dbf’ * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, datafile, or…

2012-11-22 14:46:37 WARNING OGG-03504 NLS_LANG character set UTF8 on the target is different from the source database character se t AL32UTF8. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set. 2012-11-22 14:46:37 WARNING OGG-00869 Aborting BATCHSQL transaction. Detected inconsistent result: executed 1 operations in batch,…

Oracle Database常见存储用语Terms,如下： ACD = Active Change Directory ACFS = ASM Cluster File System ADDM = Automatic Database Diagnostic Monitor ADR = Automatic Diagnostic Repository ADVM = ASM Dynamic Volume Manager AIO = Asynchronous I/O AMDU = ASM Metadata Dump Utility AMM = Automatic Memory Management ARC = Archive process ASH = Active Session History ASM…

Sample drop user ogg_maclean cascade; create user ogg_maclean identified by oracle; alter user ogg_maclean default tablespace users; grant connect,resource to OGG_MACLEAN; OGG_MACLEAN maclean_press conn ogg_maclean/oracle create table maclean_press1(a int constraint key1 primary key,b varchar2(100),c varchar2(100),d date default sysdate,e date); create table maclean_press2(a int constraint key2 primary key,b varchar2(100),c varchar2(100),d date default sysdate,e date); create table…

  DISCLAIMER DUL is written by Bernard van Duijnen, from Oracle Support – Netherlands DUL is NOT an Oracle product DUL is NOT a supported Oracle product DUL is strictly for Oracle Support and internal use only DUL engagements are only initiated through the PSF as the result of a recovery effort DUL exposes Oracle’s…