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