Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN restore to another node

RE: RMAN restore to another node

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Tue, 17 Sep 2002 09:48:27 -0800
Message-ID: <F001.004D181E.20020917094827@fatcity.com> 





You are allocating an auxilliary channel?



connect catalog rman/manager_at_rcat


connect target system/manager_at_db1


connect auxiliary "system/manager as sysdba"



run {


set until time '17-SEP-2002 08:30:39';


allocate auxiliary channel disk1 type disk;


set newname for datafile 1 to '/ot2_01/oradata/db1/system01.dbf';
set newname for datafile 2 to '/ot2_01/oradata/db1/undotbs01.dbf';
set newname for datafile 3 to '/ot2_01/oradata/db1/drsys01.dbf';


...


set newname for datafile 70 to '/ot2_01/oradata/db1/users01.dbf';
duplicate target database to db2

logfile '/ot2_01/oradata/db2/redo01.log' size 100M,
'/ot2_01/oradata/db2/redo02.log' size 100M,
'/ot2_01/oradata/db2/redo03.log' size 100M;


}







>From: Johnson Poovathummoottil <joni_65_at_yahoo.com>

>Reply-To: ORACLE-L_at_fatcity.com

>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

>Subject: RE: RMAN restore to another node

>Date: Tue, 17 Sep 2002 07:43:28 -0800

>

>I tried that too. But did it not help. here is the

>ouput.

>

>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

>

>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

>

>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

>10:29:13

>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

>

>

>--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:

> > Johnson

> >    Their explanation doesn't make sense to me. I

> > have had RMAN fail to get

> > the backup piece, and the error message is very

> > clear.

> >    Just in case the SET NEWNAME is somehow affecting

> > the recovery, you might

> > take them out just to see what happens. I would also

> > have moved the ALLOCATE

> > CHANNEL below the SET NEWNAME, rather than opening a

> > new set of channels,

> > but then I haven't used SET NEWNAME. I just had my

> > Unix sys admin create

> > mount points named the same as the mount points on

> > the production system.

> >    Perhaps someone can post an RMAN recovery script

> > that includes a SET

> > NEWNAME, so you can compare. You might also post

> > your recovery script, that

> > might clarify something.

> >    Also, this is Oracle 9.2, and most of my RMAN

> > practice has been on Oracle

> > 8.1.6.

> >    Another thought for a test is to backup the

> > production control file

> > separately and then place it where it is needed,

> > rather than have RMAN

> > recover it. I'm just wondering whether you are

> > getting some side-effect from

> > the successful control file recovery.

> >  

> > 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:16 AM

> > To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'

> > Subject: RE: RMAN restore to another node

> >

> >

> > They are alluding it to a possibilty that RMAN

> > cannot

> > find the backup piece and just before showing the

> > error it realeasing channels and that releasing

> > channels per se does not point to any problem.

> >

> > --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:

> > > 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-----

> > > From: Johnson Poovathummoottil

> > > [mailto:joni_65_at_yahoo.com]

> > > Sent: Tuesday, September 17, 2002 9:02 AM

> > > To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'

> > > Cc: 'joni_65_at_yahoo.com'

> > > Subject: RE: RMAN restore to another node

> > >

> > >

> > > 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

> > > >

> >

>=== message truncated ===

>

>

>__________________________________________________

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









Chat with friends online, try MSN Messenger: http://messenger.msn.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Killough
  INET: mwkillough_at_hotmail.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 - 12:48:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US