Re: RMAN PROBLEM PLEASE HELP URG.

On Apr 20, 9:41 am, Steve Robin <ocma..._at_gmail.com> wrote:
> 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
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> 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

Backup needs to be accessible on *BOTH* servers, with identical names!

--
Sybrand Bakker
Senior Oracle DBA