my RMAN script is the following I have not released any channels explicitly.
run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; set newname for datafile 1 to '/extracts1/DB01_temp/system_01a.dbf'; set newname for datafile 2 to '/extracts1/DB01_temp/rbslrg01.dbf'; set newname for datafile 3 to '/extracts1/DB01_temp/tools01.dbf'; set newname for datafile 4 to '/extracts1/DB01_temp/temp01.dbf'; set newname for datafile 5 to '/extracts1/DB01_temp/usersdata01.dbf'; set newname for datafile 6 to '/extracts1/DB01_temp/usersidx01.dbf'; set newname for datafile 7 to '/extracts1/DB01_temp/oem_repository.dbf'; set newname for datafile 8 to '/extracts1/DB01_temp/users01.dbf'; restore database ; switch datafile all; } I tried allocating 3 additional channels just before 'restore database;' but they too were released along with the original 3 and the same error followed. --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Joni, > > It looks like you are releasing the channels before > you are finished with > them. > > Can you add another ALLOCATE CHANNEL command before > you attempt the RESTORE > command? > > You did not provide the rman commands, so I am only > guessing here - but that > is what the error is telling you. You do not have > any channel's available > for Rman to use. > > Good Luck. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > From: Johnson Poovathummoottil > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 10: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: 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).