This article covers some of the DBMA Commands which will be useful while performing this scenario where we want to reboot the cell not due to some maintenance activity.
[1] Verify the existing disk_repair_time attribute for all diskgroups SQL> select dg.name,a.value from v$asm_diskgroup dg, v$asm_attribute a where dg.group_number=a.group_number and a.name='disk_repair_time'; [2] The default disk_repair_time is 3.6 hours only so better to adjust. SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'DISK_REPAIR_TIME'='8.5H';
[3] Next you will need to check if ASM will be OK if the grid disks go OFFLINE. The following command should return 'Yes' for the grid disks being listed: cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome Execute the command below and the output should show either asmmodestatus=OFFLINE or asmmodestatus=UNUSED and asmdeactivationoutcome=Yes for all griddisks once the disks are offline in ASM. Only then is it safe to proceed with shutting down or restarting the cell: Note: Shutting down the cell services when one or more grid disks does not return asmdeactivationoutcome='Yes' will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly. [4] Inactivate all grid disks on the cell you wish to power down/reboot: cellcli -e alter griddisk all inactive [5] Confirm that the griddisks are now offline by performing the following actions: cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome cellcli -e list griddisk Note: Execute the command below and the output should show either asmmodestatus=OFFLINE or asmmodestatus=UNUSED and asmdeactivationoutcome=Yes for all griddisks once the disks are offline in ASM. Only then is it safe to proceed with shutting down or restarting the cell [6] You can now reboot the cell. #shutdown -h now [7] Once the cell comes back online - you will need to reactive the griddisks: cellcli -e alter griddisk all active [8] Issue the command below and all disks should show 'active': cellcli -e list griddisk [9] Verify grid disk status: cellcli -e list griddisk attributes name, asmmodestatus cellcli -e list griddisk attributes name where asmdeactivationoutcome != 'Yes'
Below are the some of the good article related to this topics.
-
- https://oracleracdba1.wordpress.com/2013/08/14/steps-to-shut-down-or-reboot-an-exadata-storage-cell-without-affecting-asm/
- http://www.oracle-ckpt.com/shut-down-or-reboot-an-exadata-storage-cell-without-affecting-asm-for-maintenance/
- https://dba010.com/2017/10/23/restart-exadata-storage-cell-service-without-affecting-asm/
For detail information,please refer MOS DOC ID 1188080.1 Steps to shut down or reboot an Exadata storage cell without affecting ASM.
Thank you for visiting this blog 🙂