Where does Veeam enumerate Oracle Databases

VMware specific discussions

Where does Veeam enumerate Oracle Databases

Veeam Logoby EvoTom » Wed Jan 27, 2016 8:45 am

I am am trying to backup our Oracle database servers and is mostly working. For a few VMs I am getting a warning saying "Failed to retrieve Oracle database (SID: asdf) settings required to perform archived logs backup. Oracle database instance state is not valid for property collection."

This SID that it is finding i think was a test database that has since been removed. I does find the live database on the server and backs that up fine. I was just wondering how I remove the errogenous entry. I've looked in the /etc/oratab file and the pfiles and spfiles in the dbs directory.

These are Linux VM's running CentOS 6.7.
EvoTom
Enthusiast
 
Posts: 25
Liked: never
Joined: Wed Jul 11, 2012 10:18 am

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby foggy » Wed Jan 27, 2016 11:16 am

You can clean up obsolete databases using these instructions.
foggy
Veeam Software
 
Posts: 14741
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby EvoTom » Wed Jan 27, 2016 11:23 am

Thanks but do you have instructions for Linux VMs?
EvoTom
Enthusiast
 
Posts: 25
Liked: never
Joined: Wed Jul 11, 2012 10:18 am

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby foggy » Wed Jan 27, 2016 3:56 pm

No, but you could check inventory and oratab file and also each home registered there (specifically dbs folders) for an orphaned records/files.
foggy
Veeam Software
 
Posts: 14741
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby dellock6 » Wed Jan 27, 2016 9:34 pm

Have you checked the Oracle Inventory where all ORA_HOMES are registered? Maybe you have different versions, each of them with a different ORA_HOME. Look into /etc/oraInst.loc and then $ORA_INV/Contents_XML/inventory.xml
Luca Dell'Oca
EMEA Cloud Architect @ Veeam Software

@dellock6
http://www.virtualtothecore.com
vExpert 2011-2012-2013-2014-2015-2016
Veeam VMCE #1
dellock6
Veeam Software
 
Posts: 5047
Liked: 1330 times
Joined: Sun Jul 26, 2009 3:39 pm
Location: Varese, Italy
Full Name: Luca Dell'Oca

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby fernando.laguna » Fri Sep 23, 2016 7:09 pm

Guys, I'm having the same issue on a Linux VM, any one has an idea how to solve it?
fernando.laguna
Veeam Software
 
Posts: 3
Liked: never
Joined: Mon Nov 09, 2015 11:44 am
Full Name: Luis Fernando Laguna

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby foggy » Thu Sep 29, 2016 3:01 pm

Luis, have you checked places mentioned in two previous posts?
foggy
Veeam Software
 
Posts: 14741
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby manitowoc » Wed Jan 18, 2017 2:40 pm

Hi all,

Did you find a solution for this problem?
I have the same error while backupping a SAP system on SLES 11, and Oracle 12.1
I verified all these files, did a relink and lsinventory but the problem persists.

Thanks.
Regards
manitowoc
Novice
 
Posts: 4
Liked: never
Joined: Tue Dec 13, 2016 11:00 am

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby Frenkenfoerder » Fri Mar 03, 2017 9:47 am

Any solutions?
Same here...
Frenkenfoerder
Lurker
 
Posts: 1
Liked: never
Joined: Fri Mar 03, 2017 9:42 am
Full Name: Frank Scheliga

Re: Where does Veeam enumerate Oracle Databases

Veeam Logoby foggy » Fri Mar 03, 2017 1:57 pm

Hi Frank, I recommend contacting support with this. In case of SAP is installed, Veeam B&R v9 could incorrectly detect its backup files as separate databases, though this should be already addressed in v9.5.
foggy
Veeam Software
 
Posts: 14741
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: Exabot [Bot] and 15 guests