RMAN restore to another node

From: Johnson Poovathummoottil <joni_65_at_yahoo.com>
Date: Tue, 17 Sep 2002 06:23:25 -0800
Message-ID: <F001.004D11A3.20020917062325@fatcity.com>

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

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

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: joni_65_at_yahoo.com

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: ListGuru_at_fatcity.com (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). Received on Tue Sep 17 2002 - 09:23:25 CDT