11g ASM New Feature [ID 429098.1]

 

11g ASM New Feature [ID 429098.1]
	Modified 23-AUG-2007     Type BULLETIN     Status PUBLISHED

In this Document
  Purpose
  Scope and Application
  11g ASM New Feature
     1.New SYSASM Role for Automatic Storage Management Administration
     2.The Disk Group Compatibility feature
     3.ASM Fast Rebalance
     4.ASM Fast Mirror Resync
     5.ASMCMD New Commands
     6.Preferred Mirror Read
     7.ASM Variable size extents,scalability and performance enhancements
     8.Automatic Storage Management Rolling Migration
  References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1 to 11.1
Linux x86

Purpose

This document is intended to introduce various new ASM features introduced in Oracle Database 11g.

 Please find below list of the features

1) New SYSASM Role for Automatic Storage Management Administration
2) Disk Group Compatibility attributes
3) ASM Fast Rebalance
4) ASM Fast Mirror Resync
5) New ASMCMD commands
6) Automatic Storage Management Preferred Mirror Read
7) ASM Variable size extents,scalability and performance enhancements
8) Automatic Storage Management Rolling Migration

Scope and Application

All the DBAs and users concerned with Database Administration activities.

11g ASM New Feature

1.New SYSASM Role for Automatic Storage Management Administration

The SYSASM privilege enables the separation of the database operating system credentials from the ASM credentials.

Use the SYSASM privilege instead of the SYSDBA privilege to connect to and administer an ASM instance. If you use the SYSDBA privilege to connect to an ASM instance, then Oracle writes warnings to the alert log file because commands that you run using the SYSDBA privilege on an ASM instance will eventually be deprecated.

Oracle writes alerts to the alert log files if you issue CREATE, ALTER, or DROP DISKGOUP statements that should be performed by SYSASM.

Alert entry

WARNING: Deprecated privilege SYSDBA for command 'STARTUP'
WARNING: Deprecated privilege SYSDBA for command 'SHUTDOWN'

SQL> create diskgroup dgext external redundancy disk '/dev/raw/raw7'
WARNING: Deprecated privilege SYSDBA for command 'CREATE DISKGROUP'

2.The Disk Group Compatibility feature

Two new Disk Group compatibility attributes are introduced in the Oracle 11g ASM.

The new compatible.asm and compatible.rdbms disk group compatibility attributes determine the minimum version of ASM and database instances that can connect to an ASM disk group

Advancing the Disk group Oracle Database and ASM compatibility settings enables you to use the new ASM features that are available in latest release.

Advancing compatible.asm/compatible.rdbms attributes from 10.1 to 11.1 will enable the following key features:

- Preferred mirror read
- Variable size extents
- Fast mirror resync

The software version of ASM determines the default compatibility of newly created disk groups. You can override the disk group compatibility default setting when you create disk groups with the CREATE DISKGROUP SQL statement.

The ALTER DISKGROUP SQL statement can update the compatibility settings for existing disk groups.

The compatibility settings for a disk group can only be advanced, you cannot revert to a lower compatibility setting.

Example to create diskgroup with compatible attribute : 

SQL> create diskgroup dgext11gasm external redundancy disk '/dev/raw/raw7'  
attribute 'compatible.asm'='11.1';  
Diskgroup created.  

SQL> create diskgroup dgext11grdbms external redundancy disk '/dev/raw/raw8'  
attribute 'compatible.rdbms'='11.1','compatible.asm'='11.1';  

select name,compatibility,database_compatibility from v$asm_diskgroup;  

NAME COMPATIBILITY DATABASE_COMPATIBILITY  
--------- -------------------- ------------ 
DGEXT11GASM 11.1.0.0.0 10.1.0.0.0  
DGEXT11GRDBMS 11.1.0.0.0 11.1.0.0.0  
 

 

 

Refer below note for Diskgroup creation error's in 11g

Note.433710.1 - ORA-15234 target RDBMS compatibility (11.1.0.0.0) exceeds ASM compatibility

 

3.ASM Fast Rebalance

The RESTRICTED mode enables you to perform all maintenance tasks on a disk group in the ASM Instance without any external interaction.Rebalance operations performed while the diskgroup is in restricted mode eliminate the lock/unlock extent map messaging between ASM instances in Oracle RAC environment,thus improving overall rebalance throughput.

Refer below note for more information about the feature

Note 445037.1 - ASM Fast Rebalance

4.ASM Fast Mirror Resync

ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online or replaced.

By default, ASM drops a disk shortly after it is taken offline. You can set the DISK_REPAIR_TIME attribute to prevent this operation by specifying a time interval to repair the disk and bring it back online.

To use this feature, the disk group compatibility attributes must be set to 11.1 or higher

For more information refer below Note

Note.443835.1 - ASM Fast Mirror Resync - Example to simulate transient disk failure and restore disk

5.ASMCMD New Commands

ASMCMD has the following four new commands: lsdsk,md_backup,md_restore and remap

The following describes the four new ASM commands:

cp - Enables you to copy files between ASM disk groups on local instances and remote instances.

 

lsdsk -ASM can list disk information with or without a running ASM instance. This is a useful tool for system or storage administrators who want to obtain lists of disks that an ASM instance uses.

 

md_backup and md_restore - These commands enable you to re-create a pre-xisting ASM disk group with the same disk path, disk name, failure groups, attributes,templates and alias directory structure. You can use md_backup to back up the disk group environment and use md_restore to re-create the disk group before loading from a database backup.

 

remap - You can remap and recover bad blocks on an ASM disk in normal or high redundancy that have been reported by storage management tools such as disk scrubbers. ASM reads from the good copy of an ASM mirror and rewrites these blocks to an alternate location on disk.

 

6.Preferred Mirror Read

When ASM is managing redundancy,you can configure an ASM instance on a node to read from a preferred mirror copy(ie a preferred real failure group). The default behaviour is to always read from the primary copy.

The feature is beneficial when you have an extended Oracle RAC cluster,where the nodes and the failure groups are seperated by a long distance to enable disaster recovery. In this case, the Oracle RAC nodes on each site can be configured to read from their local storage mirror copies instead of going through a newtwork with potentially high latencies.

The ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter to specify a list of failure group names as preferred read disks.This parameter is a multi-valued parameter and should contain a string with a list of <disk group><failure group name> seperated by a comma.

7.ASM Variable size extents,scalability and performance enhancements

The variable size extent feature in Oracle Database 11g enables support for much larger ASM files,reduces SGA memory requirements for very large databases,and improves performance for file create and open functions.

An ASM file can begin with 1MB extents and as the file size increases,the extent size also increases to 8MB and 64MB at a predefined number of extents.Therefore, the size of extent map defining a file can be smaller by a factor of 8 and 64 depending on the size of the file.The initial extent size is equal to the allocation unit size and it increases by the 8 and 64 factor at predefined thresholds.

This feature is completely automatic for newly created files once compatible.asm and compatible.rdbms have been advance to 11.1

8.Automatic Storage Management Rolling Migration

ASM rolling upgrades enable you to independently upgrade or patch clustered ASM nodes without affecting database availability, thus providing greater uptime. Rolling upgrade means that all of the features of a clustered ASM environment function when one or more of the nodes in the cluster uses different software versions.

To perform a rolling upgrade, your environment must be prepared.If you are using Oracle Clusterware, then your Oracle Clusterware must be fully upgraded to the next patch or release version before you start the ASM rolling upgrade.In addition, you should prepare your Oracle Clusterware in a rolling upgrade manner to ensure high availability and maximum uptime.

Before you patch or upgrade the ASM software on a node,you must place the ASM cluster into rolling upgrade mode. This enables you to begin an upgrade and operate your environment in multiversion software mode. Do this by issuing the following SQL statement where number includes the version number, release number, update number, port release number, and port update number. Enter these values for number in a decimal-separated string, (e.g 11.2.0.0.0)

To perform the upgrade as in the following example

ALTER SYSTEM START ROLLING MIGRATION TO 11.2.0.0.0;

 

 

 

 

 

 

 

-------------------------------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请