Johnson - Did Oracle Support offer any theories on why the RMAN channels
were being spontaneously released? Is Oracle Support looking into this as a
possible bug, and you are just checking to see whether anyone else has
experienced this behavior?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Tuesday, September 17, 2002 9:02 AM
To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'
Cc: 'joni_65_at_yahoo.com'
Oracle support too pointed to that. I tested with
allocating 3 more channnels after 'set newname'. But
no change. They were released. and same error
followed.
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Johnson
> From what I read of your trace file, the channels
> are being released,
> presumably just before you need them. Do you have
> that explicitly coded in
> your RMAN recovery script, or are they being
> released for another reason. My
> immediate response is that maybe the problem lies in
> why those channels are
> being released. Can you move your channel commands
> after the SET NEWNAME
> commands?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> <mailto:dwilliams_at_lifetouch.com>
>
>
> -----Original Message-----
> From: Johnson Poovathummoottil
> [mailto:joni_65_at_yahoo.com]
> Sent: Tuesday, September 17, 2002 9: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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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:13:22 CDT
