Using nfs remote backup reports ORA-27054 error Solution

An error is returned when the production system needs to export data to an NFS directory.

Bash-3.00 $ expdp \ '/as sysdba \' directory = bak_data_pump_dir schemas = epm_ha dumpfile = epm_ha.dmp logfile = epm_ha.log

Export: Release 10.2.0.4.0-64bit Production on Friday, 21 May, 2010 16:09:25

Copyright (c) 2003,200 7, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/epmhis/DATA_PUMP_EPMHA1/epm_ha.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 2

Search for materials online. The solution includes setting event 10298 level 32, alter system set event = '000000trace name context forever, level 32' scope = spfile; patching: 10298, alternatively, set the parameters rw, bg, hard, nointr, rsize = 32768, wsize = 32768, tcp, vers = 3, timeo = 600, actimeo = 0 during the mount process. The tcp Parameter is unavailable on the solaris system.

Because it is a production system, try to use non-stop databases to solve the problem and mount it again.

1 umount directory

Umount/epmhis

2. Add parameters to the mount directory.

Mount-F nfs-o rw, hard, nointr, noac, vers = 3, rsize = 32768, wsize = 32768 IP Address:/epmhis/20100521

3. Export the file to the NFS Directory again.

Export: Release 10.2.0.4.0-64bit Production on Friday, 21 May, 2010 16:41:37

Copyright (c) 2003,200 7, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS". "SYS_EXPORT_SCHEMA_15": '/******** as sysdba' directory = bak_data_pump_dir schemas = epm_ha dumpfile = epm_ha.dmp logfile = epm_ha.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 355.2 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE
Master table "SYS". "SYS_EXPORT_SCHEMA_15" successfully loaded/unloaded
**************************************** **************************************
Dump file set for SYS. SYS_EXPORT_SCHEMA_15 is:
/Epmhis/DATA_PUMP_EPMHA1/epm_ha.dmp
Job "SYS". "SYS_EXPORT_SCHEMA_15" successfully completed at 17:56:28

No error is reported and the problem is resolved.

1 2 Next Page