| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN restore to another node
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-----
Sent: Tuesday, September 17, 2002 10: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
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).
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 - 10:13:23 CDT
 |
 |