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

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 25 Aug 2005 12:16:00 -0400
Message-ID: <004501c5a990$488aae00$6759000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]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>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 25 2005 - 11:18:06 CDT