cancel
Showing results for 
Search instead for 
Did you mean: 

Backup Oracle - Linux RH - Error - Please Help

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Database Version:

Sistema base datos ORACLE

Release 10.2.0.4.0

Thanx for your replies... I'll check.

stefan_koehler
Active Contributor
0 Kudos

Hello Martin,

it seems like you hit the bug 5146667.

Please be sure that the mount options are correct and then add the event that i mentioned above.

Regards

Stefan

Former Member
0 Kudos

Hello Stefan,

I must add the entry:

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

at the init.ora ?

Regards,

MJ

stefan_koehler
Active Contributor
0 Kudos

Hello Martin,

correct .. you have to add this additional event to your existing events.

Sapnote #596423 describes howto set these events.

Regards

Stefan

Former Member
0 Kudos

NFS mount is not supportoed for sapbackup

see sapnote #156704 - NFS mount is no longer required for sapbackup

Answers (2)

Answers (2)

sunny_pahuja2
Active Contributor
0 Kudos

Hi Martin.

Check SAP Note 7721 - ORACLE error 1580 during online backup

Thanks

Sunny

Former Member
0 Kudos

Dear Sunny,

The whole directory have right permissions... the problem is the check tah oracle makes regarding the mount mode, but the requests that appear in the alertSID.log are in the mount command...

Thanx!

Former Member
0 Kudos

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

Former Member
0 Kudos

One more thing... the BRARCHIVE seems to run without problems...

Thanx one more time...