Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN PROBLEM PLEASE HELP URG.

Re: RMAN PROBLEM PLEASE HELP URG.

From: Keith <kknauss_at_gmail.com>
Date: 23 Apr 2007 08:50:43 -0700
Message-ID: <1177343443.221545.268930@l77g2000hsb.googlegroups.com>


On Apr 23, 12:13 am, Steve Robin <ocma..._at_gmail.com> wrote:
> 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.

LIST BACKUP shows you backups the control file (or catalog) is aware of... it doesn't necessarily mean "backup is there"... as the other posters pointed out, the physical backup needs to be accessible from the auxiliary database server. You haven't clarified if that's the case or not. Received on Mon Apr 23 2007 - 10:50:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US