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.8KViews0likes5CommentsSFHA Solutions 6.2: Symantec Storage plug-in for OEM 12c
Symantec Storage plug-in for OEM12c enables you to view and manage the Storage Foundation and VCS objects through the Oracle Enterprise Manager 12c (OEM), which has a graphical interface. It works with the Symantec Storage Foundation and High Availability 6.2 product suite. The Symantec Storage plug-in allows you to: SmartIO: manage Oracle database objects using SmartIO. Snapshot: create point-in-time copies (Storage Checkpoint, Database FlashSnap, Space-optimized Snapshot, and FileSnap) of Oracle databases using SFDB features Cluster: vew cluster-specific information. You can get the plug-in by downloading the attached file. For more information about installing and using the plug-in, download the attached Application Note. Terms of use for this information are found in Legal Notices.3.1KViews1like0CommentsMSDP 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.3KViews0likes2CommentsRestore Oracle Archive Logs
I need help to Restore Oracle11g Archive Logs. Running this command bellow i get errors: Connected to my target database and recovery catalog RMAN> RUN { 2> ALLOCATE CHANNEL ch0 3> TYPE 'SBT_TAPE'; 4> SEND 'BSA_SERVICE_HOST=192.168.63.189,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={87234189-7F27-466A-999A-814EA2F311EB},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\RAC-SW02-2861684627\SW02'; 5> allocate channel t1 type disk; 6> set archivelog destination to 'c:\'; 7> restore archivelog scn between 10756452257563 and 10756477117583; 8> release channel ch0; 9> } starting full resync of recovery catalog full resync complete allocated channel: ch0 channel ch0: SID=117 instance=SW022 device type=SBT_TAPE channel ch0: Symantec/BackupExec/1.1.0 sent command to channel: ch0 allocated channel: t1 channel t1: SID=1155 instance=SW021 device type=DISK executing command: SET ARCHIVELOG DESTINATION Starting restore at 18/10/12 channel ch0: starting archived log restore to user-specified destination archived log destination=c:\ channel ch0: restoring archived log archived log thread=2 sequence=3984 channel ch0: restoring archived log archived log thread=1 sequence=8039 channel ch0: restoring archived log archived log thread=2 sequence=3985 channel ch0: restoring archived log archived log thread=1 sequence=8040 channel ch0: reading from backup piece BE_9bnljhdc_1_1 channel CH0: ORA-19870: error while restoring backup component BE_9bnljhdc_1_1 ORA-19507: failed to retrieve sequential file, handle = "BE_9bnljhdc_1_1", parms = "" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from manager mÝdia layer, error text: BEError (0xe000fe30) A communications failure has occurred.1.8KViews0likes5CommentsUpgrade 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.Solved964Views0likes3Comments