使用oracle查询hp dp,dp – OracleBlog

RMAN> run{

2> allocate channel t1 type 'sbt_tape' ;

3> allocate channel t2 type 'sbt_tape' ;

4> backup datafile 3

5> format 'test_bk_%u_%p_%s.RMN'

6> include current controlfile;

7> }

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

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

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

RMAN-03009: failure of allocate command on t1 channel at 09/01/2007 04:25:21

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2

RMAN>

################################

###### 但是备份到disk却没有问题

################################

RMAN>

RMAN>

RMAN>

RMAN> run{

2> allocate channel t1 type disk ;

3> allocate channel t2 type disk ;

4> backup datafile 2

5> format '/iarch/test_bk_%u_%p_%s.RMN'

6> include current controlfile;

7> }

allocated channel: t1

channel t1: sid=58 devtype=DISK

allocated channel: t2

channel t2: sid=70 devtype=DISK

Starting backup at 01-SEP-07

channel t1: starting full datafile backupset

channel t1: specifying datafile(s) in backupset

including current controlfile in backupset

channel t1: starting piece 1 at 01-SEP-07

channel t2: starting full datafile backupset

channel t2: specifying datafile(s) in backupset

input datafile fno=00002 name=/dev/vg_iora01/rdata_1g_001

channel t2: starting piece 1 at 01-SEP-07

channel t1: finished piece 1 at 01-SEP-07

piece handle=/iarch/test_bk_01iqqmc8_1_1.RMN comment=NONE

channel t1: backup set complete, elapsed time: 00:00:04

channel t2: finished piece 1 at 01-SEP-07

piece handle=/iarch/test_bk_02iqqmca_1_2.RMN comment=NONE

channel t2: backup set complete, elapsed time: 00:00:37

Finished backup at 01-SEP-07

released channel: t1

released channel: t2

RMAN>