oracle db backup on hp dp fails

[iinfi1]

hi

we have a oracle 10.2 db running on a two node cluster (RAC). we use data protector 6.0 to backup the db.

frequently the data protector throws errors saying


[code]
[Major] From: OB2BAR_DMA@db-odbs1.db.ae "dbgold" Time: 9/1/2010 11:16:11 PM
Cannot get information on file '/var/opt/omni/tmp/ctrl_dbgold.dbf' Error: 2.

[Normal] From: OB2BAR_DMA@db-odbs1.db.ae "dbgold" Time: 9/1/2010 11:16:48 PM
Completed OB2BAR Backup: db-odbs1:dbgold DP Managed Control File Backup "Oracle8"

[Major] From: ob2rman@db-odbs1.db.ae "dbgold" Time: 09/01/10 23:16:48
Backup of Data Protector managed control file backup failed.
[/code]


can someone throw more light on this plz?

[Assaf Feuerstei]

did you try checking /var/opt/omni/log/oracle8.log and /var/opt/omni/log/debug.log for possible causes...?

does this db works ok? sounds a little bit like filesystem problem but check the logs first...

[iinfi1]

somehow i missed your reply. apologies
i will check this and update you

[crimb]

Well - I ran in the same problem and it is definitly an oracle problem.

The point is if you commit a

alter DATABASE BACKUP CONTROLFILE TO '/usr/omni/tmp/ctrl_.dbf' REUSE;"

and this is what HPDP scripts do here,

in an RAC envirnment, you do not know on which RAC-node this command will be executed.

Actually with Oracle 11g R2 ( not R1) the Oracle Documentation changed and said, that if you want to do a DATABASE BACKUP CONTROLFILE on a RAC, you need to use a shared storage.

And that's the way to solve the problem !

Cheers,

Chrimb