
Remember there is more than one preupgrd.sql.Critical Patch Update for July 2016 Now Available.12.2 New Feature: Automatically Synchronize Password Files in Oracle Data Guard.If you have finished your work remount them in normal mode. SQL> SELECT name, pathĭG_DATA_0_ST1_FG1 /dev/oracleasm/disks/ORA_DISK1ĭon`t forget that the diskgroup is in restricted mode. Query the v$ASM_DISK View to check for the new name. SQL> alter diskgroup DG_DATA rename disk 'DG_DATA_0000' to 'DG_DATA_0_ST1_FG1' SQL> alter diskgroup dg_data mount restricted Īfter mounting the diskgroup in restricted mode, we can now rename the diskname. For this example we want to rename the diskname to DG_DATA_0_ST1_FG1 which means Storage1 and Failgroup 1.įor renaming a disk in ASM we must remount the Diskgroup in restricted mode. The diskname DG_DATA_0000 is not very intuitiv because it tells nothing about the diskshelf or the storage the disk belongs to. WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = 'DG_DATA') ĭG_DATA_0000 /dev/oracleasm/disks/ORA_DISK1

The name of the disk typically looks like Diskgroupname an some Digits.įirst check your current diskname. When create a Diskgroup the ASM diskname is created per default for you.
