> 文章列表 / Page 106

When diagnosing ASM issues, it helps to know a bit about the setup - disk group names and types, the state of disks, ASM instance initialisation parameters and if any rebalance operations are in progr...

Password file authentication for Oracle Database or ASM can work for both local and remote connections. In Oracle version 12c, the password files can reside in an ASM disk group. The ASM metadata stru...

Starting with Oracle Database version 11.2, an ASM disk group can be used for hosting one or more cluster file systems. These are known as Oracle ASM Cluster File Systems or Oracle ACFS. This function...

Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk gro...

Disk group attributes were introduced in ASM version 11.1. They are bound to a disk group, rather than the ASM instance. Some attributes can be set only at the time the disk group is created, some onl...

转自 asmsupportguy 博客 The other day I had to reconfigure an Oracle Restart 12c environment, and I couldn't find my blog post on that. It turns out that I never published it here, as my MOS document on t...

转自asmsupportguy 博客 This document explains how to resize the grid disks in Exadata (to make them larger), when there is free space in the cell disks. The free space can be anywhere on the cell disks. I...

The REQUIRED_MIRROR_FREE_MB and the USABLE_FILE_MB are two very interesting columns in the V$ASM_DISKGROUP[_STAT] view. Oracle Support gets many questions about the meaning of those columns and how th...

摘要 本发明提供一种手工恢复ASM文件的方法，涉及计算机系统设计领域和数据库领域，通过获取ASM磁盘信息来重构已损坏或者丢失的ASM磁盘头，然后再通过PST信息来获取相关磁盘的信息，最后通过alias来获取ASM磁盘中的数据文件，从而获得最终的数据文件。通过手工抽取损坏的ASM磁盘文件来达到没有备份的情况下的数据恢复。 权利要求(5) 1.一种手工恢复ASM文件的方法，其特征在于该方法包括ASM ...

转自asmsupportguy blog In the post Where is my data I have shown how to locate and extract an Oracle datafile block from ASM. To make things easier, I have now created a Perl script find_block.pl that a...