Problem with agent for oracle on Windows server
Hi, Recently we have installed on Backup exec server the oracle agent, and we have a problem when we want install it on the oracle server. So, when we configure the backup exec agent, oracle tab, we received this error: Have you an idea for this problem ? When we connect to the database with sqlplus, we have not any problem. Thanks1.7KViews6likes11CommentsOracle restore: ORA-19573: cannot obtain exclusive enqueue for datafile
**** Moved to new discussion from:https://www-secure.symantec.com/connect/forums/reg-oracle-db-backup**** i am getting the below error when try to restore ...kindly help me com09:oracle # /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh com09:oracle # cat database_restore.sh.out Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== started on Sun Aug 17 16:39:17 UTC 2014 ==== RMAN: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0/bin/rman ORACLE_SID: plxdb ORACLE_USER: oracle ORACLE_HOME: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0 Last login: Sun Aug 17 16:38:47 UTC 2014 Recovery Manager: Release 11.2.0.1.0 - Production on Sun Aug 17 16:39:17 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: PLXDB (DBID=3747984712) using target database control file instead of recovery catalog RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> allocated channel: ch00 channel ch00: SID=28 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020) allocated channel: ch01 channel ch01: SID=129 device type=SBT_TAPE channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013061020) Starting restore at 17-AUG-14 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00005 to /opt/PlexView/Oracle/ora02/oradata/plxdb/audit_data.dbf channel ch00: restoring datafile 00006 to /opt/PlexView/Oracle/ora02/oradata/plxdb/cfma01.dbf channel ch00: restoring datafile 00008 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_indx.dbf channel ch00: restoring datafile 00009 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_data.dbf channel ch00: restoring datafile 00010 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_indx.dbf channel ch00: reading from backup piece bk_84_1_855851605 channel ch01: starting datafile backup set restore channel ch01: specifying datafile(s) to restore from backup set channel ch01: restoring datafile 00001 to /opt/PlexView/Oracle/ora02/oradata/plxdb/system01.dbf channel ch01: restoring datafile 00002 to /opt/PlexView/Oracle/ora02/oradata/plxdb/sysaux01.dbf channel ch01: restoring datafile 00003 to /opt/PlexView/Oracle/ora02/oradata/plxdb/undotbs01.dbf channel ch01: restoring datafile 00004 to /opt/PlexView/Oracle/ora02/oradata/plxdb/users01.dbf channel ch01: restoring datafile 00007 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_data.dbf channel ch01: reading from backup piece bk_85_1_855851606 released channel: ch00 released channel: ch01 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/17/2014 16:39:27 ORA-19870: error while restoring backup piece bk_84_1_855851605 ORA-19573: cannot obtain exclusive enqueue for datafile 6 RMAN> RMAN> Recovery Manager complete. Last login: Sun Aug 17 16:38:47 UTC 2014 Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== ended in error on Sun Aug 17 16:39:27 UTC 2014 ==== com09:oracle # regards, GiriSolved13KViews2likes6CommentsBare metal restore with Oracle client
We are currently testing our backup strategy with Symantec and so far so good. Since last week I have been trying to do a bare metal restore of an oracle server. this is what I did so far: Convert original machine to Virtual machine Point in Time. Rename server + assign new IP + new SID remove oracle broken database instance (oradim -delete) Create new instance with same SID (oradim -new) generate new password file (orapwd file=path\pwdsid.ora password=<password>) change DBID to the original (rman: SETDBID<dbid ID>) Reconfigure backup exec agent utility, restore trust, reconfigure oracle instance and database access. Add 'new' virtual server to backup exec interface and configure password create restore job in old 'broken' server that uses last available control file. restore to a different Oracle server, with the server name, correct log on account and database log on account. when I execute this job i get the RMAN error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 11/18/2013 14:47:45 ORA-27191: sbtinfo2 returned an error when I enable server side debugging this is the last entry i see in my log: BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.725 [engapi] - Record - 7 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.725 [engapi] - resource - Oracle-Win::\\mlinetstsvr02-vm.itnet.hosp\mlineTEST BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - account name - BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - account ID - 00000000-0000-0000-0000-000000000000 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource ID - 00000000-0000-0000-0000-000000000000 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource Container ID - 00000000-0000-0000-0000-000000000000 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - server - mlinetstsvr02-vm.itnet.hosp BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - server ID - 00000000-0000-0000-0000-000000000000 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource OS ID - 39 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource OS Ver - 0 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource Type - 14 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - resource Sub Type - 2 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - flags - 0x5 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - update date time - 11/18/2013 1:47:07 PM BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - No password Found BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [engapi] - ***************************************************************** BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [server] - Removing 'MLINETSTSVR02.itnet.hosp Restore 00060' from status update list BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.726 [server] - Updating status for: 'MLINETSTSVR02.itnet.hosp Restore 00060' (0x18 0x0) BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.727 [server] - Status for: 'MLINETSTSVR02.itnet.hosp Restore 00060' updated BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.730 [server] - Merging of BE / VSR Job Logs not necessary for this Type of Job BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.730 [server] - EndJob() criticalVolumeError - 0x0 BENGINE: [11/18/13 14:47:55] [9512] 2013-11-18T14:47:54.730 [server] - Ending job 'MLINETSTSVR02.itnet.hosp Restore 00060' with error status (-536870080) to clarify, mlinetstsvr02 is the original server that is broken. mlinetstsvr02-vm is the new machine. Does anybody have any idea how I can resolve this? Or is there a good step by step guide to do this? I used the administrators guide but this is not that clear imho.Solved1.4KViews2likes5CommentsOracle RAC Backup
Master and SAN Media servers -NetBackup 7.0 Master - Windows Media servers - RedHat Linux (SAN Media Servers) I have a RAC of 4 nodes . All the nodes are SAN Media servers . I dont have any cluster software like VCS or RedHat Cluster . Now i need to configure the backups such a way that all the nodes should send the backup to same Storage Unit . Is it possible to create a app cluster for NetBackup Media server without any clustering software . If we dont have cluster how do we configure the backups such a way that even one node of the RAC is down , the backup should happen on another node without any manual intervention ? Thanks, SK197Views2likes0CommentsBackup of Oracle RAC. cluster is displayed as???
Good afternoon, I have a problem of how to add the cluster that hosts the Oracle RAC, what happens is that aggregates both my cluster servers to see my databases have added the servers where this cluster and I want to validate if the BACKUP EXEC 2012 to view the cluster nodes not. Urgent. Thank you.1.6KViews2likes11Commentsbacking up an oracle database
helo, I would like to get ideas regarding how to backup an oracle database, I am new to backup exec. Here is my structure. I have a windows server 2008 which runs backup exec 2010 (The oracle database will be backup to a folder in this server). I have another server which is rhel 5 (with an oracle 11g databse which i want to backup) with oracle backup agent installed. When i run symantec backup exec and try to browse through oracle databse i get the message "before you can select this resource for backup configure it using the remote agent utility also called vxmon.exe" as can be seen in the attachment. is it talking about the remote agent utility in linux or windows server? can anyone tell me the procedure that need to be in place to backup the oracle database. after searching i found an article about configuring "Configuring the Oracle Agent on Linux computers". but i am not sure exactly what procedures i should follow and what is the minimum configurations to do oracle backup. furthermore i have a concern. if i create an instance as described in the article will it have any effect on the databse as it is used by an application which is custom made or the instance is for the purposed of remote agent utility. attached find the screeshots of my windows and linux servers Thanks1.3KViews2likes6CommentsOracle 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.1KViews2likes5CommentsRMAN-06403 ORA-01034
When a trying a backup jobs, in Backup Exec 2012 show me log below: Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 21 11:59:10 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) connected to recovery catalog database # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE'; SEND 'BSA_SERVICE_HOST=192.168.63.189,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={B3689540-B745-4F67-8B2A-7853551612E3},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\DELLBL07\SW05'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BE_U' DATABASE FORCE PLUS ARCHIVELOG FORCE; BACKUP CURRENT CONTROLFILE FORMAT 'BE_U'; RELEASE CHANNEL ch0; } RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of allocate command at 05/21/2012 11:59:10 RMAN-06403: could not obtain a fully authorized session ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory EXIT Recovery Manager complete. _____________________ I have Windows 2k8R2 + Backup Exec 2012 + Recovery Catalog 192.168.63.189 TNSNAME: RMAN = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.189)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rman) ) ) SW05 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DELLBL07)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = SW051) ) ) TNSPING works fine to RMAN and SW05 __________________________ DELLBL07 192.168.63.152 Linux Red Hat Enterprise + Oracle11g oracle ON LINE: [root@DELLBL07 ~]# ps -ef | grep pmon grid 3145 1 0 Mar02 ? 00:03:11 asm_pmon_+ASM1 oracle 5933 1 0 May18 ? 00:00:07 ora_pmon_SW051 oracle 9827 1 0 Mar08 ? 00:08:34 ora_pmon_SW021 oracle 15061 1 0 Mar02 ? 00:06:04 ora_pmon_SW061 root 16265 12879 0 12:08 pts/1 00:00:00 grep pmon oracle 27820 1 0 Mar09 ? 00:08:11 ora_pmon_SW031 TNSPING to RMAN and SW05 okSolved8.1KViews2likes3CommentsOracle backup scheduled job is not starting
Hello! I have a problem with a scheduled Oracle backup that doesn't start. With the same client we run other backups (Standard policy + other Oracle instances) but we have the problem only with a particular policy. I run the command: /usr/openv/netbackup/bin/vxlogview -o 116 -t 3:00:00 And I found this error: 08/03/12 10:40:31.624 [Error] V-116-258 could not get last backup data for policy pol-vi1.eoe.ora.renetta.thoray48, client renetta.unix.t-systems.it, job(s) will not be run Every time I try to run the policy I get this error, also with "manual backup". I try to: - upgrade to 7.1.0.4 (master server + media server + client) - make a new policy but it didn't work. Actually I run the backup script directly from the client with a crontab. Please help me!!! Thank you very much SimoneSolved3.2KViews2likes13CommentsDoes More than one Techn work at Symantec?????
1. NO ONE IS ANSWERING THE PHONE ANYWHERE AT SYMANTEC 2. YOUR PHONE SYSTEM IS REPORTING 1 MIN THEN OVER AN HOUR 3. I WAS ON HOLD OVER TWO HOURS 4. I HAVE ANOTHER ISSUE WITH BACKUP EXEC 5. EVEN YOUR SYMANTEC OPERATORS CANT GET THROUGH TO SUPPORT 6. MY ONLINE SUPPORT IS IN AN ORIENTAL LANGUAGE 7. YOUR ONLINE CHAT SUPPORT DOESNT WORK. NOONE IS THERE EITHER I've been on hold all morning. Don't listen to "The Customer Hold the Longest. is X min. It goes up and down and noone ever answers.2KViews2likes7Comments