RE: RMAN -ORA-19506: failed to create sequential file,

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <dba.orcl@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Aug 2005 12:16:00 -0400

Were there other error messages?  Did you check the permissions?:
19506, 00000, "failed to create sequential file, name=\"%s\", parms=\"%s\""
// *Cause:  call to create the sequential file returned an error
// *Action: check additional messages, check access permissions

Just a couple of things,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Sami Seerangan
Sent: Saturday, August 20, 2005 3:03 PM
To: oracle-l
Subject: RMAN -ORA-19506: failed to create sequential file,


Hi All,

Could someone help me here? I am getting ORA-19506: failed to create
sequential file error.

Solaris 64 bit,Oracle 64 bit, Version 9.2.0.6, Veritas Netbackup

njd01dsmdbc01 oracle dnet141 /opt/oracle/product/9.2.0/scripts
$ cd ${ORACLE_HOME}/lib

njd01dsmdbc01 oracle dnet141 /opt/oracle/product/9.2.0/lib
$ ls -l libobk.so
lrwxrwxrwx   1 oracle   dba           38 Aug  8 14:20 libobk.so ->
/usr/openv/netbackup/bin/libobk.so64.1*

njd01dsmdbc01 oracle dnet141 /opt/oracle/product/9.2.0/lib
$ mv libobk.so libobk.so.orig

njd01dsmdbc01 oracle dnet141 /opt/oracle/product/9.2.0/lib
$ ln -s /usr/openv/netbackup/bin/libobk.so64.1 libobk.so



RMAN> run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
backup
  incremental level 0
  skip inaccessible
  tag hot_db_bk_level0
  filesperset 5
  format 'bk_%s_%p_%t'
  (database);
}
2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
allocated channel: t1
channel t1: sid=22 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)

allocated channel: t2
channel t2: sid=23 devtype=SBT_TAPE
channel t2: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)

Starting backup at 20-AUG-05
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00005 name=/u05/oradata/dnet1/snapshot_ts_01.dbf
input datafile fno=00009 name=/u05/oradata/dnet1/tools_ts_01.dbf
input datafile fno=00003 name=/u05/oradata/dnet1/user01.dbf
input datafile fno=00008 name=/u05/oradata/dnet1/index_ts_01.dbf
channel t2: starting piece 1 at 20-AUG-05
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00007 name=/u05/oradata/dnet1/data_ts_01.dbf
input datafile fno=00001 name=/u05/oradata/dnet1/system01.dbf
input datafile fno=00002 name=/u05/oradata/dnet1/undo01.dbf
channel t1: starting piece 1 at 20-AUG-05
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t2 channel at 08/20/2005 14:55:38
ORA-19506: failed to create sequential file, name="bk_2_1_566837730",
parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   sbtbackup: Failed to open for backup.

RMAN>

Other related posts: