Sun Storage 7000 Unified Storage System: Issue With Shadow Migration. Oracle DB ORA-01578 ORA-01110 errors

(Doc ID 1469932.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle ZFS Storage Appliance Racked System ZS4-4 - Version All Versions and later
Sun Storage 7410 Unified Storage System - Version All Versions and later
Sun Storage 7210 Unified Storage System - Version All Versions and later
Sun Storage 7310 Unified Storage System - Version All Versions and later
Sun Storage 7720 Unified Storage System - Version All Versions and later
7000 Appliance OS (Fishworks)

Symptoms

We have initiated a shadow copy to Sun storage :adc07stor21 from a netapp filer and it got finished @ below time

 

How to I diagnose and fix this ORA-01578 error?

Answer: 
An ALL ZEROS block corruption is described in Note 1545366.1 ; this is a physical corruption (Note 840978.1) and as such is resolved by either applying media recovery or recreating the segment (Note 1578.1)

Since you are getting a ORA-01578 running Oracle on a personal computer (Windows), it's a safe bet that you have a disk crash.  Oracle is intended to run in any platform as it was designed; this includes Windows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms