OK. I'll ask.
Where is the backup piece? Is it in a same named directory as in the other
machine?
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, September 17, 2002 12:48 PM
To: Multiple recipients of list ORACLE-L
I am restoring the whole database.
regarding RMAN-06026 I think RMAN is not able to
find where my backup piece is. For the controlfile I
could specify 'restore from' whereas that is not
allowed for database or datfiles.
- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
wrote:
> My other question is, why are you getting this
> error:
>
> > RMAN-06026: some targets not found - aborting
> restore
>
>
> Are you trying to restore all of the files, are just
> some of them?
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> From: Johnson Poovathummoottil
> [mailto:joni_65_at_yahoo.com]
> Sent: Tuesday, September 17, 2002 10:20 AM
> To: Mercadante, Thomas F; 'ORACLE-L_at_fatcity.com'
> Cc: 'joni_65_at_yahoo.com'
> Subject: RE: RMAN restore to another node
>
>
> 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
>
=== message truncated ===
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us
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 - 13:23:30 CDT