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).
