Author: mac

【Oracle ASM数据恢复】ORA-15042: ASM disk is missing after add disk took place错误解析

如果在10.2.0.4 以后版本当向ASM Diskgroup中加入新的磁盘后diskgroup被dismount，尝试mount该diskgroup时报错ORA-15042: ASM disk is missing after add disk took place，那么可以参考本帖。 Tue Feb 12 17:33:59 2013 NOTE: X->S down convert bast on F1B3 bastCount=2 Wed Feb 13 04:06:38 2013 < ALTER DISKGROUP DG1 ADD DISK ‘/dev/mapper/t1_asm03p1’, ‘/dev/mapper/t1_asm04p1’, ‘/dev/mapper/t1_asm05p1’, ‘/dev/mapper/t1_asm06p1’ rebalance power 4 Wed Feb 13 04:06:38 2013 NOTE: reconfiguration of group…

February 11, 2013
【Oracle ASM】ORA-15196: invalid ASM block header [kfc.c:9194] [check_kfbh]错误解析

该问题的典型症状如下：在低于版本11.2的RAC环境中发生当从一个已经mount的diskgroup中增加或者drop磁盘时发现alert.log中出现ORA-15196错误一般在alert.log中是显示blk=2即block number=2的metadata block出现checksum错误如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 例如: WARNING: cache read a corrupted block gn=27 dsk=3 blk=2 from disk 3 NOTE: a corrupted block was dumped to /oracle/product/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_551.trc ERROR: cache failed to read gn=27 dsk=3 blk=2 from disk(s): 3 ORA-15196: invalid ASM block header…

February 9, 2013
【Database 12c】手动创建CDB Container Database容器数据库

手动建库几乎是每个DBA都需要掌握的技能，而Database 12c中手动创建Container Database容器数据库的过程是如何的呢？目前12c创建容器数据库Container Database和普通Database存在一点点小的区别，需要指定enable pluggable database，已创建的数据库目前无法转换为容器数据库。创建必要的目录 mkdir -p /stage/oradata mkdir -p /stage/fr mkdir -p /u01/app/oracle/admin/MACLEANCDB/adump 我们创建实例初始化文件，并创建DB: 1、 INIT.ORA ############################################################################## # Copyright (c) 1991, 2001, 2002 by Oracle Corporation ############################################################################## ########################################### # ########################################### _enable_pluggable_database=true ########################################### # Cache and I/O ########################################### db_block_size=8192 ########################################### # Cursors and Library Cache ########################################### open_cursors=300 ########################################### #…

February 8, 2013
[Oracle等待事件】SQL*NET MORE data to client

SQL*NET MORE data to client等待事件：意味着server process服务进程正在发送更多数据/信息给client, wait time代表SEND发送这个操作实际完成的时间。 driver id In Oracle8i onwards P1RAW can be decoded into ASCII characters to give a clue as to which Net driver is used. Eg: P1RAW=0x62657100 = ‘beq\0’ , P1RAW=0x54435000 = ‘TCP\0’ etc. In earlier releases the value here is the value of the disconnect function…

February 8, 2013
深入了解Oracle ASM(一):基础概念

ASM基础概念如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 任何转载请注明源地址，否则追究法律责任！：https://www.askmac.cn/archives/know-oracle-asm.html 相关文章链接： Asm Instance Parameter Best Practice 为什么RHEL 6上没有ASMLIB? Unix上如何查看文件名开头为”+asm”的TRACE文件 asm_power_limit对IO的影响针对11.2 RAC丢失OCR和Votedisk所在ASM Diskgroup的恢复手段 10g ASM lost disk log 11gR2 RAC ASM启动揭秘在11gR2 RAC中修改ASM DISK Path磁盘路径在Linux 6上使用UDEV解决RAC ASM存储设备名问题 Script:找出ASM中的Spfile参数文件如何诊断ASMLIB故障 Script:收集ASM诊断信息 Comparation between ASM note [ID 373242.1] and note [ID 452924.1] Why ASMLIB and…

February 6, 2013
了解你所不知道的SMON功能(十二):Shrink UNDO(rollback) SEGMENT

SMON对于Undo(Rollback)segment的日常管理还不止于OFFLINE UNDO SEGMENT ，在AUM(automatic undo management或称SMU)模式下SMON还定期地收缩Shrink Rollback/undo segment。触发场景这种AUM下rollback/undo segment的undo extents被shrink的现象可能被多种条件触发：当另一个回滚段的transaction table急需undo空间时当SMON定期执行undo/rollback管理时(每12个小时一次): SMON会从空闲的undo segment中回收undo space，以便保证其他tranaction table需要空间时可用。另一个好处是undo datafile的身材不会急速膨胀导致用户要去resize 当处于undo space空间压力时，特别是在发生UNDO STEAL的条件下; SGA中会记录前台进程因为undo space压力而做的undo steal的次数(v$undostat UNXPSTEALCNT EXPSTEALCNT)；若这种UNDO STEAL的次数超过特定的阀值，则SMON会尝试shrink transaction table 若smon shrink rollback/undo真的发生时，会这样处理：计算平均的undo retention大小，按照下列公式： retention size=(undo_retention * undo_rate)/(#online_transaction_table_segment 在线回滚段的个数) 对于每一个undo segment 若是offline的undo segment，则回收其所有的已过期expired undo extents，保持最小2个extents的空间若是online的undo segment，则回收其所有的已过期expired undo extents，但是保持其segment所占空间不小于平均retention对应的大小。注意SMON的定期Shrink，每12个小时才发生一次，具体发生时可以参考SMON进程的TRACE。若系统中存在大事务，则rollback/undo segment可能扩展到很大的尺寸；视乎事务的大小，则undo…

February 5, 2013
ORA-00600 [3020] when break remote mirror and startup database

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline: +86 13764045638 E-mail: [email protected] 1. Customer is using HDS remote mirror for DR solution. After breaking the mirror, in the DR site, some databases cannot startup with the following errors:…

February 5, 2013
ASM diskgroup cann’t mount and drop

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline: +86 13764045638 E-mail: [email protected] IHAC who encounter an error as below after restart database and storage . SQL> alter diskgroup DATA mount; alter diskgroup DATA mount *…

February 5, 2013
[Urgent] ORA-15042: ASM disk “76” is missing

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline: +86 13764045638 E-mail: [email protected] One customer has a ASM problem about ORA-15042. O/S: Linux X86 64bit 2.6.18-194.el5 DB Version : 10.2.0.5 Although we can access the ASM header using…

February 5, 2013
Need urgent help on ASM issue – disk header status problem

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline: +86 13764045638 E-mail: [email protected] ODA system +In order to workaround a known issue (startup hang when using Hitachi disks) FE/customer was in the process of replacing Hitachi drives…

February 5, 2013