On 04/30/2017 06:49 PM, De DBA wrote:
I've seen such errors, but on normal filesystems/ASM. They were at that time accompanied by IO errors on the underlying disk device due to failing disks.
I expect you have already ruled out hardware failure, so I would at this point investigate the ZFS volume. Has anyone changed parameters on the underlying volume, resulting in the file becoming read-only, such as setting the readonly flag on the volume?
Also I suspect that merging a snapshot would change the file addressing space, and confuse the database if done with the file open. Not sure whether this is actually the case, or ZFS will handle this gracefully.