Oracle ASM Diskgroup Attributes Impact

From: Sanjay Mishra <"Sanjay>
Date: Tue, 15 Jan 2019 21:01:28 +0000 (UTC)
Message-ID: <363676062.55308.1547586088424_at_mail.yahoo.com>



I had an environment where I need to change the ASM diskgroup access_control.enabled to True for testmaster setup for thin clones. So question is 

  • If I change this Attribute for DATA diskgroup, Oracle manual says will not impact existing ASM files. What will happen to the new file created keeping in mind that there is only one user named ORACLE that owns all ASM/GI/RDBMS software on the system?  Do I need to be careful in setting ASM attribute umask ?
  • Also testmaster setup runs the commands like below where it is adding the Group also. So how this new group can impact all other new files added to already running regular database and using the Diskgroup? Do I need to be careful in defining this new Group in ASM? 

ALTER DISKGROUP <diskgroup> ADD USERGROUP '<Group Provided in OEM Screen>';

ALTER DISKGROUP <diskgroup> SET OWNERSHIP OWNER='<OSOWNER>',GROUP='<GroupAddedAbove>' for file '<ASM Full File Path>';

ALTER DISKGROUP <diskgroup> SET PERMISSION OWNER=read only,GROUP=read only for file '<ASM Full File Path>';     

  • Without setting these permission, Thin clone will fail to create the clone. Don;t have any environment to play and so if someone can share their experience 

TxSanjay

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 15 2019 - 22:01:28 CET

Original text of this message