Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN PROBLEM PLEASE HELP URG.
On Apr 20, 5:16 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net>
wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Thanks for your help.
No I have not created Controlfile. As I had shown, when I do list
backup, it shows backup is there.
Received on Sun Apr 22 2007 - 23:13:03 CDT