When create a Diskgroup the ASM diskname is created per default for you. The name of the disk typically looks like Diskgroupname an some Digits. First check your current diskname. SQL>col name format a12 SQL>col path format a30 SQL>SELECT name, path FROM v$asm_disk WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = ‚DG_DATA‘); NAME PATH…
I have seen on many Oracle Database Servers that the audit files will fill up a filesystem. There are several approaches how to handle this on the RDBMS Installation but these options would maybe not work on the ASM side. There is also a nasty situation when you get this error when logging on to…
Oracle new feature in 11GR2 is that the voting files can reside in a Oracle ASM Diskgroup. The voting files resides in the first sectors of a disk in every failgroup, so in external redundancy you have only one voting file in a normal redundancy diskgroup you have by default 3 voting disks and so…
Anlegen von Flat ASM Disken Dieses Beispiel ist nicht für Produktive Installation gedacht und dient nur als Unterstützung um ASM Installationen unter Test Konditionen zu testen. Erstellen von Text Datein mit „dd“ DD=/u01/disk mkdir $DD chown grid:dba $DD su – grid dd if=/dev/zero of=$DD/_file_disk1 bs=1M count=1000 dd if=/dev/zero of=$DD/_file_disk2 bs=1M count=1000 dd if=/dev/zero of=$DD/_file_disk3 bs=1M…
Peter`s DBA Blog 