Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the compatibility properties of oracle 11g asm disk groups, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Starting with the oracle 11g version, asm disk groups have two new properties that are compatible with the asm version and the database version

COMPATIBLE.ASM-The minimum version of the ASM software that can access the disk group. In 11g, the default setting is 10.1.

COMPATIBLE.RDBMS-The minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group. In 11g, the default setting is 10.1.

1. You can specify the corresponding version when creating an asm disk group

CREATE DISKGROUP data DISK'/ dev/raw/*'

ATTRIBUTE 'compatible.asm' =' 11.1'

CREATE DISKGROUP data DISK'/ dev/raw/*'

ATTRIBUTE 'compatible.rdbms' =' 11.1', 'compatible.asm' =' 11.1'

two。 If the attribute database and asm version are not added, the default is 10.1.

SQL > SELECT group_number, name, compatibility, database_compatibility FROM v$asm_diskgroup

GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILI

--

1 ASM_DG 10.1.0.0.0 10.1.0.0.0

3. Modify the properties of an existing disk group

ALTER DISKGROUP asm_dg SET ATTRIBUTE 'compatible.asm' =' 11.1'

ALTER DISKGROUP asm_dg SET ATTRIBUTE 'compatible.rdbms' =' 11.1'

4. Examination result

COLUMN name FORMAT A10COLUMN compatibility FORMAT A20COLUMN database_compatibility FORMAT A20SELECT group_number, name, compatibility, database_compatibility FROM v$asm_diskgroup GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILI- 1 ASM_DG 11.1.0.0.0 11.1.0.0.01 row selected.SQL > COLUMN name FORMAT A20COLUMN value FORMAT A20SELECT group_number, name Value FROM v$asm_attribute ORDER BY group_number, name GROUP_NUMBER NAME VALUE- 1 au_size 1048576 1 compatible.asm 11.1.0.0.0 1 compatible.rdbms 11.1 1 disk_repair_time 3.6h4 rows selected.SQL > finish reading the above content Do you have any further understanding of the compatibility properties of oracle 11g asm disk groups? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.