« Rman Comparative Backup Sizes Using Backupset, Compressed Backupset and Backup As Copy | Main | Rman Compressed Backup and Duplicate Database Scripts »

Renaming an ASM Disk Group, Possible Workarounds

At this moment renaming an ASM Disk Group is not supported.

Available commands to manipulate Disk Groups are : Create, Alter, Drop, Mount, Dismount and Rebalance.

An enhancement request was filed on February 8, 2007, to provide this functionality.
Current status of the request is : command 'renamedg' will be implemented in a future release.

In which scenarios can be necessary to rename a Disk Group:
  • If you are cloning a database based on ASM and you wish to create several instances from the clone on the same server, you will need to rename the Disk Groups to be able to mount their copies, i.e. Production database disk groups are PRDDATADG and PRDARCHDG, and you would like to mount them from an EMC copy. That would not be possible because of the same disk group names, ASM does read the metadata on the disk headers and find that these disks are already mounted, then returns "ORA-15020: The discovery encountered two disks claiming to be the same named ASM disk".

  • If you have several production databases using generic Disk Group names, like DATADG and ARCHDG and you would like to mount them on a test or development server the same problem will happen.
What are your options if you want to clone a database on the same server, to be managed by the same ASM instance.
  • If the problem is related to several production databases that have the same disk groups names, and you want to mount them on a development or test server, then you may implement a disk group naming policy that assure disk group name uniqueness, i.e.  <SID><DATATYPE>DG this will produce names like CRMDATADG, APPLDATADG.

  • If the problem is related to cloning databases on the same server you may use Rman duplicate database feature. This option do require an Rman backup, you may use the compressed backupset  option, the compression rate is very high, about 80%.

    A step by step example to database cloning using Rman can be found on this post




TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/4340

Comments (1)

Alejandro,

Did you see anything that would help renaming the diskgroup (Possibly when not mounted) of a disk in 11g ? For now the only option I've found to mount a snapclone a disk on the same server is to use several ASM instances. I'd be very interested to find another way

Thank you for your help.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on March 25, 2007 5:33 AM.

The previous post in this blog was Rman Comparative Backup Sizes Using Backupset, Compressed Backupset and Backup As Copy.

The next post in this blog is Rman Compressed Backup and Duplicate Database Scripts.

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle