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" <NDATFM_at_labor.state.ny.us>
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:joni_65_at_yahoo.com]
> 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: 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).
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 - 10:23:32 CDT
