Re: ASM adding disk with different sector size
From: Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com>
Date: Thu, 14 Oct 2021 11:48:52 +0200 (CEST)
Message-ID: <1855044598.3049.1634204932604.JavaMail.zimbra_at_performing-db.com>
Date: Thu, 14 Oct 2021 11:48:52 +0200 (CEST)
Message-ID: <1855044598.3049.1634204932604.JavaMail.zimbra_at_performing-db.com>
Sandra,
on top of what Raj wrote - there can as well be dependencies coming from the use of the disk group.
-- Martin Klier // Performing Databases GmbH Managing Partner // Senior DB Consultant Oracle ACE Director martin.klier_at_performing-db.com // https://www.performing-databases.comReceived on Thu Oct 14 2021 - 11:48:52 CEST
> Von: "Rajesh Aialavajjala" <r.aialavajjala_at_gmail.com>
> An: sbecker6925_at_gmail.com
> CC: "Oracle-L Freelists" <oracle-l_at_freelists.org>
> Gesendet: Mittwoch, 13. Oktober 2021 02:16:28
> Betreff: Re: ASM adding disk with different sector size
> Sandra,
> To the best of my understanding - ASM does not permit mixed sector sizes in a
> single disk group - so I presume that rules out the use of the 'removing the
> old disks and rebalance as we go'
> You didn't include the version of grid infrastructure/ASM that your environment
> is running ... but this was not allowed in 12c...
> 12c --> [
> https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203
> |
> https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203
> ]
> In 19c and higher - there's the concept of logical_sector_sizes and
> physical_sector_sizes but I am unsure of how that would fit into your migration
> scenario...
> [
> https://docs.oracle.com/en/database/oracle/oracle-database/21/ostmg/create-diskgroups.html#GUID-8B656725-D347-4166-8775-1070B6C4D580
> |
> https://docs.oracle.com/en/database/oracle/oracle-database/21/ostmg/create-diskgroups.html#GUID-8B656725-D347-4166-8775-1070B6C4D580
> ]
> Additions, comments, corrections welcome (and I will gladly defer to the wiser
> folks in this group)
> Thanks,
> --Rajesh
> On Tue, Oct 12, 2021 at 2:16 PM Sandra Becker < [ mailto:sbecker6925_at_gmail.com |
> sbecker6925_at_gmail.com ] > wrote:
>> We need to move some databases off of their current storage, which is old and no >> longer supported. The new disk will have a different sector size. Can we create >> a new diskgroup for the new storage and use it along with the old storage? If >> possible, can we do the balancing and then start removing the old disks and >> rebalance as we go? I'm not very familiar with ASM, so would appreciate some >> guidance or pointing me to an appropriate document. I've been doing some google >> searches, but still not sure we can move the databases in this manner. >> Thank you, >> -- >> Sandy B. -- http://www.freelists.org/webpage/oracle-l