Testing a duplicate of 9.2.0.1.0, I had that problem of channels releasing and then getting an error about no channel, and it turned out I needed a new MML library for 9i.
Now I have a problem that I can't restore the database unless I first delete all old datafiles. This behavior is different than old versions, and in my opinion, a bug. Have others encountered this issue? Debi At 07:13 AM 9/17/2002 -0800, you 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. >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > >-----Original Message----- >Sent: Tuesday, September 17, 2002 9:02 AM >To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' >Cc: '[EMAIL PROTECTED]' > > >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 <[EMAIL PROTECTED]> 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. > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > > > > > -----Original Message----- > > From: Johnson Poovathummoottil > > [mailto:[EMAIL PROTECTED]] > > 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 > > -- > > Author: Johnson Poovathummoottil > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > >__________________________________________________ >Do you Yahoo!? >Yahoo! News - Today's headlines >http://news.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).