Forum Discussion

George_Dicu's avatar
10 years ago

Oracle Intelligent Backup in Windows Cluster

Hello,

So I got 7.6.0.3 NBU env., 1 master server and 4 media servers all windows standard 2008 R2.

  • I have to backup oracle dbs, but this is a cluster set-up with 2 nodes, and I had set-up the policy with Instanges group, when I addded the credentials and hit discover instances, i found those 2 servers and register both DBs. So the policy is set-up with Instances Group and as selection with Whole_database.

But in this situation, when the backup starts, of course it starts on both servers which is not ok.

One is passive one its active so it cannot back up them in the same time, actually it will never backup them in the same time, it will always be the passive node backup.

  • Then I set-up 2 policies and I register those dbs sepparatelly

But in this sittuation it`s still not correct, because I do not know how to set-up policy time-frame and I have no ideea when and which node is passive.

What is the perfect cfg for backup oracle in a windows cluster?

//George

  • Can you explain your comment xao: the "oip backup cannot handle cluster oracle". Because it works perfectly where I am , but then I'm Solaris + oracle cluster. I'm interested to get to the bottom of this...maybe its windows cluster that is the issue.Thanks, Jim.

  • Gonna give a guess.

     

    Since this features relies on the client passing back information about the DB on the host to the master, i would say you could change the client name to the virtual / clustered name of Oracle. You might then be able to register the database with the virtual name instead of the host names. Do it for both nodes.

    • So I commented out the nodes from host files and then let just the cluster virutal name, ip and fqdn.

    then bpclntcmd -clear_host_chache of course,

    At discovery it still find the instances with host property pointing to nodes hostname.

    • I changed the host property inside instance group, but ... this is not working at all, all sorts of errors, like 25,6, and invalid error number(1073741502), which point out, this is not the way..

    //George

  • Sorry, I should have been more specific when I said client name, i meant NetBackup client name (NetBackup Management -> host properties -> clients > ). Leave your host files (don't know why you're using host files in Windows environment) alone.

     

  • Oh, that is a strange approch, why should I change the NBU Client Name into cluster virtual node name?

    The ip still points out to the phisical node.

    But i did it and at Discovery the host property has the same host, the phisical ones.

    What do you mean, why I use host files, I use it to let NBU know whici ip corelates with which hostnames and fqdn`s.

     

    //George

  • Its not common practice, in some configurations involving clusters it done for SQL for instance.

     

    If you're running Windows you would usually be having a DNS environment so host files would not be required. That is what I meant.

  • Coming from an oracle cluster angle , part of the cluster resource group for the instance includes an ip address....the db runs on a different node? Then the address in the resource group moves with it, therefore the db is always 100% running clustered on the address that is part of this resource groups resources. Hence the only sensible client name to use in netbackup is the address that is part of the resource group. It has worked in cluster since as long as I can remember and is even better using OIP/ 

    Just need someone to translate these terms into ms cluster terms, unless of course it doesnt work in the same manner.

    Jim

  • Found the issue:

    Oracle Intelligent Backup cannot handle cluster oracle.

    I must do backups in traditional way, which I do not know.

    Do you have some good Netbackup Windows Oracle backup trainings/videos?

  • Can you explain your comment xao: the "oip backup cannot handle cluster oracle". Because it works perfectly where I am , but then I'm Solaris + oracle cluster. I'm interested to get to the bottom of this...maybe its windows cluster that is the issue.Thanks, Jim.