Osman DINC dincosman
dincosman
/ Asm_alertlog_findings1.txt
Created
September 27, 2022 14:04
Findings in the alertlog of asm instances.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ... | |
| 2020-08-02T07:17:22.818522+03:00 | |
| NOTE: process _user321942_+asm1 (321942) initiating offline of disk 50.3167206305 (RECO_CD_08_EXACEL11) with mask 0x7e in group 3 (RECO) without client assisting | |
| ... |
dincosman
/ Asm_alertlog_findings2.txt
Last active
October 7, 2023 06:26
Findings in the alertlog of asm instances.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ... | |
| Starting background process XDWK | |
| 2020-08-02T07:17:25.851671+03:00 | |
| XDWK started with pid=39, OS id=166367 | |
| 2020-08-02T07:17:25.869309+03:00 | |
| WARNING: I/Os to unhealthy ASM disk (DATA_CD_08_EXACEL11) in group DATA 1/0x975748AF will be diverted to its online partner disks | |
| WARNING: I/Os to unhealthy ASM disk (RECO_CD_08_EXACEL11) in group RECO 3/0x976748B1 will be diverted to its online partner disks | |
| WARNING: I/Os to unhealthy ASM disk (MORE_CD_08_EXACEL11) in group MORE 2/0x976748B0 will be diverted to its online partner disks | |
| 2020-08-02T07:17:25.952679+03:00 | |
| ... |
dincosman
/ Asm_alertlog_findings3.txt
Created
September 28, 2022 11:15
Findings in the alertlog of asm instances.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ... | |
| 2020-08-02T07:17:32.505170+03:00 | |
| SQL> /* Exadata Auto Mgmt: Proactive DROP ASM Disk */ | |
| alter diskgroup DATA drop | |
| disk DATA_CD_08_EXACEL11 force | |
| ... |
dincosman
/ Asm_alertlog_findings4.txt
Last active
October 7, 2023 06:26
Findings in the alertlog of asm instances.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ... | |
| 2020-08-02T07:18:58.745833+03:00 | |
| WARNING: Read Failed. group:1 disk:73 AU:381 offset:0 size:1048576 | |
| path:o/192.168.10.18/DATA_CD_06_exacel10 | |
| incarnation:0xbcc7ba7b asynchronous result:'I/O error' | |
| subsys:OSS krq:0x7f303e6e09c0 bufp:0x7f303d0d1000 osderr1:0xc9 osderr2:0x0 | |
| Exadata error:'Generic I/O error' | |
| IO elapsed time: 36233 usec Time waited on I/O: 0 usec | |
| WARNING: Read Failed. group:1 disk:73 AU:413 offset:2097152 size:1048576 | |
| path:o/192.168.10.18/DATA_CD_06_exacel10 |
dincosman
/ Asm_alertlog_findings5.txt
Last active
October 7, 2023 06:26
Findings in the alertlog of asm instances.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ... | |
| NOTE: process _arb0_+asm1 (167050) initiating offline of disk 73.3167206011 (DATA_CD_06_EXACEL10) with mask 0x7e in group 1 (DATA) with client assisting | |
| NOTE: initiating PST update: grp 1 (DATA), dsk = 73/0xbcc7ba7b, mask = 0x6a, op = clear mandatory | |
| ... | |
| Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_167050.trc: | |
| ORA-15130: diskgroup "" is being dismounted | |
| ORA-15066: offlining disk "DATA_CD_06_EXACEL10" in group "DATA" may result in a data loss | |
| Dirty detach reconfiguration started (new ddet inc 1, cluster inc 100) | |
| ... |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@exacel10 ~]# /opt/MegaRAID/storcli/storcli64 -Pdlist -aAll | grep "Slot\|Firmware" | |
| Slot Number: 0 | |
| Firmware state: Online, Spun Up | |
| Device Firmware Level: A8C0 | |
| Slot Number: 1 | |
| Firmware state: Online, Spun Up | |
| Device Firmware Level: A8C0 | |
| Slot Number: 2 | |
| Firmware state: Online, Spun Up | |
| Device Firmware Level: 0B25 |
dincosman
/ Change_physical_diskonline.txt
Created
November 6, 2022 19:03
Change_physical_diskonline
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@exacel10 ~]# /opt/MegaRAID/MegaCli/MegaCli64/MegaCli64 -PDOnline -PhysDrv[20:6] -a0 | |
| [root@exacel10 ~]# /opt/MegaRAID/storcli/storcli64 /c0/e20/s6 set online | |
| CLI Version = 007.0530.0000.0000 Sep 21, 2018 | |
| Operating system = Linux 4.1.12-124.30.1.el7uek.x86_64 | |
| Controller = 0 | |
| Status = Failure | |
| Description = Set Drive Online Failed. ------> BURADA HATA ALDIK. | |
| Detailed Status : | |
| =============== |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@exadb01 ~]# dcli -l root -g dbs_group "/u01/app/19/grid/bin/crsctl stop crs -f" | |
| [root@exadb01 ~]# crsctl start crs -excl -nocrs | |
| [root@exadb01 ~]# ocrconfig -showbackup | |
| PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy | |
| exadb01 2020/08/02 01:29:39 +DATA:/exa/OCRBACKUP/backup00.ocr.875.1047346171 3633918477 | |
| exadb01 2020/08/01 21:29:29 +DATA:/exa/OCRBACKUP/backup01.ocr.877.1047331763 3633918477 | |
| exadb01 2020/08/01 17:29:21 +DATA:/exa/OCRBACKUP/backup02.ocr.874.1047317353 3633918477 | |
| exadb01 2020/07/31 21:28:35 +DATA:/exa/OCRBACKUP/day.ocr.259.1047245315 3633918477 | |
| exadb01 2020/07/20 17:18:43 +DATA:/exa/OCRBACKUP/week.ocr.817.1046279925 3633918477 | |
| exadb01 2020/07/17 15:07:20 +DATA:/exa/OCRBACKUP/backup_20200717_150720.ocr.847.1046012841 3633918477 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SYS@+ASM1> alter diskgroup data mount restricted force for recovery; | |
| Diskgroup altered. | |
| ASMCMD> cp backup00.ocr.866.1047360579 /tmp/ocrbackup/backup00.ocr | |
| ASMCMD> ASMCMD-8012: cannot determine file type for file | |
| ORA-15236: diskgroup DATA mounted in restricted mode | |
| ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 518 | |
| ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) |
dincosman
/ amdu_command.txt
Last active
October 7, 2023 06:26
Restore file from ASM with amdu command.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@exadb01 ~]$ amdu -diskstring 'o/*/DATA_*' -extract data.875 | |
| amdu_2020_08_05_14_04_32/ | |
| AMDU-00204: Disk N0115 is in currently mounted diskgroup DATA. | |
| AMDU-00201: Disk N0115: 'o/192.168.31.12/DATA_CD_08_exacel04' | |
| AMDU-00204: Disk N0143 is in currently mounted diskgroup DATA. | |
| AMDU-00201: Disk N0143: 'o/192.168.31.13/DATA_CD_10_exacel05' | |
| AMDU-00204: Disk N0100 is in currently mounted diskgroup DATA. | |
| AMDU-00201: Disk N0100: 'o/192.168.31.11/DATA_CD_07_exacel03' | |
| [oracle@exadb01 ~]$ cd amdu_2020_08_05_14_04_32/ |