Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Absent Member.
Absent Member.
2842 views

oracle db backup on hp dp fails

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?
Tags (1)
0 Likes
3 Replies
Absent Member.
Absent Member.

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...
0 Likes
Absent Member.
Absent Member.

somehow i missed your reply. apologies
i will check this and update you
0 Likes
Absent Member.
Absent Member.

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.