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----- Sent: Tuesday, September 17, 2002 9:23 AM To: Multiple recipients of list ORACLE-L 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). -- 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).
