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.
SFHA 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.
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. DTRestore Oracle Archive Logs
I need help to Restore Oracle11g Archive Logs. Running this command bellow i get errors: Connected to mytarget databaseand 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.
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's