11G new Features-ASM compatibility

Source: Internet
Author: User

In Oracle 11g, ASM supports both 10g and 11g databases. However, the ASM version cannot be less than the database version.

Two parameters related to compatibility now:

Compatible.rdbms

The minimum supported version of the Oracle database.

compatible.asm

Controls the data storage format for ASM metadata on ASM disks. For example, if you set the value of Compatible.asm to 11.1, the ASM software version must be at least 11.1.

The ASM compatibility level must be at least the same as the RDBMS compatibility level and not lower than the RDBMS compatibility levels. Compatible.asm only controls the format of the ASM metadata, and the true data format still has the compatibility control of the RDBMS.

Specify compatibility when creating disks:

sql> Create DiskGroup dgroup1 disk'/dev/raw*'Attribute'compatible.asm'='11.1'; The value of the #compatible. DBMS is the default value of 10.1SQL> Create DiskGroup dgroup1 Disk'/dev/raw*'Attribute'compatible.asm'='11.1','Compatible.rdbms'='10.1';

To modify a property:

Set ' compatible '='11.1';

View Compatibility:

    Select  from V$asm_diskgroup;        Compatibility                  database_compatibility    ------------------------------------------------------------    11.2. 0.0. 0                     10.1. 0.0. 0    11.2. 0.0. 0                     10.1. 0.0. 0         SQL

• You cannot modify compatibility during a rolling upgrade
• Compatibility values can only be upgraded and cannot be degraded
• Only set the corresponding compatibility level to use the new features of the corresponding version

11G new Features-ASM compatibility

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.