提供综合数据库运维服务与优化方案(不限Oracle、MySQL、PG及国产数据库), 微信/Tel:(+86)134-365-60330
前天有套库发现表空间分了很大但是使用的非常少，想收回多余浪费的空间放回ASM，删了两个表空间应该可以释放1T左右的空间，但是ASM DISKGROUP的free space时，并没有增长， 也就是删除的空间没有释放， 开始以为遇到了BUG， 其实原因很简单， 只是在这简单记录这个问题的提个醒。
近来有套库空间紧张，发现有很大BIN$开头的TABLE partition,index partition 类型的段，查询确认是2个月前删除的对象，手动清空过dba_recyclebin使用purge，但都过去几天了，后来dba_recyclebin一直为空，发现对象BIN$XX还存在
增加新存储到现有ASM，使用udev配置绑定的存储，当增加了udev rule 配置文件中新增的lun， 执行了start_udev后，执行该命令RAC当前节点资源 的VIP fail 到另一个实例，并且listener offline
上周刚刚做了ASM Storage的一套13T 2 Nodes 11GR2 database RAC ON AIX 从老的SAN迁移到新的SAN , 迁移的磁盘组包含了DATAFILE 和所有Clusterware 的文件(OCR andvoting disk)， ORACLE ASM 的Rebalance特性使这件事情变的非常的容易，随着ASM的逐渐成熟，如果你计划做对已使用了ASM disggroup 做存储的迁移，ASM 的Rebalance 可以做为一套解决方案而且可以做到0 Downtime， 下面简单的分享这个过程。 迁移步骤 1.备份整个数据库和GI文件，并验证备份文件有效性 GI. # ocrcheck # crsctl query css votedisk DB. spfile,controlfile,datafile,logfile,tempfile,archivelog.. select d.name group_name,f.type,count(*) cnt from v$asm_file f join v$asm_diskgroup d on f.group_number=d.group_number group by rollup (d.name,f.type); A 迁移GI … Read more
to chose sqlplus “drop diskgroup”. however,the diskgroup that dropped is still listed as a resource. , Actually, the DB is open still, check alert log
ora-00313,ora-00312 ora-17503, ora-15001
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.
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
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.
Creates a backup directory if required, works out the ASM SID, renames the previous entry, then loops round backing up the metadata data for each diskgroup. It also lists each file backed up which is quite helpful. Finally it creates error checking and a log and error file outputs [grid@rac1 ~]$ cat asm_metadata_bk.sh #!/bin/sh # … Read more
ASM is the ability to add and remove disks/luns from a diskgroup with no down time and an automatic rebalancing of the data on the luns. This creates all kinds of possibilities.
存储asm instance spfile到asm，听上去很奇怪，启动自身，首先要解决的几个问题
1,asm diskgroup 没mount,如何读spfile?
2,在oracle_home/dbs下没有参数文件，如何知道spfile在哪?
3,不知道spfile，怎么知道的asm_diskstring?
LVM在后期因先前指定的路径空间不够时调整起来很方便，也可以就用于ASM，但是并不推荐ASM安装在LVM之上，因为LVM的功能在ASM上已存在。