I configure RMAN to backup to disk, install Litespeed Engine for Oracleand run the command as per below;
RMAN>
run
2> { allocate channel ch1 type sbt_tape
PARMS=SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/xxxxxxx/xxxxx/rman);
3> backup tablespace LLLLL
format=leo:///xxxxxxx/xxxxx/rman/db_%p.dat;
4> }
allocated channel: ch1
channel ch1: sid=965 devtype=SBT_TAPE
channel ch1: WARNING: Oracle Test Disk API
Starting backup at 11.02.2009
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00004 name=/xxxxx/oradata/xxxxx/users1.dbf
channel ch1: starting piece 1 at 11.02.2009
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 02/11/2009
12:12:37
ORA-19506: failed to create sequential file,
name=leo:///xxxxxxx/xxxxx/rman/db_1.dat, parms=
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
sbtpvt_open_output: file
/xxxxxxxx/xxxxx/rman/leo:///xxxxxxx/xxxxx/rman/db_1.dat, error
calling open(), errno = 2
In the query, user has changed the default LEO backup channel as setup for RMAN using the command
allocate channel ch1 type sbt_tape
However, the second part of syntax is wrong. The test media manager doesnt know anything about the leo:// syntax
RMAN wont be able to communicate with LEO therefore.
See below for sample correct scripts
1.
run
{
allocate channel ch1 type sbt_tape;
backup tablespace users format=/xxxxxxx/xxxxx/rman/db_%s_%p.dat;
}
2.
The BACKUP_DIR parameter is something specific to Oracle test media manager. LEO will ignore this.
If you insist on using the Oracle test media manager, you will have to change the file name.
The directory name is specified in the BACKUP_DIR parameter so it shouldnt appear in the command.
run
{
allocate channel ch1 type sbt_tape PARMS=SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/xxxxxxx/xxxxx/rman);
backup tablespace users format=db_%s_%p.dat;
}
