Oracle ZFS Storage Appliance: Error While Trying To Perform An SMU Snap Backup.

Asset ID:	1-72-2132140.1
Update Date:	2016-11-21
Keywords:

Solution Type Problem Resolution Sure

Solution 2132140.1 : Oracle ZFS Storage Appliance: Error While Trying To Perform An SMU Snap Backup.

Applies to:

Oracle ZFS Storage ZS3-2 - Version All Versions and later
Oracle ZFS Storage ZS3-4 - Version All Versions and later
Oracle ZFS Storage ZS3-BA - Version All Versions and later
Oracle ZFS Storage ZS4-4 - Version All Versions and later
Oracle ZFS Storage Appliance Racked System ZS4-4 - Version All Versions and later
7000 Appliance OS (Fishworks)

Symptoms

Receiving an error while trying to perform an SMU snap backup for ZFS. The share that is generating this error is a share presented from the ZFS appliance.

--- TASK FAILED ---

File /oracle/xxx/2016_0x_x0 from Oracle Database xxx is using local storage. All database files must use one or more appliance shares

In previous versions before SMU 1.2 There was an error message:

Operation failed
@ > --- TASK FAILED ---
@ > File /oracle/ora_xxxxx from application Oracle Database zfstest in local filesystem
@ That was fixed in Bug 18383411 - File in local filesystem message not very informative
@
@ The fix was to changed the error to :
@
@ --- TASK FAILED ---
@ File /oracle/xxx/2016_03_30 from Oracle Database xxx is using local storage. All database files must use one or more appliance shares

Cause

There are two issues that can cause this issue.

1) SMU (Snap Management Utility) found a database file that is in a local filesystem and not in a ZFSSA share.

2) SMU (Snap Management Utility) Does not support the use of NFS4 mounts.

Solution

1) Make sure all data base files are stored on the appliance before using Snap Management Utility.

The files that SMU errors on can be found in either the SMU or backup logs.

The Snap Management Utility does not run on the array itself.

2) If all the database files are in the array share, check the way it is shared.

Get the /etc/fstab file if the DB host is linux.

If it shows an entry with the nfs version defined such as:

192.xxx.xxx.xxx:/export/backup/archive/ARCHIVE1 <nfs4> rw,bg,hard,nointr,noac,rsize=1000000,wsize=1000000,timeo=600 0

If this is the case change it to:

192.xxx.xxx.xxx:/export/backup/archive/ARCHIVE1 nfs rw,bg,hard,nointr,noac,rsize=1000000,wsize=1000000,timeo=600 0

This sets it to use NFS version 3.

If the client is Solaris from the mount_nfs man page:

If the NFS server does not support the client's default maximum, the next lowest version attempted until a matching version is found.

At this point, remount the file system and retest.

References

<BUG:23040189> - ERROR WHILE TRYING TO PERFORM AN SMU SNAP BACKUP FOR ZFS.

Attachments

This solution has no attachment