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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 10:20 AM > To: Mercadante, Thomas F; '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > 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" > <[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 > === 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: [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).
