topic Re: Oracle backup failure in Operating System - HP-UX

Oracle backup failure

jaivinder — Mon, 27 Aug 2007 06:41:36 GMT

Hi Gurus,

I am having problem regarding the oracle backup.In my case i am trying to export the oracle dump file to a directory which is NFS exported.I am getting following errors while exporting the dump file to that directory.
bash-2.05b$ expdp gmlc/gmlc123 full=y directory=backup_dir dumpfile=gmlc_16Aug.dmp logfile=gmlc_backup16Aug.log
Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 16 August, 2007 15:54:55
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/data/dbBackup/gmlc_16Aug.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

But when i am exporting the dmp file to any other directory like /tmp or /home/oracle i am able to do it.The options of the exported fs are as following

/data -proto=udp,intr,timeo=120,retry=3 nfsPkg:/data_mount

Please suggest.

Re: Oracle backup failure

Luk Vandenbussche — Mon, 27 Aug 2007 06:55:42 GMT

What are the mount options.

Can you create file with the oracle user on the nfs filesystem?

Re: Oracle backup failure

jaivinder — Mon, 27 Aug 2007 06:59:44 GMT

/dev/vg01/datalvol /data_mount vxfs delaylog 0 2

I am able to create but,the problem is with the /etc/auto.direct file options.

Re: Oracle backup failure

TwoProc — Mon, 27 Aug 2007 11:32:58 GMT

I hate asking the obvious, but is this just a file permissions issue?
Can the user doing the export create a file where the destination directory is?

Presuming it's not just write permissions, maybe you can fool the Oracle process...

Try using a named pipe to get this done. This is kind of a long shot, but only takes a couple of minutes to setup and try.

First make a named pipe in /var/tmp
> mknod /var/tmp/mypipe p

list it and make sure it's there with a "p" as the first character:
> ls -al /var/tmp/mypipe
prw-r--r-- 1 myuser mygroup 0 Aug 27 11:19 mypipe

now create job to move data from the pipe to the file on the nfs mountpoint.

> dd if=/tmp/mypipe of=/data/mydmp.dmp &

Now, run your export and give it the name of /tmp/mypipe as your destination dump file.

When your export is finished (or dies with error) the "dd" backupground job will self-terminate. At this point you'll be able to see if you've managed to "fool" the export tool about the nfs mount point.

When you're done, you can remove the /var/tmp/mypipe named pipe file with the usual rm command.