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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> 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: [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).


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

Reply via email to