oracle导出到nfs未响应,ORACLE不能使用NFS卷

Subject:

ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS

Note:387700.1

Type:

PROBLEM

Last Revision Date:

12-DEC-2007

Status:

MODERATED

This document is being delivered to you via Oracle Support'sRapid Visibility(RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1

This problem can occur on any platform.

Symptoms

ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS

Starting Control File and SPFILE Autobackup at 01-AUG-06

RMAN-00571: ===========================================================

RMAN-00569: ERROR MESSAGE STACK FOLLOWS

===========================================================

RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_2

channel at 08/01/2006 16:43:49

ORA-19504: failed to create file

"/u60/rman/nitfq/cntrl/nitfq_c-4256538111-20060801-02"

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 2

Cause

From Oracle 10G R2 , Oracle checks the options with which a NFS mount is mounted on the filesystem. and this

is done to ensure that no corruption of the database can happen as incorrectly mounted NFS volumes can result in data corruption.

There are no single set of NFS mount options that work across all Oracle platforms

Please ensure that you have the proper mount options specified by the NAS vendor /Vendor user guide

The exact checks used for an NFS mounted disk vary between platforms but in general the basic checks will include

checking that:

a) The mount table (eg; /etc/mnttab) can be read to check the mount options

b) The NFS mount is mounted with the "hard" option

c) The mount options include rsize>=32768 and wsize>=32768

d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.

Please refer the section -- NFS Mount Options in Oracle® Database Installation Guide10g Release 2 (10.2)

If you have ensured that the mount options are appropriate and still getting the errors then you are encountering symptoms as in Bug 5146667 Fixed In Ver: 11.0. 0.0

And this is found reproducable on Solaris and AIX

.

Solution

To implement the solution, please execute the following steps:

From the erorrs that we see from the RMAN stack this looks like Bug 5146667

This behaviour has been observed on Solaris and AIX Platform.

WORKAROUND:

As suggested in the bug the workaround recommended is to use the Event 10298.

1) set the Event 10298 in the init file

event="10298 trace name context forever, level 32"

if you are using the spfile then the following can be done

SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile ;

Once you set the above parameter restart the instance check as follows

SQL> select name, value from v$parameter where name = 'event';

NAME VALUE

---------- ------------------------------------------------------------

Event 10298 trace name context forever, level 32

1 row selected.

Then try the backups again

2) PATCH

Check if a one off patch for 10.2.0.1 for your platform is available

Please follow next steps to download and test it :

1. Login to Metalink

2. Go to Patches and Updates -> Simple Search

3. Enter patch number 5146667 and platform you are on ( your version of OS )

4. Download the patch

5. Read the README file for installation instructions and test it to see if it fixes your problem

Once the patch is shown as applied - you can do away with the event

References

Bug 5146667- ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS

Errors

failure of %s command on %s channel at %sfailed to create file %sNFS file system where the file is created or resides is not mounted with correct options"