Backup control file with RMAN. 9i makes it easy with the use of 'configure controlfile autobackup on'. In 8i 'backup current controlfile'
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Johnson - Congratulations on solving your problem > and thank you for sharing > the solution with the rest of us that are in the > same boat. When you say you > are taking a backup of the control files after the > regular backup, are you > backing the control files up with RMAN or with the > system command? > > � > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > -----Original Message----- > Sent: Wednesday, September 18, 2002 9:13 AM > To: Multiple recipients of list ORACLE-L > > > Thanks to all who replied. I got a lot of hints from > all. > > The problem I had was because I was not separately > backuping up the control files. I was relying on the > control files backup included in the full database > backups. These control files do not have details > about > the current backup. So when that control file is > restored, since it does not have a details about the > latest backup to disk(backup to disk was done for > test > purpose, this database was beeing backed up to > tape), > and since according to it the lastest backup was to > tape, it was looking for channel to go to tape and > finding none gave the 'no channel error'. > > The remedy is to take backup of control files after > the backup regular backups (tested works fine). or > use recovery catalog and use auxliary connection > (still to test). > > In 9i setting autobackup on does a separate backup > of > the control file. > > > --- Ruth Gramolini <[EMAIL PROTECTED]> > wrote: > > Do you have your backup restored to the box you > are > > trying to restore from? > > I > > Have you build a database to hold the restored > data? > > If so, are all of the tablespaces and datafiles > the > > same name on the box you > > are restoring to? > > We need more information to help you further. > > > > Regards, > > Ruth > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Tuesday, September 17, 2002 11:18 AM > > > > > > 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 <[EMAIL PROTECTED]> > 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. > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -----Original Message----- > > > From: Johnson Poovathummoottil > > > [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 9:02 AM > > > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' > > > Cc: '[EMAIL PROTECTED]' > > > 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 <[EMAIL PROTECTED]> > > 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. > > > > [EMAIL PROTECTED] > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > -----Original Message----- > > > > From: Johnson Poovathummoottil > > > > [mailto:[EMAIL PROTECTED]] > > > > 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 > > > > > === 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).
