Use Oracle Rac 11gR2 new feature renamedg to change diskgroup name

Source: Internet
Author: User

Account Environment: AIX7.1 + Dual-node Oracle RAC 11.2.0.3
Since this set of RAC is not installed in its own department, it is installed by the development department and is now managed by the Operations section, and customers need to command the ASM DiskGroup Name Installation Department specification. The oasmdgdata1 needs to be changed to DATADG. Fortunately, Oracle's version is 11GR2, and in 11gr2, Oracle has a new feature that allows you to change the DiskGroup name directly using the RENAMEDG command. Here are the specific steps.
[email protected]:/home/grid>asmcmdasmcmd> lsdgstate    type    rebal  Sector  block       AU  total_mb  free_mb  req_mir_free_mb  usable_file_mb   Offline_disks  voting_files  namemounted  normal  n           4096   1048576    358400   358192                0       &N Bsp  179096              0             N  oasmdgdat a01/mounted  normal  n           4096  1048576     15360   &NBS p;14434             5120            4657              0             Y  OCRDG/ASMCMD> umount oasmdgdata01asmcmd& Gt Lsdgstate    type &NBSp  rebal  sector  block       AU  total_mb  free_mb  req_mir_free_mb   USABLE_FILE_MB  offline_disks  voting_files  namemounted  normal  N           4096  1048576     15360    14434             5120            4657              0       &NBS P     Y  ocrdg/
[Email protected]:/home/grid>renamedg-helpnote:no ASM Libraries found in the system
Parsing parameters. Phase phase to execute, (phase=one| two| BOTH), default BOTH
Dgname DiskGroup to be renamed
Newdgname New name for the DiskGroup
Config Intermediate config file
Check just check-do not perform actual operation, (Check=true/fal SE), default FALSE
Confirm confirm before committing changes to disks, (confirm=true/f alse), default FALSE
Clean ignore errors, (Clean=true/false), default TRUE
Asm_diskstring ASM diskstring (asm_diskstring= ' discoverystring ', ' discover Ystring1 ' ...)
Verbose verbose execution, (verbose=true| FALSE), default false
Keep_voting_files Voting file attribute, (keep_voting_files=true| FALSE), default false
use RENAMEDG to change the name of the DiskGroup:[Email protected]:/home/grid>renamedg phase=both dgname=oasmdgdata01 NEWDGNAME=DATADG verbose=truenote:no ASM Libraries found in the system
Parsing parameters.
Parameters in effect:
         old DG name      : oasmdgdata01          n EW DG name          : datadg          phases       & nbsp      :                 phase 1        &NB Sp        phase 2         discovery str        :  &nbsp ;        clean              : true         r AW only          : truerenamedg operation:phase=both dgname=oasmdgdata01 NEWDGNAME=DATADG Verbo Se=trueexecuting phase 1Discovering The groupperforming discovery with string:identified disk ufs:/dev/rhdisk2 with disk n Umber:1 and Timestamp (33002374-296274944) identified disk Ufs:/dev/rhdisk1 with disk number:0 and timestamp (33002374-29 6274944) ChecKing for Hearbeat ... Re-discovering the groupperforming discovery with string:identified disk ufs:/dev/rhdisk2 with disk number:1 and timestamp (33002374-296274944) Identified disk Ufs:/dev/rhdisk1 with disk number:0 and timestamp (33002374-296274944) Checking if the DiskGroup is Mounte D or used by css checking disk number:1checking disk number:0generating configuration file: Completed phase 1Executing phase 2Looking for/dev/rhdisk2modifying The headerlooking for/dev/rhdisk1modifying the header Completed phase 2Terminating KGFD context 110285ba0[email protected]:/home/grid>[email protected]:/ Home/grid>sqlplus/as sysasm
Sql*plus:release 11.2.0.3.0 Production on Fri Oct 10 12:33:31 2014
Copyright (c) 1982, Oracle. All rights reserved.

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit productionwith the Real application Cluster S and Automatic Storage Management options
Sql> select Name,state from V$asm_diskgroup;
NAME State-----------------------------------------DATADG DISMOUNTEDOCR DG Mounted
Sql> alter DiskGroup DATADG Mount;
DiskGroup altered.
Sql> select Name,state from V$asm_diskgroup;
NAME State-----------------------------------------DATADG MOUNTEDOCRDG Mounted
[email protected]:/home/grid>asmcmdasmcmd> lsdgstate    type    rebal  Sector  block       AU  total_mb  free_mb  req_mir_free_mb  usable_file_mb   Offline_disks  voting_files  namemounted  normal  n           4096   1048576    358400   358192                0       &N Bsp  179096              0             N  datadg/mo unted  normal  n           4096  1048576     15360    1443 4             5120            4657              0             Y  OCRDG/ASMCMD> ASMCMD> exit[email  Protected]:/home/grid>sqlplus/As Sysasm
Sql*plus:release 11.2.0.3.0 Production on Fri Oct 10 12:39:41 2014
Copyright (c) 1982, Oracle. All rights reserved.

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit productionwith the Real application Cluster S and Automatic Storage Management options
Sql> select Name,path from V$asm_disk;
NAME PATH----------------------------------------------------------------------oasmdgdata01_000 0/dev/rhdisk1-----found from here, in fact, even changed the DiskGroup name,disk name has not changed. Oasmdgdata01_0001/dev/rhdisk2-----View the disk header information through kfed still find DiskGroup name or the previous one. ocrdg_0000/dev/rhdisk3ocrdg_0001/dev/rhdisk4ocrdg_0002/dev/ Rhdisk5
It is also necessary to delete the OASMDGDATA01 information in the CRS:[Email Protected]:/home/grid>crs_statname=ora. Datadg.dgtype=ora.diskgroup.typetarget=onlinestate=online on SUNDB01
Name=ora. Oasmdgdata01.dgtype=ora.diskgroup.typetarget=offlinestate=offline
[Email protected]:/home/grid>crsctl Delete Resource Ora. Oasmdgdata01.dg[email protected]:/home/grid>crs_stat-tname           Type           Target    state     Host        ---------------------- --------------------------------------Ora. DATADG.DG  ora....up.type ONLINE    online    sundb01    ora .... Er.lsnr ora....er.type ONLINE    online    sundb01    ora .... R1.lsnr ora....er.type ONLINE    online    sundb01    ora .... N1.lsnr ora....er.type ONLINE    online    SUNDB01    ora. OCRDG.DG   Ora....up.type ONLINE    online    SUNDB01    ora.asm       & Nbsp;ora.asm.type   ONLINE    online    SUNDB01    ORA.CVU        o Ra.cvu.type   ONLINE    onlinE    SUNDB01    ORA.GSD        ora.gsd.type   OFFLINE   OFFLINE   & nbsp           ora .... SM1.ASM application    online    online    sundb01    ora .... 01.lsnr application    online    online    sundb01    ora .... 01.lsnr application    online    online    SUNDB01    ORA....B01.GSD Application    offline   OFFLINE               ora....b01.ons application &nbsp ;  online    online    sundb01    ORA....B01.VIP ora....t1.type ONLINE     ONLINE    SUNDB01    ora .... SM2.ASM application    online    online    sundb02    ora .... 02.lsnr application    online    online    sundb02    ora .... 02.lsnr appLication    online    online    SUNDB02    ORA....B02.GSD application   &nbs P;offline   OFFLINE               ora....b02.ons application    ONL INE    online    sundb02    ORA....B02.VIP ora....t1.type ONLINE    online    SUNDB02    ora....network ora....rk.type ONLINE    online    SUNDB01    or a.oc4j       Ora.oc4j.type  online    online    SUNDB02    ora.ons &nbsp ;      ora.ons.type   ONLINE    online    sundb01    ora....ry.acfs Ora. .. Fs.type online    online    sundb01    ORA.SCAN1.VIP  ora....ip.type online   &NB Sp;online    SUNDB01    

Use Oracle Rac 11gR2 new feature renamedg to change diskgroup name

Related Article

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.