Forum Discussion

Yousfani's avatar
Yousfani
Level 2
17 years ago

Oracle backup fails

Hi
 
         My backup policy failing with following error message while taking oracle DB backup using veritas Netbackup 6.5.
 
Note : I am taking this backup on disk storage not on tape.
------------------------------------------------------------------------------------------------------------------------------
 
 SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Recovery Manager: Release 10.2.0.2.0 - Production on Wed Nov 21 16:32:50 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: TEST10 (DBID=3296918071, not open)
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
allocated channel: ch00
channel ch00: sid=156 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)
sent command to channel: ch00
Starting backup at 21-NOV-07
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\ORADATA\TEST10\SYSTEM01.DBF
input datafile fno=00002 name=E:\ORACLE\ORADATA\TEST10\UNDOTBS01.DBF
input datafile fno=00003 name=E:\ORACLE\ORADATA\TEST10\SYSAUX01.DBF
input datafile fno=00005 name=E:\ORACLE\ORADATA\TEST10\EXAMPLE01.DBF
input datafile fno=00004 name=E:\ORACLE\ORADATA\TEST10\USERS01.DBF
channel ch00: starting piece 1 at 21-NOV-07
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 11/21/2007 16:48:20
ORA-19506: failed to create sequential file, name="bk_p_t", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  Communication with the server has not been iniatated or the server status has not been
retrieved from the serve
RMAN>
Recovery Manager complete.
 
----------------------------------------------------------------------------------------------------------------------------------------
 
Can someone help me regarding above problem.
 
Regards
Adeel

2 Replies

  • Hi,
     
        This sounds like a communication issue, have u tryied to run a normal OS or file backup? just to be sure that your master/media is able to see the client and perform good backups?
     
     
    Please let us know.
    Regards
  • These are important lines:
    ORA-19511: Error received from media manager layer, error text:
       VxBSACreateObject: Failed with error:
       Server Status:  Communication with the server has not been iniatated or the server status has not been
    retrieved from the serve
    ------------------------------------------------------------------------------
    The "media manager layer"  is the oracle rman media manager and has nothing to do with netbackup. 
    Here it is reporting a ORA-19511 error.    All ORA-19511 errors are those that have returned by the third party backup software, in this case NBU.    
    The next two lines are netbackup errors.  The third party software errors are displayed as they were issued i.e oracle rman does not attempt translate or add to the errors.  Start  diagnostocs as you would for any  comms failures also rman is pedantic when it comes to hostname:IP resolution.