dba:oracle_rac_12c_backup_recovery
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende ÜberarbeitungNächste ÜberarbeitungBeide Seiten der Revision | ||
dba:oracle_rac_12c_backup_recovery [2016/09/21 16:03] – [ASM SPFile geht verloren] gpipperr | dba:oracle_rac_12c_backup_recovery [2018/05/03 14:09] – [Label einer Platte geht verloren] gpipperr | ||
---|---|---|---|
Zeile 349: | Zeile 349: | ||
+ | |||
+ | |||
+ | ---- | ||
==== Label einer Platte geht verloren ==== | ==== Label einer Platte geht verloren ==== | ||
Zeile 468: | Zeile 471: | ||
</ | </ | ||
+ | |||
+ | === Problem DISK_REPAIR_TIME Attribute Expired | ||
+ | |||
+ | als sys as syasm | ||
+ | <code sql> | ||
+ | |||
+ | SYS@+ASM2-tng1db02> | ||
+ | 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 | ||
+ | </ | ||
+ | |||
+ | 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 | ||
+ | |||
+ | </ | ||
+ | |||
+ | **Lösung**: | ||
+ | |||
+ | Platten neu mit dem Force Flag hinzufügen: | ||
+ | <code sql> | ||
+ | ALTER diskgroup REDO01 ADD failgroup STORAGE2 disk '/ | ||
+ | </ | ||
+ | |||
+ | 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) | ||
---- | ---- | ||
Zeile 505: | Zeile 568: | ||
* Alle Diskgroup mit "alter diskgroup all mount" wieder anhängen, alle Plattenfehler heben | * Alle Diskgroup mit "alter diskgroup all mount" wieder anhängen, alle Plattenfehler heben | ||
* Spfile neu erzeugen <code bash> | * Spfile neu erzeugen <code bash> | ||
+ | * Cluster wieder stoppen <code bash> $GRID_HOME/ | ||
+ | * Cluster wieder starten <code bash> $GRID_HOME/ | ||
Zeile 512: | Zeile 577: | ||
==== Quellen ==== | ==== Quellen ==== | ||
+ | |||
+ | |||
+ | Netz: | ||
+ | * https:// | ||
Support Portal | Support Portal |
dba/oracle_rac_12c_backup_recovery.txt · Zuletzt geändert: 2018/05/03 15:34 von gpipperr