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
> >
> > executing command: SET NEWNAME
> >
> > executing command: SET NEWNAME
> >
> > executing command: SET NEWNAME
> >
> > executing command: SET NEWNAME
> >
> > executing command: SET NEWNAME
> >
> > executing command: SET NEWNAME
> >
> > 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
> > 08:27:16
> > 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
> >
> >
> >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! News - Today's headlines
> > http://news.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
>
=== 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:18:27 CDT
