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? Regards710Views0likes1CommentBackups for Oracle RAC running twice
Hi All, We having issues with Oracle RAC invirovment backups, it's always dublicating. It was working, and did load balance between nodes, but i did created new policy with same configuration and now it's running twice. Client and server running on 8.0 NetBackup version. Attaching script and configuration screenshotsSolved1.3KViews0likes4CommentsCopilot 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.1.8KViews0likes5CommentsMSDP 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. DT806Views0likes5CommentsRMAN CROSSCHECK EXPIRED EXISTING BACKUPPIECE.
Hi expert, I already search this forum and cannot find topic matching this case. Recently we have found the problem that some of backuppiece was expired after running weekly crosscheck script. Environment Master Server: netbackup Media Server: cvgdb01_back, cvgdb02_back Oracle Client: cvgdb01_back, cvgdb02_back Option Used: SSO, OracleClient, Online backup using rman archivelog mode and remote recovery catalog Retention: level9 infinite for netbackup , recovery window of 90 days for rman recovery catalog We use 'Failover VIP is not available and backup is load balanced, simple script with manual policy failover' from Symantec Document to protect the RAC database. I already open case (03367265) to support but no luck. Weekly Crosscheck script is below. $RMAN target $constr catalog $cat msglog $RMAN_LOG_FILE append << EOF allocate channel for maintenance type 'sbt_tape'; delete noprompt obsolete; delete noprompt obsolete orphan; crosscheck backupset of database; crosscheck backupset of controlfile; crosscheck backupset of archivelog all; EOF " Some backup piece that was expired. BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 1167774 2.00M SBT_TAPE 00:00:50 16-JAN-13 BP Key: 1167782 Status: EXPIRED Compressed: NO Tag: TAG20130116T222337 Handle: al_10324_1_804897076 Media: List of Archived Logs in backup set 1167774 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 4326 166048694612 16-JAN-13 166048827449 16-JAN-13 Used bplist to search backupid. /usr/openv/netbackup/bin/bplist -C cvgdb02_back -Listpolicy -Listseconds -t 4 /al_10324_1_804897076 | awk '{print $14}' 1358350282 Used bpimagelist to search mediaid. /usr/openv/netbackup/bin/admincmd/bpimagelist -media -l -option COMPLETE_COPIES -backupid cvgdb02_back_1358350282 | awk '/FRAG/ {print $9}' 000125 This is occur on production database when I try to redirect restore production RAC database to development database server so please help us!!! Thanks, NawaminSolved6.3KViews0likes2CommentsUpgrade 6.5 to NETBACKUP 7.5
In my LIVE Env, i have SUN machine SPARC Entry Server. NetBackup 6.5 master/media on it. Requirement is to upgrade it to 7.5 Master/Media and clients ORACLE RMAN Backups on solaris machines. kindly correct me if i am wrong. the steps i will follow are: 1) Download NBU 7 media 2) down NBU Services on live machine 3) Apply 7.0, up Netbackup services. 4) download 7.5 media 5) Apply 7.5 and up services. ------------------------------------------------ Master Media upgraded. now to upgrade the client for 7.5. steps needed. HOT backups are configured for ORACLE RMAN. Does linking again needed to be performed ? ? ?Solved2KViews0likes6CommentsOracle 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's1.1KViews2likes5CommentsConfigure SFRAC on Windows
Hi, I am trying to configure SFRAC on Windows 2008 R2. I didn't find a solution of SFRAC for windows. I know that SFWHA is active/passive. But SFRAC is active/active, and it uses CVM rather than VxVm. I wonder if there is anyway can make the Oracle DB and shared disks active/active on Windows? Thanks a lot.Solved964Views0likes3CommentsSQL/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 Singh611Views0likes1CommentSFHA Solutions 6.0: Use Cases for Veritas Storage Foundation for Oracle RAC
This HOWTO article provides use cases that demonstrate how to achieve flexible deployment of Oracle RAC databases with SF Oracle RAC, integrate with existing technologies in your environment, and manage cross-platform data migration challenges. Here are some use cases for Storage Foundation for Oracle RAC: Deploying Oracle RAC databases on Veritas CFS and Oracle ASM Setting up administrator-managed databases and policy-managed Oracle RAC databases in an SF Oracle RAC cluster Using Virtual Business Services in multi-tier environments with SF Oracle RAC in the database tier Using Oracle Data Guard in SF Oracle RAC environments for disaster recovery Cross-platform Oracle data migration using Symantec CVM-VVR replication technology and Oracle transportable tablespace http://www.symantec.com/docs/HOWTO75087292Views0likes0Comments