Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How to check ZFS storage pool?

Avatar of buchli
buchliFlag for Switzerland asked on
Unix OSDatabases
4 Comments1 Solution1580 ViewsLast Modified:
We are running an Oracle database on Sun Solaris. This database has recently added a new SAS-RAID. There we use ZFS to be able to use a partition size of 19 TB.
During a new load of data into Oracle we got a ORA-01115: IO error reading block from file ....

After this we ran zpool status -xv and this showed us, there really were errors (see code).
4 files (filesize 30G) were corrupt.
The RAID does not show any errors.

Now, how can we make sure we will be informed earlier in the self healing ZFS? Is there any utility to check the disks? There was no information before we wrote data.

Thank you for any suggestions.

pool: ora5
 state: DEGRADED
status: One or more devices has experienced an error resulting in data
	corruption.  Applications may be affected.
action: Restore the file in question if possible.  Otherwise restore the
	entire pool from backup.
   see: http://www.sun.com/msg/ZFS-8000-8A
 scrub: none requested
	ora5         DEGRADED     0     0   178
	  c12t0d0s0  DEGRADED     0     0   178  too many errors
errors: Permanent errors have been detected in the following files:
Avatar of Brian Utterback
Brian UtterbackFlag of United States of America imagePrinciple Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers