Shulou(Shulou.com)05/31 Report--

This article focuses on "how to solve the database alert error ORA-00202", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "how to solve the database alert error ORA-00202"!

Analysis of ideas:

1. Database downtime is found. Check the alert log and find that the control file appears as follows: Icano error.

Thu Apr 11 06:40:14 2019

WARNING: Read Failed. Group:2 disk:1 AU:675 offset:16384 size:16384

WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 260 in group [2.3852408873] from disk DATA_0001 allocation unit 675 reason error; if possible, will try another mirror side

Errors in file / u01/app/oracle/diag/rdbms/jsswgsjk/jsswgsjk1/trace/jsswgsjk1_ckpt_93628.trc:

ORA-00202: controlfile:'+ DATA/jsswgsjk/controlfile/current.260.998936297'

ORA-15081: failed to submit an I/O operation to a disk

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 1382432

Additional information:-1

Thu Apr 11 06:40:15 2019

WARNING: Read Failed. Group:2 disk:1 AU:675 offset:65536 size:16384

2. Check the ASM log

-disk timeout occurs. Start dimountOCR

Thu Apr 11 06:39:29 2019

NOTE: process _ b000_+asm1 (31654636) initiating offline of disk 0.3671375779 (OCR_0000) with mask 0x7e in group 3

NOTE: process _ b000_+asm1 (31654636) initiating offline of disk 1.3671375780 (OCR_0001) with mask 0x7e in group 3

NOTE: process _ b000_+asm1 (31654636) initiating offline of disk 2.3671375781 (OCR_0002) with mask 0x7e in group 3

NOTE: checking PST: grp = 3

GMON checking disk modes for group 3 at 13 for pid 67, osid 31654636

ERROR: no read quorum in group: required 2, found 0 disks

NOTE: checking PST for grp 3 done.

NOTE: initiating PST update: grp = 3, dsk = 0/0xdad4bfa3, mask = 0x6a, op = clear

NOTE: initiating PST update: grp = 3, dsk = 1/0xdad4bfa4, mask = 0x6a, op = clear

NOTE: initiating PST update: grp = 3, dsk = 2/0xdad4bfa5, mask = 0x6a, op = clear

GMON updating disk modes for group 3 at 14 for pid 67, osid 31654636

ERROR: no read quorum in group: required 2, found 0 disks

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.