on 10-20-2009 4:18 AM
Hi gurus,
Im trying to run an FULL ONLINE backup to an NFS filesystem an getting this error:
BR0301E SQL error -1580 at location BrCtlCopy-1, SQL statement:
'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/CDP/sapbackup/cntrlCDP.dbf''
ORA-01580: error creating control backup file /oracle/CDP/sapbackup/cntrlCDP.dbf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
BR0320E Copying of control file to /oracle/CDP/sapbackup/cntrlCDP.dbf failed
BR0314E Collection of information on database files failed
At the ALERT.LOG:
/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/CDP/sapbackup/cntrlCDP.dbf'
Tue Oct 20 00:03:43 2009
WARNING:NFS file system /oracle/CDP/sapbackup mounted with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
ORA-1580 signalled during: /* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/CDP/sapbackup/cntrlCDP.dbf'...
On the host /etc/exports
/sapbackup *(rw,sync,no_wdelay,insecure_locks,no_root_squash)
On the DB Server:
mount -t nfs 132.145.161.50:/sapbackup /oracle/CDP/sapbackup/ -o rw,bg,hard,nointr,tcp,vers=3,timeo=300,rsize=32768,wsize=32768
Can anyone help me please?
Thanx a lot!!!
Regards
MJ
Hello Martin,
which oracle version do you use? There are several known bugs for these checks.
You can disable the mount point checks with the event "10298 trace name context forever, level 32" .. this works for 10gR2.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Martin.
Check SAP Note 7721 - ORACLE error 1580 during online backup
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Additionally...
The filesystem permissions are 777. I can create files at the mounted FS using the orasid and sidadm user...
Hope somebody helpme...
Thanx again
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.