RMAN-03009 ORA-19506 ORA-27028 ORA-19511 error while configure oracle backup in veritas netbackup
When i’m trying configure oracle backup on veritas netbackup, it showing the below errors
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> allocated channel: ch00 channel ch00: sid=125 devtype=SBT_TAPE channel ch00: Symantec/BackupExec/1.1.0 allocated channel: ch01 channel ch01: sid=90 devtype=SBT_TAPE channel ch01: Symantec/BackupExec/1.1.0 Starting backup at 2011-10-30:14:34:49 channel ch00: starting incremental level 0 datafile backupset channel ch00: specifying datafile(s) in backupset input datafile fno=00005 name=H:\BROKER\PACE01.DBF input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\UNDOTBS01.DBF input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSAUX01.DBF input datafile fno=00014 name=H:\BROKER\PACE04.DBF input datafile fno=00012 name=D:\CIGNATBS\CCIDATA01.DBF input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\USERS01.DBF input datafile fno=00007 name=D:\ORACLE\CATALOG\BROKER\RMAN01.DBF channel ch00: starting piece 1 at 2011-10-30:14:34:50 channel ch01: starting incremental level 0 datafile backupset channel ch01: specifying datafile(s) in backupset input datafile fno=00006 name=H:\BROKER\FACE01.DBF input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSTEM01.DBF channel ch01: starting piece 1 at 2011-10-30:14:34:51 RMAN-03009: failure of backup command on ch00 channel at 10/30/2011 14:34:52 ORA-19506: failed to create sequential file, name="bk_uhsmqdf8a_s1596_p1_t765902090", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: BEError(0x80004005) Unspecified error
Cause :
The problem has occured because I have already configured symantec backup exec agent software on particular database server, So it has created own orasbt.dll file in c:\windows\system32 directory and that particular database sbt device is configured with symantec backup exec . While the existing system running, I installed veritas netbackup client agent also on the same server without removing symantec backup exec and removed orasbt.dll file.
If symantec backup exec is already install on the same server, and if we are trying to install netbackup then it does not overwrite on orasbt.dll file.
This is the reason when i take backup, the allocated channel showing symantec backup exec not veritas oracle netbackup.
Solution :
Uninstall Both client software (Symantec Backup exec and Vertias ntbackup)
delete orasbt.dll file from “C:\windows\system32\”
Install again Veritas Oracle netbackup. Now Its works fine.
RMAN> run { 2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; 3> SEND 'NB_ORA_SERV=xxxxxx.ace-ins.com,NB_ORA_CLIENT=yyyyyy.ace-ins.com,N B_ORA_POLICY=dbtest'; 4> BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_u%u_s%s_p%p_t%t' DATABASE; 5> } allocated channel: ch00 channel ch00: sid=147 devtype=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.0 (20100104) sent command to channel: ch00 Starting backup at 31-OCT-11 channel ch00: starting incremental level 0 datafile backupset channel ch00: specifying datafile(s) in backupset input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSTEM01.D BF input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSAUX01.D BF
Nice post, Mohamed.
I would like to add that it is true for any backup agent that links to Oracle via shared library. It is always a good idea to remove the old agent and its orasbt.dll before installing the new agent.