Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle backup failure

SOLVED
Go to solution
jaivinder
Frequent Advisor

Oracle backup failure

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.
3 REPLIES
Luk Vandenbussche
Honored Contributor

Re: Oracle backup failure

What are the mount options.

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

Re: Oracle backup failure


/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.
TwoProc
Honored Contributor
Solution

Re: Oracle backup failure

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.
We are the people our parents warned us about --Jimmy Buffett