Re: RMAN PROBLEM PLEASE HELP URG.

On Fri, 20 Apr 2007 00:41:07 -0700, Steve Robin wrote:

> I am trying to make duplicate database using RMAN.

That's commendable.

>
> 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
> 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

OK, the problem is that RMAN, for some reason, doesn't see your backup. Do me a favor and execute the following command: connect target /
run {
allocate channel c0 device type disk;
restore database validate;
}

After that, post the results. This mostly happens when the backup is not in the control file. Have you re-created your control file?

-- 
http://www.mladen-gogala.com