Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:oracle_rac_12c_backup_recovery [2016/09/21 20:55] – [Quellen] gpipperr
+++ dba:oracle_rac_12c_backup_recovery [2018/05/03 15:32] – [Problem DISK_REPAIR_TIME Attribute Expired] gpipperr
@@ Zeile 349: / Zeile 349: @@
+----
 ==== Label einer Platte geht verloren ====
@@ Zeile 468: / Zeile 471: @@
 </code>
+=== Problem DISK_REPAIR_TIME Attribute Expired  ===
+als sys as syasm
+<code sql>
+SYS@+ASM2-tng1db02>alter diskgroup RECO01 online disks in failgroup STORAGE2;
+alter diskgroup RECO01 online disks in failgroup STORAGE2
+*
+ERROR at line 1:
+ORA-15032: not all alterations performed
+ORA-15281: not all specified disks were brought ONLINE
+ORA-15284: ASM terminated ALTER DISKGROUP ONLINE
+</code>
+Im Alert file der ASM Instance:
+<code bash>
+SQL> alter diskgroup RECO01 online disks in failgroup STORAGE2
+NOTE: cache closing disk 9 of grp 3: (not open) _DROPPED_0009_RECO01
+NOTE: cache closing disk 16 of grp 3: (not open) _DROPPED_0016_RECO01
+NOTE: cache closing disk 17 of grp 3: (not open) _DROPPED_0017_RECO01
+NOTE: cache closing disk 18 of grp 3: (not open) _DROPPED_0018_RECO01
+NOTE: cache closing disk 19 of grp 3: (not open) _DROPPED_0019_RECO01
+NOTE: cache closing disk 20 of grp 3: (not open) _DROPPED_0020_RECO01
+NOTE: cache closing disk 21 of grp 3: (not open) _DROPPED_0021_RECO01
+NOTE: GroupBlock outside rolling migration privileged region
+NOTE: initiating resync of disk group 3 disks
+_DROPPED_0009_RECO01 (9)
+_DROPPED_0016_RECO01 (16)
+_DROPPED_0017_RECO01 (17)
+_DROPPED_0018_RECO01 (18)
+_DROPPED_0019_RECO01 (19)
+_DROPPED_0020_RECO01 (20)
+_DROPPED_0021_RECO01 (21)
+WARNING: Disk 9 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 16 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 17 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 18 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 19 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 20 in group 3: state 0x6 mode 0x1 cannot be onlined
+WARNING: Disk 21 in group 3: state 0x6 mode 0x1 cannot be onlined
+NOTE: failed resync of disk group 3 disks
+NOTE: all disks already online or none could be onlined in disk group 3 disks
+ORA-15032: not all alterations performed
+ORA-15281: not all specified disks were brought ONLINE
+ORA-15284: ASM terminated ALTER DISKGROUP ONLINE
+ERROR: alter diskgroup RECO01 online disks in failgroup STORAGE2
+</code>
+**Lösung**:
+Platten neu mit dem Force Flag hinzufügen:
+<code sql>
+ALTER diskgroup REDO01 ADD failgroup STORAGE2 disk '/dev/oracleasm/disks/REDO0_S2' name REDO0S2 force;
+</code>
+siehe auch:
+  * How To Add Back An ASM Disk or Failgroup (Normal or High Redundancy) After A Transient Failure Occurred Or When The DISK_REPAIR_TIME Attribute Expired (10.1 to 12.1)? (Doc ID 946213.1)
+  * How to change the DISK_REPAIR_TIME timer after disk goes offline from failgroup (Doc ID 1404123.1)
 ----