Getting ORA-19554: error allocating device, device type: DISK, device name:
552091Apr 19 2007 — edited Apr 20 2007Trying to clone the database through RMAN and these are the steps I am performing..
RMAN> run {
2> allocate auxiliary channel t1 type 'disk';
3> allocate auxiliary channel t2 type 'disk';
4> set until time "to_date('04/18/2007 12:10','MM/DD/YYYY HH24:MI')";
5> set newname for datafile 1 to '/g04/oradata/DVCUSTDB/system01.dbf';
6> set newname for datafile 2 to '/g04/oradata/DVCUSTDB/undotbs01.dbf';
7> set newname for datafile 3 to '/g05/oradata/DVCUSTDB/undotbs02.dbf';
8> set newname for datafile 4 to '/g02/oradata/DVCUSTDB/cg_data01.dbf';
9> set newname for datafile 5 to '/g02/oradata/DVCUSTDB/cg_data02.dbf';
10> set newname for datafile 6 to '/g02/oradata/DVCUSTDB/cg_data03.dbf';
11> set newname for datafile 7 to '/g02/oradata/DVCUSTDB/cg_data04.dbf';
12> set newname for datafile 8 to '/g03/oradata/DVCUSTDB/cg_index01.dbf';
13> set newname for datafile 9 to '/g03/oradata/DVCUSTDB/cg_index02.dbf';
14> set newname for datafile 10 to '/g03/oradata/DVCUSTDB/cg_index03.dbf';
15> set newname for datafile 11 to '/g02/oradata/DVCUSTDB/cgadmin_data01.dbf';
16> set newname for datafile 12 to '/g03/oradata/DVCUSTDB/cgadmin_index01.dbf';
17> set newname for datafile 13 to '/g04/oradata/DVCUSTDB/tools01.dbf';
18> duplicate target database to "dvcustdb"
19> LOGFILE
20> GROUP 1 (
21> '/g06/oradata/DVCUSTDB/redo01a.log',
22> '/g06/oradata/DVCUSTDB/redo01b.log'
23> ) SIZE 32768K,
24> GROUP 2 (
25> '/g06/oradata/DVCUSTDB/redo02a.log',
26> '/g06/oradata/DVCUSTDB/redo02b.log'
27> ) SIZE 32768K,
28> GROUP 3 (
29> '/g06/oradata/DVCUSTDB/redo03a.log',
30> '/g06/oradata/DVCUSTDB/redo03b.log'
31> ) SIZE 32768K;
32> release channel t1;
33> release channel t2;
34> }
And getting the Following Errors.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 04/18/2007 20:24:36
ORA-19554: error allocating device, device type: DISK, device name:
ORA-27001: unsupported device type
Additional information: 1
And here are the RMAN Setting
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/PRCUSTDB/tdpo.opt)';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/g01/app/oracle/product/9.2.0/dbs/snapcf_PRCUSTDB.f';
I don't know Why I am getting this Error,
Please Suggest
Munish Tandon