On Apr 23, 8:50 pm, Keith <kkna..._at_gmail.com> wrote:
> 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-Hidequoted 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.- Hide quoted text -
>
> - Show quoted text -
Thank you all again and again.
It was the problem with disk, it was connected with USB port, and for
any reason it was getting disconnected and then automatically
connected again and again. Now it is ok.
Thanks a lot for your help
Received on Wed Apr 25 2007 - 01:45:53 CDT
