RMAN PROBLEM PLEASE HELP URG.

From: Steve Robin <ocmaman_at_gmail.com>
Date: 20 Apr 2007 00:41:07 -0700
Message-ID: <1177054867.252835.76940@q75g2000hsh.googlegroups.com>

I am trying to make duplicate database using RMAN.

rman target sys/oracle_at_wot51idc auxiliary sys/t51idc_at_t51idc

RMAN> RUN

2> {
3> ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
4> duplicate target database to T51IDC;
5> }

using target database controlfile instead of recovery catalog allocated channel: aux1
channel aux1: sid=9 devtype=DISK

Starting Duplicate Db at 20-APR-07

printing stored script: Memory Script
{

   set until scn 8242876548650;
   set newname for datafile 1 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\SYSTEM01.DBF";
   set newname for datafile 3 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\CUSTWEB_DATA01.DBF";
   set newname for datafile 4 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\CUSTWEB_INDEX01.DBF";
   set newname for datafile 5 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_CATALOG_DATA01.DBF";
   set newname for datafile 6 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_CATALOG_INDEX01.DBF";
   set newname for datafile 7 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_NCR_INDEX01.DBF";
   set newname for datafile 8 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_OPP_INDEX01.DBF";
   set newname for datafile 9 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_STATIC_IX_01.DBF";
   set newname for datafile 10 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_STATIC_IX_PUS_01.DBF";
   set newname for datafile 11 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_STATIC_PUS_01.DBF";
   set newname for datafile 12 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\SYS01.DBF";
   set newname for datafile 13 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_DATA03.DBF";
   set newname for datafile 14 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\SYS02.DBF";
   set newname for datafile 15 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\TOOLS_01.DBF";
   set newname for datafile 16 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\USERS_01.DBF";
   set newname for datafile 17 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\USER01.DBF";
   set newname for datafile 18 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_DATA01.DBF";
   set newname for datafile 19 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_QUOTE_DATA03.DBF";
   set newname for datafile 20 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_DATA02.DBF";
   set newname for datafile 21 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_QUOTE_DATA02.DBF";
   set newname for datafile 22 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX04.DBF";
   set newname for datafile 23 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX01.DBF";
   set newname for datafile 24 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX03.DBF";
   set newname for datafile 25 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX02.DBF";
   set newname for datafile 26 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_QUOTE_INDEX01.DBF";
   set newname for datafile 27 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_SECURITY_DATA01.DBF";
   set newname for datafile 28 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_SECURITY_INDEX01.DBF";
   set newname for datafile 29 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_USER_DATA01.DBF";
   set newname for datafile 30 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_INTERFACE_IX_01.DBF";
   set newname for datafile 31 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_MEDIUM_IX_PUS_01.DBF";
   set newname for datafile 32 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_MEDIUM_PUS_01.DBF";
   set newname for datafile 33 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_USER_INDEX01.DBF";
   set newname for datafile 34 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_HIGH_IX_PUS_01.DBF";
   set newname for datafile 35 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_PART_TEMP_01.DBF";
   set newname for datafile 36 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_HIGH_PUS_01.DBF";
   set newname for datafile 37 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_INTERFACE_01.DBF";
   set newname for datafile 38 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\OA_STATIC_01.DBF";
   set newname for datafile 39 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_NCR_DATA01.DBF";
   set newname for datafile 40 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_OPP_DATA01.DBF";
   set newname for datafile 41 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_QUOTE_DATA01.DBF";
   set newname for datafile 42 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\UNDO101.DBF";
   set newname for datafile 46 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_CATALOG_DATA02.DBF";
   set newname for datafile 47 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_CATALOG_DATA03.DBF";
   set newname for datafile 48 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_CATALOG_INDEX16_01.DBF";
   set newname for datafile 49 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX101.DBF";
   set newname for datafile 50 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX201.DBF";
   set newname for datafile 51 to
"C:\SEAGATEDRIVE\C\ORADATA\T51IDC\MCC_PRICING_INDEX301.DBF";
   restore
   check readonly
   clone database
   ;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 20-APR-07

released channel: aux1
RMAN-00571:

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

RMAN-00571:

RMAN-03002: failure of Duplicate Db command at 04/20/2007 12:59:20
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 51 found to restore
RMAN-06023: no backup or copy of datafile 50 found to restore
RMAN-06023: no backup or copy of datafile 49 found to restore
RMAN-06023: no backup or copy of datafile 48 found to restore
RMAN-06023: no backup or copy of datafile 47 found to restore
RMAN-06023: no backup or copy of datafile 46 found to restore
RMAN-06023: no backup or copy of datafile 42 found to restore
RMAN-06023: no backup or copy of datafile 41 found to restore
RMAN-06023: no backup or copy of datafile 40 found to restore
RMAN-06023: no backup or copy of datafile 39 found to restore
RMAN-06023: no backup or copy of datafile 38 found to restore
RMAN-06023: no backup or copy of datafile 37 found to restore
RMAN-06023: no backup or copy of datafile 36 found to restore
RMAN-06023: no backup or copy of datafile 35 found to restore
RMAN-06023: no backup or copy of datafile 34 found to restore
RMAN-06023: no backup or copy of datafile 33 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

But backup is there. I just took the backup of target database and then doing this.

RMAN> LIST BACKUP; List of Backup Sets

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

1       Full    33G        DISK        01:54:36     20-APR-07
        BP Key: 1   Status: AVAILABLE   Tag: TAG20070420T093333
        Piece Name: C:\SEAGATEDRIVE\B\WOT51IDC\WOT51_1.BKP

Controlfile Included: Ckp SCN: 8242876550398 Ckp time: 20-APR-07 List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name

-- ---- ---------- --------- ---- 1 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \SYSTEM01.DBF 3 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \CUSTWEB_DATA01.DBF 4 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \CUSTWEB_INDEX01.DBF 5 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_CATALOG_DATA01.DBF 6 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_CATALOG_INDEX01.DBF 7 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_NCR_INDEX01.DBF 8 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_OPP_INDEX01.DBF 9 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_STATIC_IX_01.DBF 10 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_STATIC_IX_PUS_01.DBF 11 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_STATIC_PUS_01.DBF 12 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \SYS01.DBF 13 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_DATA03.DBF 14 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \SYS02.DBF 15 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \TOOLS_01.DBF 16 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \USERS_01.DBF 17 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \USER01.DBF 18 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_DATA01.DBF 19 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_QUOTE_DATA03.DBF 20 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_DATA02.DBF 21 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_QUOTE_DATA02.DBF 22 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX04.DBF 23 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX01.DBF 24 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX03.DBF 25 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX02.DBF 26 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_QUOTE_INDEX01.DBF 27 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_SECURITY_DATA01.DBF 28 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_SECURITY_INDEX01.DBF 29 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_USER_DATA01.DBF 30 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_INTERFACE_IX_01.DBF 31 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_MEDIUM_IX_PUS_01.DBF 32 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_MEDIUM_PUS_01.DBF 33 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_USER_INDEX01.DBF 34 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_HIGH_IX_PUS_01.DBF 35 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_PART_TEMP_01.DBF 36 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_HIGH_PUS_01.DBF 37 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_INTERFACE_01.DBF 38 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \OA_STATIC_01.DBF 39 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_NCR_DATA01.DBF 40 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_OPP_DATA01.DBF 41 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_QUOTE_DATA01.DBF 42 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \UNDO101.DBF 46 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_CATALOG_DATA02.DBF 47 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_CATALOG_DATA03.DBF 49 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX101.DBF 50 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX201.DBF 51 Full 8242876550411 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_PRICING_INDEX301.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

2       Full    321M       DISK        00:01:02     20-APR-07
        BP Key: 2   Status: AVAILABLE   Tag: TAG20070420T093333
        Piece Name: C:\SEAGATEDRIVE\B\WOT51IDC\WOT51_2.BKP

List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name

-- ---- ---------- --------- ---- 48 Full 8242876568378 20-APR-07 C:\SEAGATEDRIVE\A\WOT51IDC \MCC_CATALOG_INDEX16_01.DBF

RMAN> SHOW ALL; RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA90\DATABASE \SNCFWOT51IDC.ORA'; # default

Please help me in it.
database : oracle 9i (9.2.0.8.0)
OS : Windows

Thanks Received on Fri Apr 20 2007 - 02:41:07 CDT