Netbackup for Oracle RAC 11.2 and virtual names
Hi everyone. We are trying to configure our backups with NetBackup for a 2 node Oracle Database RAC 11gR2. Documentation about RAC configuration is very short, and I don't understand very well how to configure virtual names and how to use them in our backups policies so we can configure a single netbackup policy for all the nodes. Our Netbackup server is in a different network than Oracle RAC Listener is listening, so the vip names registered with the listener are cannot be reachable. Do I need to create another listener in a different network in order to add the new Virtual names? It seems weird for me, since netbackup doesn't connect directly with the database (but RMAN). Do you know any step by step guide or example to configure the virtual names? Regards
Copilot for oracle rac
I tried with unsuccessful attempts to put Copilot to work, I have a single Appliance 5230 2.7.3(Netbackup 7.7.3) whose role is both master,media the scenario is I wanted to configure DUMP and Sweep function mounting nfs share on one of 2 Oracle RAC node (11.2.0.4) run into issues "Database is in the wrong state (must be OPEN) for the requested action" however that is not the case. I tried many things to make it work with no success . I am at verge of giving this up, the documentation around this ok but there no white papers or case study with troubleshooting contents published. I had an idea wanted the SME to shed some insight on this, if this strategy is ok or lame. As I have nfs share from appliance mounted on one of the Oracle RAC node, the scheduled Rman script backs up the database to the nfs share , next I will creat standard policy for File system backup from nfs share. I know the essence of Oracle Copilot is lost with No SLP configured, however I will have something to work with until I fix this. Let me know what you folks feedback on this. Thanks much in advance for your time. Regard/Hissam EX: RAC1 node with nfs share 1 TB mounted on /oracle mp.
MSDP Storage unit is down during queue processing 2074
I am getting 2074 - MSDP storage unit down - during RMAN backups when scheduled queue processing kicks off. It's happened twice now and it correpsonds with scheduled queue processing. Kicks off at 6:30 PM on Friday and all of the jobs that started at the same time also died with a 2074 - disk volume is down. Windows 2008 R2 SP1 7.5.0.4 Media server with MSDP. I don't have a ticket open on it yet, too busy fighting tickets for RMAN and deduplication. There is plenty of free disk space and memory in the box Server is a DL360 G7 is 12 cores (24 with hyperthreading), 64GB of storage and 48GB of memory. Memory usage is not over 33GB. Has only happened during RMAN backups the two times - not a lot of other disk activity or backups jobs running when this has happened. DT
Oracle Backup Issue | NBU ver 6.5
Hi Guru's Recently had issue with an oracle backup, Sorry if the information given is insufficient but will try my best. As per what the structure is currently (Provided with the backup selection list in bracket): 1st DB Backup Runs (/usr/local/nb/scripts/oracle_rman_hot.uaedb1) 2nd RMAN Logs (Backup selection list is empty) 3rd DB Files ( / ) 4th OS Files ( / ) ========================= When a Oracle backup is triggered, the others gets triggered automaticly until it completes. And all these are in a different policy: e.g 1.DB Backup = (DB_ORA_UAE) 2.RMAN Logs = (UAE_RMAN_LOGS_DW) 3.DB Files = (DB_Files) 4.OS Files = (FS_UAE_UNIX_1) ========================== My concern is, how to make the rman log, db files and os files jobs to run automated upon triggering the DB backup? is it by script? On another note, DBA team informed me that all the backups in order, but i cant seem to see that in netbackup. Thank You Guru'sSQL/oracle database backup reporting & Partially successful flat file backup reports
Hi All If anybody is using or having any solution. We are looking for backup reports if it can be created by creating scripts in Netbackup version 6.5.6/7.1 on daily basis, i.e. daily backup report. with out any backup reporting tool 1. SQL database backup reporting (List of database backed up and which are not backed up) 2. Oracle database backup reporting (List of database backed up and which are not backed up) 3. Reporting of Partially successful flat file backup (List of data missed in partially successful flat file backup) Regards, Gurjeet Singh
Backup Oracle DB with SAN Media Servers on ALL RAC nodes.
Hi! Now I'm using configuration of an active backup RAC node (active policy, Disk Storage Unit (DSU)) + passive all other RAC nodes (inactive policy, no any DSU) with manual operations overcommutation DSU from the active to the any passive node and the activation of an inactive policy in the case of failure of the active Oracle RAC node. Each node has the role of the San Media Server (LAN-free-backup). It would be interesting to see if I can use the configuration "Failover VIP exists and backup is load balanced" to back up an Oracle database with the SAN Media Server at all nodes of the RAC cluster concurrently. Each node has a licenseSYMC Enterprise Client + SYMC Client APPLICATION AND DATABASE. On each node will be mounted separate DSU selected for backup his part of DB (allocate channel(s) per node). Such configuration is workable for us in case of Standard Client + LAN backup. There are two questions: A. Will this configuration workable, is there any pitfalls? B. Would not that be a violation of Enterprise Client license? In principle it ought not, as every San Media Server backup only part of a shared resource, but not other clients. Thank you!