Re: RMAN on tape drive

This may be a complete red-herring, but I was rather under the impression that the 'format' keyword was a qualifier to the 'backup' job, not to the channel declaration.

I *think* that the syntax will be more correct if it looks vaguely like the following:

run {
allocate channel tape001 type 'SBT_TAPE'; sql 'alter system switch logfile';
backup
( format 'b_%u_%s_%p'
datafile 'D:\ORANT\ORADATA\BKUP\BKDAT01.DBF' include current controlfile);
backup ( archivelog all setsize 204800 ); }

Incidentally, your original post included a single quote after the "%p" bit of the format line, which would throw the thing out, even if otherwise RMAN could deal with the misplaced syntax.

I'd also be slightly concerned that you are trying to backup a single datafile already in existence called 'bkdat01.dbf'. One would have thought that with a 'format' command such as you seem to want to include, the line might more plausibly read 'database', not 'datafile blahblahblah'.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"Jasmine Cheung" <hkrunner_at_hongkong.com> wrote in message
news:8u8itn$2g8$1_at_nnrp1.deja.com...


> I encounter the following problem when I try to backup the datafile to

> a tape drive which can be seen on NTBackup.

>

> Can anyone please help to solve this?

>

> -----------------------------------------------------------------

> Recovery Manager: Release 8.1.5.0.0 - Production

>

> RMAN-06005: connected to target database: BKUP (DBID=1619370747)

> RMAN-06009: using target database controlfile instead of recovery

> catalog

>

> RMAN> run {

> 2> allocate channel tape001 type 'SBT_TAPE'  format 'b_%u_%s_%p';

> 3> sql 'alter system switch logfile';

> 4> backup

> 5>    ( datafile 'D:\ORANT\ORADATA\BKUP\BKDAT01.DBF'

> 6>   include current controlfile );

> 7> backup  ( archivelog all  setsize 204800 );

> 8> }

> 9>

> RMAN-03022: compiling command: allocate

> RMAN-03023: executing command: allocate

> RMAN-00571: ===========================================================

> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

> RMAN-00571: ===========================================================

> RMAN-03007: retryable error occurred during execution of command:

> allocate

> RMAN-07004: unhandled exception during command execution on channel

> tape001

> RMAN-10035: exception raised in RPC: ORA-19554: error allocating

> device, device type: SBT_TAPE, device name:

> ORA-19557: device error, device type: SBT_TAPE, device name:

> ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

> OSD-00000: Message 0 not found;  product=RDBMS; facility=SOSD

>  (OS 4110)

> ORA-19511: SBT error = 4110, errno = 0, BACKUP_DIR environment variable

> is not set

> RMAN-10031: ORA-19624 occurred during call to

> DBMS_BACKUP_RESTORE.DEVICEALLOCATE

>

> -----------------------------------------------------------------

>

> --

> Jasmine Cheung

>

> hkrunner_at_hongkong.com

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.