提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330
数据库oracle
A Question in QQ group get ins-30131 error when install oracle database 12c today, following error
[INS-30131] Initial setup required for the execution of installer validations failed
In the case ,the corrupted block was a index segment
ORA-01578: ORACLE data block corrupted (file # 47, block # 49)
ORA-01110: data file 47: ‘/dev/rdb…’
Rman backup fails with ORA-19566 error
A friend asked me ,they add new disk to a ASM diskgroup. Disks were added successfully. But when tried alter tablespace add new datafile using the diskgroup one the disks were recently added, they got “ora-01119” and “ORA-17502″,”ORA-15041” errors during add new datafile.
昨天DB 磁盘空间预警空间不足，发现临时表空间扩展的非常之大，于是规划调整临时表空间换个磁盘路径，本来online switch temp tablespace 并不难，结果还是遇到小问题..
ON single-instance 1, make sure asm diskgroup is avaliable Select name,total_mb,free_mb from v$asm_diskgroup where state=’CONNECTED’; 2, check current controlfile and using spfile show parameter control_files show parameter pfile 3, add new controlfile to spfile alter system set control_files='[original file]’,'[asm diskgroup name where new control file will stored]’ scope=spfile ; for example: alter system set control_files=’+OLD/ANBOB/controlfile/current.258.798205861′,’+NEW_DATA’ … Read more
自己画了个从oracle 7及后续版本升级到oracle 12c 的升级路线图。 另存为下载查看效果良好。
With the annoucement of Oracle’s database support on RHEL6 and OEL6, they have decided to stop making ASMLIB for RHEL compatible kernels. ASMLIB is now only available if you are using Oracle Unbreakable Linux Kernel.But Recent events enabled Red Hat and Oracle to work togethe. Oracle ASMLib availability and support on Red Hat Enterprise Linux 6.
今天测式部门同事遇到的一个问题记录一下，开发库运行正常，同样的复制到测试库执行应用报错,
LINE/COL ERROR
——– —————————————————————–
59/5 PL/SQL: Statement ignored
59/23 PLS-00382: expression is of wrong type
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object]
PROMPT List all SQL in the library cache cursor referencing a given table — Author: weejar — — you need to run this script either as SYS or — need to have relevant X$ proxy views created — I tested in oracle 11g it worked . undefine owner undefine table_name prompt accept owner prompt ‘Please … Read more
来模拟一种刚建的表空间，还没来的及备份，数据文件被删除，但archive log 都在时的恢复。 sys@ANBOB>create tablespace tbs_rm datafile ‘/oradata/anbob/tbs_rm01.dbf’ size 10m; Tablespace created. sys@ANBOB>conn anbob Enter password: Connected. anbob@ANBOB>create table test_rm tablespace tbs_rm as select rownum id from dual connect by levelselect * from test_rm; ID ——————– 1 … 9 10 破坏数据文件，使用mv [oracle@db231 ~]$ mv /oradata/anbob/tbs_rm01.dbf /oradata/anbob/tbs_rm01_dbf sys@ANBOB>alter system flush buffer_cache; System altered. anbob@ANBOB>select * from … Read more
Oracle has the BBED utility (block browser and editor) is is all releases of Oracle, from Oracle7 to Oracle10g,In Oracle 11g, BBED becomes unavailable but if you search in the ins_rdbms.mk makefile,…
standby site 的ABMR没有成功， 后来是怀疑buffer header中有mrec 的block, 现在我接着测试如果buffer header 中没有此类block，ABMR是否成功?以前用bbed 标记corrupt block的方式， 如果有corrupt block时rman backup 又会怎么样？
Automatic block repair allows corrupt data blocks to be automatically repaired as soon as the corruption is detected. This feature reduces the amount of time that data is inaccessible due to block corruption.
今天刚搭建的一个Data guard环境，一开始在日志传输时遇到ora-12592错误，ORA-12592: TNS:bad packet
一个不错的oracle AWR 报告本地文件格式化chrome浏览器插件，看似用js完成，有一些特性非常不错，拿出来分享，作者Tyler Muth –观看 需要翻墙 视频介绍 下载 下载地址1 下载地址2 安装方法 1，下载AWR-Format.crx文件 2，打开chrome 谷歌浏览器，我这里版本是28，点击右上角的按钮或显示菜单，找工具–扩展程序 打开扩展程序页面 3，用鼠标把1 下载的文件托进浏览器的这个页面，增加插件，默认是启用，勾选插件下的“允许访问文件网址” 4，右击本地的AWR html文件，使用google chrome 打开，体验一下吧
当你在windows NTFS文件系统操作大的数据文件时，有时会遇到下面的错误:
The operating system returned error 665 (The requested operation could not be completed due to a file system limitation)
# crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
Prior to 10g you can use a unix debugger like gdb, adb or dbx to attach to a shadow process and dump the system state using the function ksudss which is the subroutine in the Oracle source code which does the same.
If you need to recovery the dead transaction record of more than 100(_cleanup_rollback_entries parameter value), PMON only responsible for cleaning up dead session, which is responsible for the SMON recovery dead transaction.