Infrastructure & Exadata

This blog identifies the DBA steps required to migrate databases from one disk array to another. Identify the ASM diskgroups and their disk (LUN) sizes Login to the ASM instance and identify the LUNs allocated to server. SQL> SET PAGES 999 SQL> col name format a15 For 11g ASM: SQL> select d.group_number, g.name, d.os_mb from … Read more

Rename ASM Diskgroup [11gR2] In 11gR2 it is possible to rename an ASM diskgroup. This is especially useful when performing database copy using OS level LUN mirroring technologies. The renamedg command is used to rename diskgroups. It has the following options: $ renamedg -help Parsing parameters.. phase                           Phase to execute,                                 (phase=ONE|TWO|BOTH), default BOTH dgname                          … Read more