RMAN-06100: no channel to restore a backup or copy of datafile 51
Oracle 10.2.0.4
I am attempting to duplicate a database from a full backup that was written to tape. I connect to a catalog, the target, and an auxilliary database. I allocate channels for disk and allocate auxiliary channels. For testing purposes I am trying to restore one data file from tape to disk but get RMAN-06100.
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 23 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/xxxxx/oracle/tivoli/ndk8oasu181.opt)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/xxxx/oracle/product/1020/db_1/dbs/snapcf_prd002l.f'; # default
RMAN> run
2> { allocate channel d01 type disk;
3> allocate channel d02 type disk;
4> allocate channel d03 type disk;
5> allocate channel d04 type disk;
6> allocate channel d05 type disk;
7> allocate auxiliary channel stby01 type disk;
8> allocate auxiliary channel stby02 type disk;
9> set newname for datafile '/xxxxxx/d01/oradata/prd002l/patdata01.dbf' to '/xxxxxx/d26/oradata/prd002lp/patdata01.dbf';
10> restore datafile '/xxxxxx/d01/oradata/prd002l/patdata01.dbf';
11> release channel ch01;
12> release channel ch02;
13> }
starting full resync of recovery catalog
full resync complete
allocated channel: d01
channel d01: sid=1859 devtype=DISK
allocated channel: d02
channel d02: sid=1825 devtype=DISK
allocated channel: d03
channel d03: sid=2252 devtype=DISK
allocated channel: d04
channel d04: sid=1978 devtype=DISK
allocated channel: d05
channel d05: sid=1906 devtype=DISK
allocated channel: stby01
channel stby01: sid=1406 devtype=DISK
allocated channel: stby02
channel stby02: sid=1462 devtype=DISK
executing command: SET NEWNAME
Starting restore at 12-MAY-11
released channel: d01
released channel: d02
released channel: d03
released channel: d04
released channel: d05
released channel: stby01
released channel: stby02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/12/2011 08:00:46
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 51