I tried that too. But did it not help. here is the
ouput.
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
allocated channel: c1
channel c1: sid=10 devtype=DISK
allocated channel: c2
channel c2: sid=11 devtype=DISK
allocated channel: c3
channel c3: sid=12 devtype=DISK
Starting restore at 17-SEP-02
released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
RMAN-00569: =============== ERROR MESSAGE STACK
FOLLOWS ===============
RMAN-00571:
RMAN-03002: failure of restore command at 09/17/2002
10:29:13
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Johnson
> Their explanation doesn't make sense to me. I
> have had RMAN fail to get
> the backup piece, and the error message is very
> clear.
> Just in case the SET NEWNAME is somehow affecting
> the recovery, you might
> take them out just to see what happens. I would also
> have moved the ALLOCATE
> CHANNEL below the SET NEWNAME, rather than opening a
> new set of channels,
> but then I haven't used SET NEWNAME. I just had my
> Unix sys admin create
> mount points named the same as the mount points on
> the production system.
> Perhaps someone can post an RMAN recovery script
> that includes a SET
> NEWNAME, so you can compare. You might also post
> your recovery script, that
> might clarify something.
> Also, this is Oracle 9.2, and most of my RMAN
> practice has been on Oracle
> 8.1.6.
> Another thought for a test is to backup the
> production control file
> separately and then place it where it is needed,
> rather than have RMAN
> recover it. I'm just wondering whether you are
> getting some side-effect from
> the successful control file recovery.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> <mailto:dwilliams_at_lifetouch.com>
>
>
> -----Original Message-----
> From: Johnson Poovathummoottil
> [mailto:joni_65_at_yahoo.com]
> Sent: Tuesday, September 17, 2002 9:16 AM
> To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'
> Subject: RE: RMAN restore to another node
>
>
> They are alluding it to a possibilty that RMAN
> cannot
> find the backup piece and just before showing the
> error it realeasing channels and that releasing
> channels per se does not point to any problem.
>
> --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> > Johnson - Did Oracle Support offer any theories on
> > why the RMAN channels
> > were being spontaneously released? Is Oracle
> Support
> > looking into this as a
> > possible bug, and you are just checking to see
> > whether anyone else has
> > experienced this behavior?
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> > <mailto:dwilliams_at_lifetouch.com>
> >
> >
> > -----Original Message-----
> > From: Johnson Poovathummoottil
> > [mailto:joni_65_at_yahoo.com]
> > Sent: Tuesday, September 17, 2002 9:02 AM
> > To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'
> > Cc: 'joni_65_at_yahoo.com'
> > Subject: RE: RMAN restore to another node
> >
> >
> > Oracle support too pointed to that. I tested with
> > allocating 3 more channnels after 'set newname'.
> But
> > no change. They were released. and same error
> > followed.
> >
> > --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> wrote:
> > > Johnson
> > > From what I read of your trace file, the
> > channels
> > > are being released,
> > > presumably just before you need them. Do you
> have
> > > that explicitly coded in
> > > your RMAN recovery script, or are they being
> > > released for another reason. My
> > > immediate response is that maybe the problem
> lies
> > in
> > > why those channels are
> > > being released. Can you move your channel
> commands
> > > after the SET NEWNAME
> > > commands?
> > >
> > > Dennis Williams
> > > DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > > <mailto:dwilliams_at_lifetouch.com>
> > >
> > >
> > > -----Original Message-----
> > > From: Johnson Poovathummoottil
> > > [mailto:joni_65_at_yahoo.com]
> > > Sent: Tuesday, September 17, 2002 9:23 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RMAN restore to another node
> > >
> > >
> > > Hi all,
> > >
> > > I am stuck on this restore for two days and
> Oracle
> > > support seems to offering little help.
> > >
> > > I seem to be doing everything according to
> manuals
> > > and
> > > metalink notes but am not able to do the
> restore.
> > >
> > > The case is I am restoring a database to another
> > > node.
> > > I have successfully restore the control file but
> > > when
> > > I tried to restore the database I get
> > > RMAN-06100: no channel to restore a backup or
> copy
> > > of
> > > datafile 1
> > > for every datafile.
> > >
> > > I am inserting the RMAN trace . I would
> appreciate
> > > if
> > > someone can lead in the right direction.
> > > Recovery Manager: Release 9.2.0.1.0 - Production
> > >
> > > Copyright (c) 1995, 2002, Oracle Corporation.
> All
> > > rights reserved.
> > >
> > > ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
> > > System name: SunOS
> > > Node name: EdwDev
> > > Release: 5.8
> > > Version: Generic_108528-15
> > > Machine: sun4u
> > >
> > > Starting with debugging turned off
> > >
> > > connected to target database: DB01 (not mounted)
> > > using target database controlfile instead of
> > > recovery
> > > catalog
> > >
> > > RMAN>
> > > executing command: SET DBID
> > >
> > > RMAN> 2> 3> 4>
> > > allocated channel: ci
> > > channel ci: sid=10 devtype=DISK
> > >
> > > Starting restore at 17-SEP-02
> > >
> > > channel ci: restoring controlfile
> > > channel ci: restore complete
> > > replicating controlfile
> > > input filename=/extracts1/DB01_temp/ctrl1.ctl
> > > output filename=/extracts1/DB01_temp/ctrl2.ctl
> > > output filename=/extracts1/DB01_temp/ctrl3.ctl
> > > Finished restore at 17-SEP-02
> > > released channel: ci
> > >
> > > RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
> 14>
> > > 15>
> > > 16>
> > > allocated channel: c1
> > > channel c1: sid=10 devtype=DISK
> > >
> > > allocated channel: c2
> > > channel c2: sid=11 devtype=DISK
> > >
> > > allocated channel: c3
> > > channel c3: sid=12 devtype=DISK
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
>
=== message truncated ===
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 17 2002 - 10:43:29 CDT
